public Int64 Update(Int64 SBillHead_Idno, DateTime?SBillHead_Date, string Prefix_No, Int64 SBill_No, int SBill_Type, Int64 Against, int Tax_Type, Int64 Prty_Idno, Int64 FromLoc_Idno, string Remark, Double Tot_Tax, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Charges, Double Tot_Amnt, Int64 Year_Idno, DateTime?Date_Updated, DataTable dtDetail)
{
Int64 BillHead_Idno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblSBillHead objBillHead = db.tblSBillHeads.Where(Bh => (Bh.SBillHead_Idno != SBillHead_Idno) && (Bh.SBill_No == SBill_No) && (Bh.Prefix_No == Prefix_No) && (Bh.SBill_Type == SBill_Type) && (Bh.FromLoc_Idno == FromLoc_Idno) && (Bh.Year_Idno == Year_Idno)).FirstOrDefault();
if (objBillHead == null)
{
tblSBillHead objBillHead1 = db.tblSBillHeads.Where(rh => rh.SBillHead_Idno == SBillHead_Idno).FirstOrDefault();
if (objBillHead1 != null)
{
objBillHead1.SBillHead_Date = SBillHead_Date;
objBillHead1.Prefix_No = Prefix_No;
objBillHead1.SBill_No = SBill_No;
objBillHead1.SBill_Type = SBill_Type;
objBillHead1.Bill_Against = Against;
objBillHead1.Tax_Type = Tax_Type;
objBillHead1.Prty_Idno = Prty_Idno;
objBillHead1.FromLoc_Idno = FromLoc_Idno;
objBillHead1.Remark = Remark;
objBillHead1.Tot_Tax = Tot_Tax;
objBillHead1.Disc_type = Disc_type;
objBillHead1.Disc_Amnt = Disc_Amnt;
objBillHead1.Tot_Amnt = Tot_Amnt;
objBillHead1.Other_Amnt = Other_Amnt;
objBillHead1.RndOff_Amnt = RndOff_Amnt;
objBillHead1.Net_Amnt = Net_Amnt;
objBillHead1.Date_Modified = Date_Updated;
objBillHead1.Year_Idno = Year_Idno;
db.SaveChanges();
BillHead_Idno = objBillHead1.SBillHead_Idno;
if (BillHead_Idno > 0)
{
List <tblSBillDetl> lstBillDetl = db.tblSBillDetls.Where(obj => obj.SBillHead_Idno == BillHead_Idno).ToList();
if (lstBillDetl.Count > 0)
{
foreach (tblSBillDetl obj in lstBillDetl)
{
db.tblSBillDetls.DeleteObject(obj);
}
db.SaveChanges();
}
foreach (DataRow row in dtDetail.Rows)
{
tblSBillDetl objBillDetl = new tblSBillDetl();
objBillDetl.SBillHead_Idno = SBillHead_Idno;
objBillDetl.Item_Idno = Convert.ToInt64(row["SerialNoIdno"]);
objBillDetl.Model_Idno = Convert.ToInt64(row["ModelIdNo"]);
objBillDetl.Tyre_Category = Convert.ToInt64(row["TyreTypeIdNo"]);
objBillDetl.Rate_Type = Convert.ToInt32(row["RateTypeIdno"]);
objBillDetl.Qty = Convert.ToDouble(row["Quantity"]);
objBillDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objBillDetl.Item_Weigt = Convert.ToDouble(row["Weight"]);
objBillDetl.Dis_Type = Convert.ToInt64(row["DiscountType"]);
objBillDetl.Dis_Amnt = string.IsNullOrEmpty(row["Discount"].ToString()) ? 0 : Convert.ToDouble(row["Discount"]);
objBillDetl.Amount = string.IsNullOrEmpty(row["Amount"].ToString()) ? 0 : Convert.ToDouble(row["Amount"]);
objBillDetl.Item_Tax = string.IsNullOrEmpty(row["TaxAmnt"].ToString()) ? 0 : Convert.ToDouble(row["TaxAmnt"]);
objBillDetl.Tax_Rate = string.IsNullOrEmpty(row["TaxRate"].ToString()) ? 0 : Convert.ToDouble(row["TaxRate"]);
objBillDetl.Dis_Value = string.IsNullOrEmpty(row["DiscountValue"].ToString()) ? 0 : Convert.ToDouble(row["DiscountValue"]);
objBillDetl.Item_Type = string.IsNullOrEmpty(row["ItemType"].ToString()) ? 0 : Convert.ToInt32(row["ItemType"]);
objBillDetl.MatIss_Idno = string.IsNullOrEmpty(row["MatIss_Idno"].ToString()) ? 0 : Convert.ToInt32(row["MatIss_Idno"]);
db.tblSBillDetls.AddObject(objBillDetl);
db.SaveChanges();
}
}
}
}
else
{
BillHead_Idno = -1;
}
}
catch (Exception Ex)
{
BillHead_Idno = 0;
}
}
return(BillHead_Idno);
}
public Int64 Insert(DateTime?SBillHead_Date, string Prefix_No, Int64 SBill_No, int SBill_Type, Int64 Against, int Tax_Type, Int64 Prty_Idno, Int64 FromLoc_Idno, string Remark, Double Tot_Tax, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Charges, Double Tot_Amnt, Int64 Year_Idno, DateTime?Date_Added, DataTable dtDetail)
{
Int64 SBillHead_Idno = 0;
Int64 SBillDetailIdNo = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblSBillHead objBillHead = db.tblSBillHeads.Where(bill => (bill.SBill_No == SBill_No) && (bill.Year_Idno == Year_Idno) && (bill.Prefix_No == Prefix_No) && (bill.SBill_Type == SBill_Type) && (bill.FromLoc_Idno == FromLoc_Idno)).FirstOrDefault();
if (objBillHead == null)
{
objBillHead = new tblSBillHead();
objBillHead.SBillHead_Date = SBillHead_Date;
objBillHead.Prefix_No = Prefix_No;
objBillHead.SBill_No = SBill_No;
objBillHead.SBill_Type = SBill_Type;
objBillHead.Bill_Against = Against;
objBillHead.Tax_Type = Tax_Type;
objBillHead.Prty_Idno = Prty_Idno;
objBillHead.FromLoc_Idno = FromLoc_Idno;
objBillHead.Remark = Remark;
objBillHead.Tot_Tax = Tot_Tax;
objBillHead.Disc_type = Disc_type;
objBillHead.Disc_Amnt = Disc_Amnt;
objBillHead.Tot_Amnt = Tot_Amnt;
objBillHead.Other_Amnt = Other_Amnt;
objBillHead.RndOff_Amnt = RndOff_Amnt;
objBillHead.Net_Amnt = Net_Amnt;
objBillHead.Date_Added = Date_Added;
objBillHead.Billed = false;
objBillHead.Year_Idno = Year_Idno;
db.tblSBillHeads.AddObject(objBillHead);
db.SaveChanges();
SBillHead_Idno = objBillHead.SBillHead_Idno;
if (SBillHead_Idno > 0)
{
foreach (DataRow dr in dtDetail.Rows)
{
tblSBillDetl objBillDetl = new tblSBillDetl();
objBillDetl.SBillHead_Idno = SBillHead_Idno;
objBillDetl.Item_Idno = Convert.ToInt64(dr["SerialNoIdno"]);
objBillDetl.Model_Idno = Convert.ToInt64(dr["ModelIdNo"]);
objBillDetl.Tyre_Category = string.IsNullOrEmpty(Convert.ToString(dr["TyreTypeIdNo"])) ? 0 : Convert.ToInt64(dr["TyreTypeIdNo"]);
objBillDetl.Rate_Type = Convert.ToInt32(dr["RateTypeIdno"]);
objBillDetl.Qty = Convert.ToDouble(dr["Quantity"]);
objBillDetl.Item_Rate = Convert.ToDouble(dr["Rate"]);
objBillDetl.Item_Weigt = Convert.ToDouble(dr["Weight"]);
objBillDetl.Dis_Type = Convert.ToInt64(dr["DiscountType"]);
objBillDetl.Dis_Amnt = Convert.ToDouble(dr["Discount"]);
objBillDetl.Amount = Convert.ToDouble(dr["Amount"]);
objBillDetl.Item_Tax = Convert.ToDouble(dr["TaxAmnt"]);
objBillDetl.Tax_Rate = Convert.ToDouble(dr["TaxRate"]);
objBillDetl.Dis_Value = Convert.ToDouble(dr["DiscountValue"]);
objBillDetl.Item_Type = Convert.ToInt32(dr["ItemType"]);
objBillDetl.MatIss_Idno = Convert.ToInt32(dr["MatIss_Idno"]);
objBillDetl.Claim_Idno = 0;
db.tblSBillDetls.AddObject(objBillDetl);
db.SaveChanges();
}
}
}
else
{
return(SBillHead_Idno);
}
}
catch (Exception ex)
{
return(-1);
}
return(SBillHead_Idno);
}
}
