public int DeletePurchaseBill(int PBillHead_Idno)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPBillHead pbh = db.tblPBillHeads.Where(h => h.PBillHead_Idno == PBillHead_Idno).FirstOrDefault();
List <tblPBillDetl> qtd = db.tblPBillDetls.Where(d => d.PBillHead_Idno == PBillHead_Idno).ToList();
List <Stckdetl> StDetl = db.Stckdetls.Where(d => d.PBillIdno == PBillHead_Idno && d.MtrlIssue_Idno == 0 && d.Is_Issued == false).ToList();
if (pbh.Billed == true)
{
return(value = -1);
}
if (pbh != null)
{
foreach (var d in qtd)
{
db.tblPBillDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblPBillHeads.DeleteObject(pbh);
db.SaveChanges();
value = 1;
}
if (StDetl != null)
{
foreach (var S in StDetl)
{
db.Stckdetls.DeleteObject(S);
db.SaveChanges();
}
//value = 1;
}
clsAccountPosting objclsAccountPosting = new clsAccountPosting();
Int64 intValue = objclsAccountPosting.DeleteAccountPosting(PBillHead_Idno, "PB");
db.SaveChanges();
if (intValue > 0)
{
value = 1;
}
}
return(value);
}
public Int64 Update(Int64 PBillHead_Idno, Int64 Year_Idno, Int64 Loc_Idno, DateTime?PBillHead_Date, string Prefix_No, Int64 PBillHead_No, int Pur_Type, Int64 Prty_Idno, int Bill_Type, string Remark, Double Tot_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, DateTime?Date_Updated, DataTable dtDetail, Int64 LorryIdno, Double Discount)
{
Int64 BillHead_Idno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblPBillHead objBillHead = db.tblPBillHeads.Where(Bh => (Bh.PBillHead_Idno != PBillHead_Idno) && (Bh.PBillHead_No == PBillHead_No) && (Bh.Loc_Idno == Loc_Idno) && (Bh.Year_Idno == Year_Idno)).FirstOrDefault();
if (objBillHead == null)
{
tblPBillHead objBillHead1 = db.tblPBillHeads.Where(rh => rh.PBillHead_Idno == PBillHead_Idno).FirstOrDefault();
if (objBillHead1 != null)
{
objBillHead1.Year_Idno = Year_Idno;
objBillHead1.Loc_Idno = Loc_Idno;
objBillHead1.PBillHead_Date = PBillHead_Date;
objBillHead1.Prefix_No = Prefix_No;
objBillHead1.PBillHead_No = PBillHead_No;
objBillHead1.Pur_Type = Pur_Type;
objBillHead1.Prty_Idno = Prty_Idno;
objBillHead1.Bill_Type = Bill_Type;
objBillHead1.Remark = Remark;
objBillHead1.Tot_Amnt = Tot_Amnt;
objBillHead1.Disc_type = Disc_type;
objBillHead1.Disc_Amnt = Disc_Amnt;
objBillHead1.Other_Amnt = Other_Amnt;
objBillHead1.RndOff_Amnt = RndOff_Amnt;
objBillHead1.Net_Amnt = Net_Amnt;
objBillHead1.Discount = Discount;
objBillHead1.Date_Modified = Date_Updated;
objBillHead1.LorryIdno = LorryIdno;
db.SaveChanges();
BillHead_Idno = objBillHead1.PBillHead_Idno;
if (BillHead_Idno > 0)
{
List <tblPBillDetl> lstBillDetl = db.tblPBillDetls.Where(obj => obj.PBillHead_Idno == BillHead_Idno).ToList();
if (lstBillDetl.Count > 0)
{
foreach (tblPBillDetl obj in lstBillDetl)
{
db.tblPBillDetls.DeleteObject(obj);
}
db.SaveChanges();
}
foreach (DataRow row in dtDetail.Rows)
{
tblPBillDetl objBillDetl = new tblPBillDetl();
objBillDetl.PBillHead_Idno = Convert.ToInt64(BillHead_Idno);
objBillDetl.Item_Idno = Convert.ToInt32(row["Item_Idno"]);
objBillDetl.IGrp_Idno = Convert.ToInt64(row["IGrp_Idno"]);
objBillDetl.Qty = Convert.ToDouble(row["Quantity"]);
objBillDetl.Unit_Idno = Convert.ToInt32(row["Unit_Idno"]);
objBillDetl.Rate_Type = Convert.ToInt32(row["Rate_TypeIdno"]);
objBillDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objBillDetl.Amount = Convert.ToDouble(row["Amount"]);
objBillDetl.Tot_Weght = Convert.ToDouble(row["Weight"]);
objBillDetl.Item_Tax = Convert.ToDouble(row["Vat"]);
objBillDetl.Tax_Rate = Convert.ToDouble(row["TaxRate"]);
objBillDetl.Disc_Type = Convert.ToDouble(row["DivDiscType"]);
objBillDetl.Disc_Value = Convert.ToDouble(row["DivDiscValue"]);
objBillDetl.Disc_Amnt = Convert.ToDouble(row["DivDiscAmnt"]);
objBillDetl.Other_Amnt = Convert.ToDouble(row["DivDiscOthAmnt"]);
objBillDetl.TyresizeIdno = string.IsNullOrEmpty(Convert.ToString(row["Tyresize_Idno"])) ? 0 : Convert.ToInt64(row["Tyresize_Idno"]);
objBillDetl.SGST_Per = string.IsNullOrEmpty(Convert.ToString(row["SGST_Per"])) ? 0 : Convert.ToDouble(row["SGST_Per"]);
objBillDetl.CGST_Per = string.IsNullOrEmpty(Convert.ToString(row["CGST_Per"])) ? 0 : Convert.ToDouble(row["CGST_Per"]);
objBillDetl.IGST_Per = string.IsNullOrEmpty(Convert.ToString(row["IGST_Per"])) ? 0 : Convert.ToDouble(row["IGST_Per"]);
objBillDetl.SGST_Amt = string.IsNullOrEmpty(Convert.ToString(row["SGST_Amt"])) ? 0 : Convert.ToDouble(row["SGST_Amt"]);
objBillDetl.CGST_Amt = string.IsNullOrEmpty(Convert.ToString(row["CGST_Amt"])) ? 0 : Convert.ToDouble(row["CGST_Amt"]);
objBillDetl.IGST_Amt = string.IsNullOrEmpty(Convert.ToString(row["IGST_Amt"])) ? 0 : Convert.ToDouble(row["IGST_Amt"]);
db.tblPBillDetls.AddObject(objBillDetl);
db.SaveChanges();
}
}
}
}
else
{
BillHead_Idno = -1;
}
}
catch (Exception Ex)
{
BillHead_Idno = 0;
}
}
return(BillHead_Idno);
}
public Int64 Insert(Int64 Year_Idno, Int64 Loc_Idno, DateTime?PBillHead_Date, string Prefix_No, Int64 PBillHead_No, int Pur_Type, Int64 Prty_Idno, int Bill_Type, string Remark, Double Tot_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, DateTime?Date_Added, DataTable dtDetail, Int64 LorryIdno, Double Discount)
{
Int64 PBillHead_Idno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblPBillHead objBillHead = db.tblPBillHeads.Where(bill => (bill.PBillHead_No == PBillHead_No) && (bill.Year_Idno == Year_Idno) && (bill.Loc_Idno == Loc_Idno)).FirstOrDefault();
if (objBillHead == null)
{
objBillHead = new tblPBillHead();
objBillHead.Year_Idno = Year_Idno;
objBillHead.Loc_Idno = Loc_Idno;
objBillHead.PBillHead_Date = PBillHead_Date;
objBillHead.Prefix_No = Prefix_No;
objBillHead.PBillHead_No = PBillHead_No;
objBillHead.Pur_Type = Pur_Type;
objBillHead.Prty_Idno = Prty_Idno;
objBillHead.Bill_Type = Bill_Type;
objBillHead.Remark = Remark;
objBillHead.Tot_Amnt = Tot_Amnt;
objBillHead.Disc_type = Disc_type;
objBillHead.Disc_Amnt = Disc_Amnt;
objBillHead.Other_Amnt = Other_Amnt;
objBillHead.RndOff_Amnt = RndOff_Amnt;
objBillHead.Net_Amnt = Net_Amnt;
objBillHead.Date_Added = Date_Added;
objBillHead.LorryIdno = LorryIdno;
objBillHead.Discount = Discount;
objBillHead.Billed = false;
db.tblPBillHeads.AddObject(objBillHead);
db.SaveChanges();
PBillHead_Idno = objBillHead.PBillHead_Idno;
if (PBillHead_Idno > 0)
{
foreach (DataRow dr in dtDetail.Rows)
{
tblPBillDetl objBillDetl = new tblPBillDetl();
objBillDetl.PBillHead_Idno = PBillHead_Idno;
objBillDetl.Item_Idno = Convert.ToInt64(dr["Item_Idno"]);
objBillDetl.IGrp_Idno = Convert.ToInt64(dr["IGrp_Idno"]);
objBillDetl.Qty = Convert.ToDouble(dr["Quantity"]);
objBillDetl.Unit_Idno = Convert.ToInt64(dr["Unit_Idno"]);
objBillDetl.Rate_Type = Convert.ToInt32(dr["Rate_TypeIdno"]);
objBillDetl.Item_Rate = Convert.ToDouble(dr["Rate"]);
objBillDetl.Amount = Convert.ToDouble(dr["Amount"]);
objBillDetl.Tot_Weght = Convert.ToDouble(dr["Weight"]);
objBillDetl.Item_Tax = Convert.ToDouble(dr["Vat"]);
objBillDetl.Tax_Rate = Convert.ToDouble(dr["TaxRate"]);
objBillDetl.Disc_Type = Convert.ToDouble(dr["DivDiscType"]);
objBillDetl.Disc_Value = Convert.ToDouble(dr["DivDiscValue"]);
objBillDetl.Disc_Amnt = Convert.ToDouble(dr["DivDiscAmnt"]);
objBillDetl.Other_Amnt = Convert.ToDouble(dr["DivDiscOthAmnt"]);
objBillDetl.TyresizeIdno = Convert.ToInt64(dr["Tyresize_Idno"]);
objBillDetl.SGST_Per = Convert.ToDouble(dr["SGST_Per"]);
objBillDetl.CGST_Per = Convert.ToDouble(dr["CGST_Per"]);
objBillDetl.IGST_Per = Convert.ToDouble(dr["IGST_Per"]);
objBillDetl.SGST_Amt = Convert.ToDouble(dr["SGST_Amt"]);
objBillDetl.CGST_Amt = Convert.ToDouble(dr["CGST_Amt"]);
objBillDetl.IGST_Amt = Convert.ToDouble(dr["IGST_Amt"]);
db.tblPBillDetls.AddObject(objBillDetl);
db.SaveChanges();
}
}
}
else
{
return(PBillHead_Idno);
}
}
catch (Exception ex)
{
return(-1);
}
return(PBillHead_Idno);
}
}
