void UpdateInvoiceDetails(InvoiceMaster item, SqlConnection sqlCon) { SettlementAmount = lstInvoiceMaster.Where(p => p.InvoiceNo == item.InvoiceNo && p.InvoiceDate == item.InvoiceDate && p.OrderID == item.OrderID && p.OrderDate == item.OrderDate).Sum(p => p.SettlementAmount); InvoiceAmount = lstInvoiceMaster.Where(p => p.InvoiceNo == item.InvoiceNo && p.InvoiceDate == item.InvoiceDate && p.OrderID == item.OrderID && p.OrderDate == item.OrderDate).Sum(p => p.Total); if (lstInvoiceMaster.Where(p => p.InvoiceNo == item.InvoiceNo).ToList().Where(p => p.Status == 1 || p.Status == 8).Count() > 0) { FinalStatus = 1; } else { FinalStatus = 5; } SqlCommand cmd = new SqlCommand("Insert Into InvoiceDetailsMaster " + "( InvoiceDate, InvoiceNo, OrderID, OrderDate, PartysName, [Address], EmailID, MobileNo, VendorID, InvoiceAmount, SettlementAmount, FinalStatus, CreationDate, CreatedBy, ModifiedDate, ModifiedBy) " + "Values ('" + item.InvoiceDate + "'," + item.InvoiceNo + ",'" + item.OrderID + "','" + item.OrderDate + "','" + item.PartysName + "','" + item.Address + "','" + item.EmailID + "','" + item.MobNo + "'," + item.VendorID + "," + InvoiceAmount + "," + SettlementAmount + "," + FinalStatus + ",'" + item.CreationDate + "'," + item.CreatedBy + ",'" + item.ModifiedDate + "'," + item.ModifiedBy + ")", sqlCon); int cnt = cmd.ExecuteNonQuery(); if (cnt != 1) { Console.WriteLine("Invoice Error"); sw.WriteLine("Invoice Details Error," + item.InvoiceDate + "," + item.InvoiceNo + "," + item.OrderID + "," + item.OrderDate + "," + item.ProductID); cmd.Dispose(); return; } Console.WriteLine("Invoice Success"); sw.WriteLine("Invoice Details Success," + item.InvoiceDate + "," + item.InvoiceNo + "," + item.OrderID + "," + item.OrderDate + "," + item.ProductID); cmd.Dispose(); }
InvoiceMaster AddValues(SqlDataReader dr) { InvoiceMaster objInv = new InvoiceMaster(); objInv.InvoiceDate = Convert.ToDateTime(dr["InvoiceDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.InvoiceNo = Convert.ToInt32(dr["InvoiceNo"]); objInv.OrderID = dr["OrderID"].ToString(); objInv.OrderDate = Convert.ToDateTime(dr["OrderDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.ProductID = dr["ProductID"].ToString(); objInv.PartysName = dr["PartysName"].ToString().Replace("'", "''"); objInv.Address = dr["Address"].ToString().Replace("'", "''"); objInv.EmailID = dr["EmailID"].ToString().Replace("'", "''"); objInv.MobNo = dr["MobileNo"].ToString(); objInv.Quantity = Convert.ToInt32(dr["Quantity"]); objInv.Rate = Convert.ToDecimal(dr["Rate"]); objInv.UnitPrice = Convert.ToDecimal(dr["UnitPrice"]); objInv.NetSale = Convert.ToDecimal(dr["NetSale"]); objInv.VAT = Convert.ToDecimal(dr["VAT"]); objInv.CST = Convert.ToDecimal(dr["CST"]); objInv.Packaging = Convert.ToDecimal(dr["PackagingAndForwarding"]); objInv.Total = Convert.ToDecimal(dr["Total"]); objInv.VendorID = Convert.ToInt32(dr["VendorID"]); objInv.SettlementDate = Convert.ToDateTime(dr["SettlementDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.SettlementAmount = Convert.ToDecimal(dr["SettlementAmount"]); objInv.Status = Convert.ToInt32(dr["Status"]); objInv.CreationDate = Convert.ToDateTime(dr["CreationDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); objInv.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.ModifiedBy = Convert.ToInt32(dr["ModifiedBy"]); objInv.ReturnedDate = Convert.ToDateTime(dr["ReturnedDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); return(objInv); }
void UpdateInvoiceProductDetails(InvoiceMaster item, SqlConnection sqlCon) { SqlCommand cmd = new SqlCommand("Insert Into InvoiceProductMaster " + "( InvoiceDate, InvoiceNo, OrderID, OrderDate, ProductID, Quantity, Rate, UnitPrice, NetSale, VAT, CST, PackagingAndForwarding, Total, Status, CreationDate, CreatedBy, ModifiedDate, ModifiedBy) " + "Values ('" + item.InvoiceDate + "'," + item.InvoiceNo + ",'" + item.OrderID + "','" + item.OrderDate + "','" + item.ProductID + "'," + item.Quantity + "," + item.Rate + "," + item.UnitPrice + "," + item.NetSale + "," + item.VAT + "," + item.CST + "," + item.Packaging + "," + item.Total + "," + item.Status + ",'" + item.CreationDate + "'," + item.CreatedBy + ",'" + item.ModifiedDate + "'," + item.ModifiedBy + ")", sqlCon); int cnt = cmd.ExecuteNonQuery(); if (cnt != 1) { Console.WriteLine("Invoice Product Error"); sw.WriteLine("Invoice Product Error," + item.InvoiceDate + "," + item.InvoiceNo + "," + item.OrderID + "," + item.OrderDate + "," + item.ProductID); cmd.Dispose(); return; } Console.WriteLine("Invoice Product Success"); sw.WriteLine("Invoice Product Error," + item.InvoiceDate + "," + item.InvoiceNo + "," + item.OrderID + "," + item.OrderDate + "," + item.ProductID); cmd.Dispose(); cmd.Dispose(); }
InvoiceMaster AddValuesForInvoiceDetails(SqlDataReader dr) { InvoiceMaster objInv = new InvoiceMaster(); objInv.InvoiceDate = Convert.ToDateTime(dr["InvoiceDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.InvoiceNo = Convert.ToInt32(dr["InvoiceNo"]); objInv.OrderID = dr["OrderID"].ToString(); objInv.OrderDate = Convert.ToDateTime(dr["OrderDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.PartysName = dr["PartysName"].ToString().Replace("'", "''"); objInv.Address = dr["Address"].ToString().Replace("'", "''"); objInv.EmailID = dr["EmailID"].ToString().Replace("'", "''"); objInv.MobNo = dr["MobileNo"].ToString(); objInv.VendorID = Convert.ToInt32(dr["VendorID"]); objInv.Status = Convert.ToInt32(dr["FinalStatus"]); objInv.CreationDate = Convert.ToDateTime(dr["CreationDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); objInv.ModifiedDate = Convert.ToDateTime(dr["ModifiedDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); objInv.ModifiedBy = Convert.ToInt32(dr["ModifiedBy"]); return(objInv); }