public string InsertVoucherDetails(BOLVoucher bocoucher) { sql = string.Empty; mes = string.Empty; sql = "Insert_VoucherDetails"; mes = davoucher.InsertVoucherDetails(bocoucher, sql); return(mes); }
public string InsertVoucherDetails(BOLVoucher bovoucher, string sql) { using (con = DBaccess.GetConnection()) { int result = 0; string message = string.Empty; SqlCommand cmd = new SqlCommand(); SqlParameter cmpcode, plantcode, rid, agentid, cleardate, inwarddate, shift, mltr, fat, snf, clr, rate, amount, remarks, pmess, press; cmd.CommandText = sql; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmpcode = cmd.Parameters.Add("@cmpcode", SqlDbType.Int); plantcode = cmd.Parameters.Add("@plantcode", SqlDbType.Int); rid = cmd.Parameters.Add("@rid", SqlDbType.Int); agentid = cmd.Parameters.Add("@agentid", SqlDbType.Int); cleardate = cmd.Parameters.Add("@cleardate", SqlDbType.DateTime); inwarddate = cmd.Parameters.Add("@inwarddate", SqlDbType.DateTime); shift = cmd.Parameters.Add("@shift", SqlDbType.NVarChar, 5); mltr = cmd.Parameters.Add("@mltr", SqlDbType.Float); fat = cmd.Parameters.Add("@fat", SqlDbType.Float); snf = cmd.Parameters.Add("@snf", SqlDbType.Float); clr = cmd.Parameters.Add("@clr", SqlDbType.Float); rate = cmd.Parameters.Add("@rate", SqlDbType.Float); amount = cmd.Parameters.Add("@amount", SqlDbType.Float); remarks = cmd.Parameters.Add("@remarks", SqlDbType.NVarChar, 250); pmess = cmd.Parameters.Add("@mess", SqlDbType.Char, 500); cmd.Parameters["@mess"].Direction = ParameterDirection.Output; press = cmd.Parameters.Add("@ress", SqlDbType.Int); cmd.Parameters["@ress"].Direction = ParameterDirection.Output; cmpcode.Value = bovoucher.Companycode; plantcode.Value = bovoucher.Plantcode; rid.Value = bovoucher.Routeid; agentid.Value = bovoucher.Agentid; cleardate.Value = bovoucher.Clearingdate; inwarddate.Value = bovoucher.Inwarddate; shift.Value = bovoucher.Shift; mltr.Value = bovoucher.Mlrt; fat.Value = bovoucher.Fat; snf.Value = bovoucher.Snf; clr.Value = bovoucher.Clr; rate.Value = bovoucher.Rate; amount.Value = bovoucher.Amount; remarks.Value = bovoucher.Remarks; cmd.ExecuteNonQuery(); message = (string)cmd.Parameters["@mess"].Value; result = (int)cmd.Parameters["@ress"].Value; if (result == 1) { //WebMsgBox.Show(message); return(message); } else { //WebMsgBox.Show(message); return(message); } } }