public List <t_grn> SelectT_grnMulti(t_grn objt_grn2) { List <t_grn> retval = new List <t_grn>(); try { strquery = @"select * from t_grn where no = '" + objt_grn2.no + "'"; DataTable dtt_grn = u_DBConnection.ReturnDataTable(strquery, CommandType.Text); foreach (DataRow drType in dtt_grn.Rows) { if (drType != null) { t_grn objt_grn = new t_grn(); objt_grn.no = drType["no"].ToString(); objt_grn.locationId = drType["locationId"].ToString(); objt_grn.poNo = drType["poNo"].ToString(); objt_grn.date = DateTime.Parse(drType["date"].ToString()); objt_grn.refNo = drType["refNo"].ToString(); objt_grn.expireDate = DateTime.Parse(drType["expireDate"].ToString()); objt_grn.supplierId = drType["supplierId"].ToString(); objt_grn.supInvoiceNo = drType["supInvoiceNo"].ToString(); objt_grn.supInvoiceDate = DateTime.Parse(drType["supInvoiceDate"].ToString()); objt_grn.supInvoiceValue = decimal.Parse(drType["supInvoiceValue"].ToString()); objt_grn.supDoNo = drType["supDoNo"].ToString(); objt_grn.supDoDate = DateTime.Parse(drType["supDoDate"].ToString()); objt_grn.remarks = drType["remarks"].ToString(); objt_grn.noOfItems = decimal.Parse(drType["noOfItems"].ToString()); objt_grn.noOfPieces = decimal.Parse(drType["noOfPieces"].ToString()); objt_grn.grossAmount = decimal.Parse(drType["grossAmount"].ToString()); objt_grn.isSaved = bool.Parse(drType["isSaved"].ToString()); objt_grn.isProcessed = bool.Parse(drType["isProcessed"].ToString()); objt_grn.processDate = DateTime.Parse(drType["processDate"].ToString()); objt_grn.processUser = drType["processUser"].ToString(); objt_grn.netDiscount = decimal.Parse(drType["netDiscount"].ToString()); objt_grn.additions = decimal.Parse(drType["additions"].ToString()); objt_grn.deductions = decimal.Parse(drType["deductions"].ToString()); objt_grn.netAmount = decimal.Parse(drType["netAmount"].ToString()); objt_grn.isAllReturned = bool.Parse(drType["isAllReturned"].ToString()); objt_grn.GLUpdate = bool.Parse(drType["GLUpdate"].ToString()); objt_grn.triggerVal = int.Parse(drType["triggerVal"].ToString()); retval.Add(objt_grn); } } return(retval); } catch (Exception ex) { throw ex; } }
public Boolean Savet_grnSP_OneInstance(t_grn t_grn, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_grnSave"; scom.Parameters.Add("@no", SqlDbType.VarChar, 10).Value = t_grn.no; scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value = t_grn.locationId; scom.Parameters.Add("@poNo", SqlDbType.VarChar, 20).Value = t_grn.poNo; scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = t_grn.date; scom.Parameters.Add("@refNo", SqlDbType.VarChar, 20).Value = t_grn.refNo; scom.Parameters.Add("@expireDate", SqlDbType.DateTime, 8).Value = t_grn.expireDate; scom.Parameters.Add("@supplierId", SqlDbType.VarChar, 20).Value = t_grn.supplierId; scom.Parameters.Add("@supInvoiceNo", SqlDbType.VarChar, 20).Value = t_grn.supInvoiceNo; scom.Parameters.Add("@supInvoiceDate", SqlDbType.DateTime, 8).Value = t_grn.supInvoiceDate; scom.Parameters.Add("@supInvoiceValue", SqlDbType.Decimal, 9).Value = t_grn.supInvoiceValue; scom.Parameters.Add("@supDoNo", SqlDbType.VarChar, 20).Value = t_grn.supDoNo; scom.Parameters.Add("@supDoDate", SqlDbType.DateTime, 8).Value = t_grn.supDoDate; scom.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = t_grn.remarks; scom.Parameters.Add("@noOfItems", SqlDbType.Decimal, 9).Value = t_grn.noOfItems; scom.Parameters.Add("@noOfPieces", SqlDbType.Decimal, 9).Value = t_grn.noOfPieces; scom.Parameters.Add("@grossAmount", SqlDbType.Decimal, 9).Value = t_grn.grossAmount; scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_grn.isSaved; scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_grn.isProcessed; scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_grn.processDate; scom.Parameters.Add("@processUser", SqlDbType.VarChar, 30).Value = t_grn.processUser; scom.Parameters.Add("@netDiscount", SqlDbType.Decimal, 9).Value = t_grn.netDiscount; scom.Parameters.Add("@additions", SqlDbType.Decimal, 9).Value = t_grn.additions; scom.Parameters.Add("@deductions", SqlDbType.Decimal, 9).Value = t_grn.deductions; scom.Parameters.Add("@netAmount", SqlDbType.Decimal, 9).Value = t_grn.netAmount; scom.Parameters.Add("@isAllReturned", SqlDbType.Bit, 1).Value = t_grn.isAllReturned; scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = t_grn.GLUpdate; scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_grn.triggerVal; scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0; u_DBConnection dbcon = new u_DBConnection(); retvalue = dbcon.RunQuery(scom); return(retvalue); } catch (Exception ex) { throw (ex); } }
public t_grn Selectt_grn(t_grn objt_grn) { try { strquery = @"select * from t_grn where no = '" + objt_grn.no + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objt_grn.no = drType["no"].ToString(); objt_grn.locationId = drType["locationId"].ToString(); objt_grn.poNo = drType["poNo"].ToString(); objt_grn.date = DateTime.Parse(drType["date"].ToString()); objt_grn.refNo = drType["refNo"].ToString(); objt_grn.expireDate = DateTime.Parse(drType["expireDate"].ToString()); objt_grn.supplierId = drType["supplierId"].ToString(); objt_grn.supInvoiceNo = drType["supInvoiceNo"].ToString(); objt_grn.supInvoiceDate = DateTime.Parse(drType["supInvoiceDate"].ToString()); objt_grn.supInvoiceValue = decimal.Parse(drType["supInvoiceValue"].ToString()); objt_grn.supDoNo = drType["supDoNo"].ToString(); objt_grn.supDoDate = DateTime.Parse(drType["supDoDate"].ToString()); objt_grn.remarks = drType["remarks"].ToString(); objt_grn.noOfItems = decimal.Parse(drType["noOfItems"].ToString()); objt_grn.noOfPieces = decimal.Parse(drType["noOfPieces"].ToString()); objt_grn.grossAmount = decimal.Parse(drType["grossAmount"].ToString()); objt_grn.isSaved = bool.Parse(drType["isSaved"].ToString()); objt_grn.isProcessed = bool.Parse(drType["isProcessed"].ToString()); objt_grn.processDate = DateTime.Parse(drType["processDate"].ToString()); objt_grn.processUser = drType["processUser"].ToString(); objt_grn.netDiscount = decimal.Parse(drType["netDiscount"].ToString()); objt_grn.additions = decimal.Parse(drType["additions"].ToString()); objt_grn.deductions = decimal.Parse(drType["deductions"].ToString()); objt_grn.netAmount = decimal.Parse(drType["netAmount"].ToString()); objt_grn.isAllReturned = bool.Parse(drType["isAllReturned"].ToString()); objt_grn.GLUpdate = bool.Parse(drType["GLUpdate"].ToString()); objt_grn.triggerVal = int.Parse(drType["triggerVal"].ToString()); return(objt_grn); } return(null); } catch (Exception ex) { throw ex; } }
public static void SaveGrn(t_grn objt_grn, List <t_grn_detail> grnDets) { }
/// <summary> /// Saves a record to the t_grn table. /// </summary> public Boolean Savet_grnSP(t_grn t_grn, List <t_grn_detail> grndets, int formMode, string screenname) { SqlCommand scom; bool retvalue = false; try { using (TransactionScope transaction = new TransactionScope()) { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_grnSave"; scom.Parameters.Add("@no", SqlDbType.VarChar, 10).Value = t_grn.no; scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value = t_grn.locationId; scom.Parameters.Add("@poNo", SqlDbType.VarChar, 20).Value = t_grn.poNo; scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = t_grn.date; scom.Parameters.Add("@refNo", SqlDbType.VarChar, 20).Value = t_grn.refNo; scom.Parameters.Add("@expireDate", SqlDbType.DateTime, 8).Value = t_grn.expireDate; scom.Parameters.Add("@supplierId", SqlDbType.VarChar, 20).Value = t_grn.supplierId; scom.Parameters.Add("@supInvoiceNo", SqlDbType.VarChar, 20).Value = t_grn.supInvoiceNo; scom.Parameters.Add("@supInvoiceDate", SqlDbType.DateTime, 8).Value = t_grn.supInvoiceDate; scom.Parameters.Add("@supInvoiceValue", SqlDbType.Decimal, 9).Value = t_grn.supInvoiceValue; scom.Parameters.Add("@supDoNo", SqlDbType.VarChar, 20).Value = t_grn.supDoNo; scom.Parameters.Add("@supDoDate", SqlDbType.DateTime, 8).Value = t_grn.supDoDate; scom.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = t_grn.remarks; scom.Parameters.Add("@noOfItems", SqlDbType.Decimal, 9).Value = t_grn.noOfItems; scom.Parameters.Add("@noOfPieces", SqlDbType.Decimal, 9).Value = t_grn.noOfPieces; scom.Parameters.Add("@grossAmount", SqlDbType.Decimal, 9).Value = t_grn.grossAmount; scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_grn.isSaved; scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_grn.isProcessed; scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_grn.processDate; scom.Parameters.Add("@processUser", SqlDbType.VarChar, 30).Value = t_grn.processUser; scom.Parameters.Add("@netDiscount", SqlDbType.Decimal, 9).Value = t_grn.netDiscount; scom.Parameters.Add("@additions", SqlDbType.Decimal, 9).Value = t_grn.additions; scom.Parameters.Add("@deductions", SqlDbType.Decimal, 9).Value = t_grn.deductions; scom.Parameters.Add("@netAmount", SqlDbType.Decimal, 9).Value = t_grn.netAmount; scom.Parameters.Add("@isAllReturned", SqlDbType.Bit, 1).Value = t_grn.isAllReturned; scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = t_grn.GLUpdate; scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_grn.triggerVal; scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0; retvalue = new u_DBConnection().RunQuery(scom); foreach (t_grn_detail t_grn_detail in grndets) { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_grn_detailSave"; scom.Parameters.Add("@grnNo", SqlDbType.VarChar, 20).Value = t_grn_detail.grnNo; scom.Parameters.Add("@locationId", SqlDbType.VarChar, 20).Value = t_grn_detail.locationId; scom.Parameters.Add("@productId", SqlDbType.VarChar, 20).Value = t_grn_detail.productId; scom.Parameters.Add("@stock", SqlDbType.Decimal, 9).Value = t_grn_detail.stock; scom.Parameters.Add("@tax", SqlDbType.Decimal, 9).Value = t_grn_detail.tax; scom.Parameters.Add("@priceLevel", SqlDbType.VarChar, 10).Value = t_grn_detail.priceLevel; scom.Parameters.Add("@quantity", SqlDbType.Int, 4).Value = t_grn_detail.quantity; scom.Parameters.Add("@freeQty", SqlDbType.Int, 4).Value = t_grn_detail.freeQty; scom.Parameters.Add("@amount", SqlDbType.Decimal, 9).Value = t_grn_detail.amount; scom.Parameters.Add("@disPerc", SqlDbType.Decimal, 9).Value = t_grn_detail.disPerc; scom.Parameters.Add("@disAmount", SqlDbType.Decimal, 9).Value = t_grn_detail.disAmount; scom.Parameters.Add("@batchNo", SqlDbType.VarChar, 20).Value = t_grn_detail.batchNo; scom.Parameters.Add("@expDate", SqlDbType.DateTime, 8).Value = t_grn_detail.expDate; scom.Parameters.Add("@stockCode", SqlDbType.VarChar, 20).Value = t_grn_detail.stockCode; scom.Parameters.Add("@costPrice", SqlDbType.Decimal, 9).Value = t_grn_detail.costPrice; scom.Parameters.Add("@sellingPrice", SqlDbType.Decimal, 9).Value = t_grn_detail.sellingPrice; scom.Parameters.Add("@returnedQuantity", SqlDbType.Int, 4).Value = t_grn_detail.returnedQuantity; scom.Parameters.Add("@remainingQuantity", SqlDbType.Int, 4).Value = t_grn_detail.remainingQuantity; scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_grn_detail.triggerVal; scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = 1; // For insert scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0; retvalue = new u_DBConnection().RunQuery(scom); } //increment the serial transaction.Complete(); } return(retvalue); } catch (Exception ex) { throw (ex); } }