Click here to Skip to main content
14,972,640 members

Comments by Mathiudi (Top 29 by date)

Mathiudi 15-Apr-21 12:25pm View
   
No one want to help. Alright.
Mathiudi 14-Apr-21 19:37pm View
   
Hellooooo
Mathiudi 2-Feb-21 7:09am View
   
Okay Thanks
Mathiudi 2-Feb-21 7:08am View
   
So please what is the best practice. Any help?
Mathiudi 27-Mar-19 12:00pm View
   
public Task<list<commoditylist>> GetComosAsync()
{
return db.Table<commoditylist>().ToListAsync();
}
public Task<commoditylist> GetComoAsync(int id)
{
return db.Table<commoditylist>()
.Where(i => i.Id == id)
.FirstOrDefaultAsync();
Mathiudi 27-Mar-19 12:00pm View
   
protected override async void OnAppearing()
{
base.OnAppearing();

lvCommodity.ItemsSource = await App.SQLiteDb.GetComosAsync();
}
Mathiudi 6-Mar-17 10:35am View
   
Thanks, but how to call this function in a button click?
Mathiudi 4-Oct-16 7:12am View
   
Thank you for your concern and for your support and time. I tried your code it did not work. May be due to the sql 2008 express I;m using. Below is the code i came up with and it is working for me. Thank you all.


SELECT K.cust_id,K.acc_date,K.acc_details,K.debit,K.credit

,Sum(B.credit - B.debit) As Balance

from cust_account_t K
Inner Join
cust_account_t B
On K.acc_date >= B.acc_date
And B.cust_id <= K.cust_id
Group BY K.cust_id,K.acc_date,K.acc_details,K.debit,K.credit
Mathiudi 3-Oct-16 14:05pm View
   
OK. What I want is, Let say on 1/4/2014 a customer made a deposit $100,000, If we are to print a statement for that customer, the statement should read below and so forth:

Date Details Debit Credit Balance
1/4/2014 Deposit 0.00 100,000.00 100,000.00
Mathiudi 3-Oct-16 13:55pm View
   
I'm vert sorry. I'm under pressure here. Thanks for your reminders.

Can any body help me solve this?.
Mathiudi 6-Sep-16 5:56am View
   
PRIMARY KEY (`coa_id`)
Mathiudi 5-Sep-16 10:22am View
   
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('1', '2014-09-01', 'Cash at Vault', '500000.0000', '0.0000');
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('2', '2014-09-01', 'Savings', '0.0000', '500000.0000');
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('3', '2014-09-01', 'Cash at Vault', '10000.0000', '0.0000');
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('4', '2014-09-01', 'Income from Stock', '0.0000', '10000.0000');
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('5', '2014-09-01', 'Cash at Vault', '5000.0000', '0.0000');
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('6', '2014-09-01', 'Income from SPLASH', '0.0000', '5000.0000');
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('7', '2014-09-03', 'Savings', '50000.0000', '0.0000');
INSERT INTO `proaccounting`.`journal_voucher_t` (`jv_id`, `jv_date`, `coa_name`, `debit`, `credit`) VALUES ('8', '2014-09-03', 'Cash at Vault', '0.0000', '50000.0000');
Mathiudi 5-Sep-16 10:21am View
   
data for chart_of_account_t

INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('1', '1000', 'Cash at Vault', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('2', '1005', 'Cash at Link Bank', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('3', '1010', 'Gross Fixed Asset', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('4', '1015', 'Accured Depreciation', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('5', '1020', 'Cash with SPLASH', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('6', '1025', 'Cash with FIB-WUMT', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('7', '1030', 'Passbook', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('8', '1035', 'Loan Portfolio', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('9', '1040', 'Loan Loss Reserve', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('10', '1045', 'Other Asset', 'ASS', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('11', '2000', 'Savings', 'LBT', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('12', '2005', 'Loan from RFF', 'LBT', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('13', '2010', 'Differed Income', 'LBT', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('14', '2015', 'SPLASH Advance', 'LBT', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('15', '2020', 'Risk Management Fee', 'LBT', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('16', '2025', 'Other Liablites', 'LBT', 'BS');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`, `ext_rep`) VALUES ('17', '3000', 'Share Capital', 'EQU', 'BS', 'SCT');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`, `ext_rep`) VALUES ('18', '3005', 'Donated Equity CY', 'EQU', 'BS', 'DECY');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`, `ext_rep`) VALUES ('19', '3010', 'Donated Equity PY', 'EQU', 'BS', 'DEPY');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`, `ext_rep`) VALUES ('20', '3015', 'Retained Earning CY', 'EQU', 'BS', 'RECY');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`, `ext_rep`) VALUES ('21', '3020', 'Retained Earning PY', 'EQU', 'BS', 'REPY');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('22', '4000', 'Interest on Loan', 'REV', 'PL');
INSERT INTO `proaccounting`.`chart_of_account_t` (`coa_id`, `coa_code`, `coa_name`, `coa_type`, `coa_type_cate`) VALUES ('23', '4005', 'Loan Processing Fee', 'REV', 'PL');
INSERT INTO `
Mathiudi 6-Jan-16 8:57am View
   
It is Microsoft SQL server code
Mathiudi 18-Mar-14 9:54am View
   
so no one show interest in my problem. OK thanks.
Mathiudi 17-Mar-14 13:57pm View
   
I'm a beginner and no one taught me how to use VB and VB.net. I learn by my self with help of files on vb.net and the rest I found on the internet. so some of the thing that stack me up, I have to ask for help.
Mathiudi 14-Mar-14 13:25pm View
   
Please don't be angry with me
Mathiudi 13-Mar-14 9:29am View
   
Thank you very much the code work fine. But there is another problem which is it give a wrong calculation above five (5) years. Please how can you help me.
Mathiudi 17-Feb-14 14:59pm View
   
These are the fields the info is being saved

id (PK) varchar (50)
fullname varchar (50)
staffpic image
Mathiudi 17-Feb-14 14:55pm View
   
this is the exception thrown after using parameter.AddWithValue (Failed to convert parameter value from a Bitmap to a Byte[].)

please go through the code and see what is missing


Dim str As String = "Data Source=.\sqlexpress;Initial Catalog=hotelmaster;Integrated Security=True"

Dim con As New SqlConnection(str)

con.Open()

Dim sql As String = "UPDATE Hr_StaffInfoPics SET staffpic=@StaffPic WHERE id=@ID"

Dim cmd As New SqlCommand(sql, con)

cmd.Parameters.Add("@ID", SqlDbType.VarChar, 50, "id").Value = lblID.Text

cmd.Parameters.Add("@StaffPic", SqlDbType.Image).Value = PicStaff.Image

Dim ms As New MemoryStream()

PicStaff.Image.Save(ms, PicStaff.Image.RawFormat)

Dim data As Byte() = ms.GetBuffer()

Dim p As New SqlParameter("@StaffPic", SqlDbType.Image)

p.Value = data

cmd.Parameters.Add(p)

cmd.ExecuteNonQuery()

MessageBox.Show("record has been saved", "Save", MessageBoxButtons.OK)

con.Close()
Mathiudi 17-Feb-14 14:36pm View
   
Please if have a simple way to do it, Kindly help me with that
Mathiudi 17-Feb-14 14:35pm View
   
I did what you tell me to do, but this is exception that is been thrown (No mapping exists from object type System.Drawing.Bitmap to a known managed provider native type.)

Public Sub Updatelogo()

Dim str As String = "Data Source=.\sqlexpress;Initial Catalog=hotelmaster;Integrated Security=True"

Dim con As New SqlConnection(str)

con.Open()

Dim sql As String = "UPDATE Hr_StaffInfoPics SET staffpic=@StaffPic WHERE id=@ID"

Dim cmd As New SqlCommand(sql, con)

cmd.Parameters.AddWithValue("@ID", lblID.Text)

cmd.Parameters.AddWithValue("@StaffPic", PicStaff.Image)

Dim ms As New MemoryStream()

PicStaff.Image.Save(ms, PicStaff.Image.RawFormat)

Dim data As Byte() = ms.GetBuffer()

Dim p As New SqlParameter("@StaffPic", SqlDbType.Image)

p.Value = data

cmd.Parameters.Add(p)

cmd.ExecuteNonQuery()

MessageBox.Show("record has been saved", "Save", MessageBoxButtons.OK)

con.Close()

End Sub
Mathiudi 5-Nov-13 5:38am View
   
Thank you very much I've got it and it's working fine
Mathiudi 5-Nov-13 5:37am View
   
Thank you very much I've got it and it's working fine
Mathiudi 5-Nov-13 5:37am View
   
Deleted
Thank you very much I've got it and it's working fine
Mathiudi 4-Nov-13 11:13am View
   
This is what it always show The report definition for 'C:\Program Files\ICM\Hotel Management System\..\..\CarReport.rdlc\ has not been specified. Could not find file. Any idea please.
Mathiudi 4-Nov-13 10:52am View
   
When I copy the project to another pc that have visual studio install in works fine but after deploying it to a client pc it shown microsoftreportviewer error : The report definition for local report not specify
Mathiudi 20-Sep-13 8:34am View
   
Well I found bellow script at one site. Can you please help me to put them in the appropriate function in visual basic.net to start the shell execution?

Step 1. Install mysql-essential-5.0

Following Command To install that .

start mysql-essential-5.5.12-win32.msi /quiet /norestart

Step 2. Set configuration

Run Following Command line For That .

cd\
cd Program Files
cd MySQL
cd MySQL Server 5.5
cd bin
MySQLInstanceConfig.exe -i -q "-lC:\mysql_install_log.txt"

"-nMySQL Server 5.5" "-pC:\Program Files\MySQL\MySQL Server

5.5" -v5.5.12 "-tC:\Program Files\MySQL\MySQL Server

5.5\my-template.ini" "-cC:\mytest.ini" ServerType=DEVELOPMENT

DatabaseType=MIXED ConnectionUsage=DSS Port=3306 ServiceName=

RootPassword=pass
break
exit

Step 3. give it full privileges to connect from external and localhost client:

cd\
cd Program Files
cd MySQL
cd MySQL Server 5.5
cd bin
mysql -u root
GRANT ALL PRIVILEGES ON *.* TO 'Root'@'%' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;
exit
Mathiudi 18-Sep-13 12:14pm View
   
Please I don;t know where to start and where to end