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);
}
