/// <summary> /// To check record existence in tblAcntLink /// </summary> /// <param name="strUOMName"></param> /// <param name="intUOMIdno"></param> /// <returns></returns> #endregion #region InsertUpdateDelete Events... /// <summary> /// Insert records in tblAcntLink /// </summary> /// <param name="strUOMName"></param> /// <param name="strUOMDesc"></param> /// <param name="bStatus"></param> /// <returns></returns> /// public Int64 InsertPurAccountHead(string strAccountHead, Int32 AcntIdno, Int32 CompId, Int32 Acnt_type, Int32 empIdno) { Int64 intValue = 0; bool OpenType = true; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast objAcntMast = new AcntMast(); objAcntMast.Acnt_Name = strAccountHead; objAcntMast.AGrp_Idno = AcntIdno; objAcntMast.Emp_Idno = empIdno; objAcntMast.Open_Bal = 0; objAcntMast.Bal_Type = Convert.ToInt32(OpenType); objAcntMast.Acnt_Type = Acnt_type; objAcntMast.Titl_Idno = 0; objAcntMast.INTERNAL = false; objAcntMast.ASubGrp_Idno = AcntIdno; objAcntMast.Status = true; objAcntMast.Comp_Idno = CompId; objAcntMast.Date_Added = System.DateTime.Now; objAcntMast.Date_Modified = System.DateTime.Now; if (IfIsExists(strAccountHead) == true) { intValue = -1; } else { db.AcntMasts.AddObject(objAcntMast); db.SaveChanges(); intValue = objAcntMast.Acnt_Idno; } return(intValue); } }
//public int Delete(Int64 ledgrAcntId, Int32 DlrTyp) //{ // int Value = 0; // LedgerAccountDAL objLedgrDAL = new LedgerAccountDAL(); // if (DlrTyp == 5 || DlrTyp == 9) // { // Value = objLedgrDAL.DeleteWorkComp(ledgrAcntId, DlrTyp); // } // else // { // Value = objLedgrDAL.Delete(ledgrAcntId); // } // objLedgrDAL = null; // return Value; //} public int Delete(Int64 ledgrAcntId, Int32 DlrTyp) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast objAcntMast = (from mast in db.AcntMasts where mast.Acnt_Idno == ledgrAcntId select mast).FirstOrDefault(); if (objAcntMast != null) { db.AcntMasts.DeleteObject(objAcntMast); db.SaveChanges(); intValue = 1; } } } catch (Exception Ex) { if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true) { intValue = -1; } } return(intValue); }
public bool IsExists(string strPartyName, int intAcntIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast objAcntMast = new AcntMast(); if (intAcntIdno <= 0) { objAcntMast = (from mast in db.AcntMasts where mast.Acnt_Name == strPartyName select mast).FirstOrDefault(); } else if (intAcntIdno > 0) { objAcntMast = (from mast in db.AcntMasts where mast.Acnt_Name == strPartyName && mast.Acnt_Idno != intAcntIdno select mast).FirstOrDefault(); } if (objAcntMast != null) { return(true); } else { return(false); } } }
public AcntMast GetPartyDetail(Int64 PartyID) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast cd = (from c in db.AcntMasts where c.Acnt_Idno == PartyID select c).FirstOrDefault(); return(cd); } }
public AcntMast SelectAcntName(Int64 intAcntIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast lst = (from tbl in db.AcntMasts where tbl.Acnt_Idno == intAcntIdno select tbl).FirstOrDefault(); return(lst); } }
public AcntMast SelectAcnt(Int64 AcntID) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast am = (from a in db.AcntMasts where a.Acnt_Idno == AcntID select a).FirstOrDefault(); return(am); } }
public Int64 SavDriver(string DriverName, Int32 DateRange, Int64 StateId, Int64 CityId) { Int64 Value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast ObjExist = (from N in db.AcntMasts where N.Acnt_Type == 9 && N.Acnt_Name == DriverName select N).FirstOrDefault(); if (ObjExist != null) { Value = -1; } else { AcntMast ObjNew = new AcntMast(); ObjNew.AGrp_Idno = 2; ObjNew.ASubGrp_Idno = 2; ObjNew.Open_Bal = 0; ObjNew.Bal_Type = 1; ObjNew.Acnt_Type = 9; ObjNew.Titl_Idno = 1; ObjNew.Acnt_Name = DriverName; ObjNew.AcntName_Hindi = ""; ObjNew.Year_Idno = DateRange; ObjNew.State_Idno = StateId; ObjNew.City_Idno = CityId; ObjNew.ServTax_Exmpt = false; ObjNew.Agnt_Commson = 0; ObjNew.Comp_Idno = 1; ObjNew.Address1 = ""; ObjNew.Address2 = ""; ObjNew.Status = true; db.AcntMasts.AddObject(ObjNew); db.SaveChanges(); Value = ObjNew.Acnt_Idno;; } } } catch (Exception Ex) { Value = 0; } return(Value); }
public bool IfIsExists(string strAccountHead) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast objAcntMast = new AcntMast(); if (strAccountHead != "") { objAcntMast = (from mast in db.AcntMasts where mast.Acnt_Name == strAccountHead select mast).FirstOrDefault(); } if (objAcntMast != null) { return(true); } else { return(false); } } }
public Int32 UpdateStatus(int intAcntIdno, bool Status, Int32 empIdno) { int value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast objAcntMast = (from mast in db.AcntMasts where mast.Acnt_Idno == intAcntIdno select mast).FirstOrDefault(); if (objAcntMast != null) { objAcntMast.Status = Status; objAcntMast.Emp_Idno = empIdno; objAcntMast.Date_Modified = System.DateTime.Now; db.SaveChanges(); value = 1; } } } catch (Exception ex) { } return(value); }
/// <summary> /// Update records in AcntMast /// </summary> /// <param name="strUOMName"></param> /// <param name="strUOMDesc"></param> /// <param name="bStatus"></param> /// <param name="intUOMIdno"></param> /// <returns></returns> public int Update(Int64 Title, string strPartyName, string strPartyNameHindi, Int64 AcntType, Int64 AcntSubGroup, int BalnceType, double OpenBalns, double AgentComm, bool bServTaxExmpt, string strContPerson, string strContMobile, string strContEmail, string strAddress1, string strAddress2, Int64 state, Int64 city, Int64 district, bool bStatus, int Pincode, string strFaxNo, int intAcntIdno, Int32 Year_Idno, string LincenceNo, DateTime?ExpiryDate, string Authority, string AccountNo, int Guarantor, Boolean varified, string FatherName, string DriverAddress, string Mobile1, string Mobile2, string BankName, string BankAddress, string RTGScode, string HazardousLicence, DateTime?HazardousExpiryDate, Int64 PCompIdno, Int32 CatIdno, string TinNo, Int32 empIdno, Int64 intPincIdno, string strPanNo, string AccNo, string AccBankName, string AccBranchName, string AccIfscCode, double DetentionPlantcharge, double DetentionPortcharge, double Containerliftcharge, string Lst_No, string Cst_No, string GSTINNo, string ShortName, DataTable dt) { int intValue = 0; Int32 intCompIdno = 1; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AcntMast objAcntMast1 = (from mast in db.AcntMasts where mast.Acnt_Idno == intAcntIdno select mast).FirstOrDefault(); if (objAcntMast1 != null) { objAcntMast1.Acnt_Name = strPartyName; objAcntMast1.Emp_Idno = empIdno; objAcntMast1.AcntName_Hindi = strPartyNameHindi; objAcntMast1.Titl_Idno = Title; objAcntMast1.Acnt_Type = AcntType; objAcntMast1.AGrp_Idno = Convert.ToInt64((from obj in db.AcntSubHeads where obj.ASubHead_Idno == AcntSubGroup select obj.AHead_Idno).FirstOrDefault()); objAcntMast1.ASubGrp_Idno = AcntSubGroup; objAcntMast1.Bal_Type = BalnceType; objAcntMast1.Open_Bal = OpenBalns; objAcntMast1.Agnt_Commson = AgentComm; objAcntMast1.ServTax_Exmpt = bServTaxExmpt; objAcntMast1.Cont_Person = strContPerson; objAcntMast1.Cont_Mobile = strContMobile; objAcntMast1.Cont_Email = strContEmail; objAcntMast1.Address1 = strAddress1; objAcntMast1.Address2 = strAddress2; objAcntMast1.State_Idno = state; objAcntMast1.Year_Idno = Year_Idno; objAcntMast1.City_Idno = city; objAcntMast1.District_Idno = district; objAcntMast1.Pin_Code = Pincode; objAcntMast1.Fax_No = strFaxNo; objAcntMast1.INTERNAL = false; objAcntMast1.Status = bStatus; objAcntMast1.Comp_Idno = intCompIdno; objAcntMast1.Date_Modified = System.DateTime.Now; objAcntMast1.DrvLicnc_NO = LincenceNo; objAcntMast1.DrvLNo_ExpDate = ExpiryDate; objAcntMast1.DrvAuthrty_Plc = Authority; objAcntMast1.DrvAcnt_No = AccountNo; objAcntMast1.DrvLNo_Verfd = varified; objAcntMast1.DrvGurntr_Idno = Guarantor; objAcntMast1.DrvFather_Nm = FatherName; objAcntMast1.Drv_Adres = DriverAddress; objAcntMast1.Drv_MobNo1 = Mobile1; objAcntMast1.Drv_MobNo2 = Mobile2; objAcntMast1.DrvBankAc_Nm = BankName; objAcntMast1.DrvBankAc_Adres = BankAddress; objAcntMast1.DrvAc_RtgsCode = RTGScode; objAcntMast1.DrvHazardLic_No = HazardousLicence; objAcntMast1.DrvHazardLic_NoExpDt = HazardousExpiryDate; objAcntMast1.PetrolComp_Idno = PCompIdno; objAcntMast1.Category_Idno = CatIdno; objAcntMast1.TinNo = TinNo; objAcntMast1.Pan_No = strPanNo; objAcntMast1.Account_No = AccNo; objAcntMast1.Bank_Name = AccBankName; objAcntMast1.Branch_Name = AccBranchName; objAcntMast1.Ifsc_Code = AccIfscCode; objAcntMast1.PComp_Idno = intPincIdno; objAcntMast1.detenPlant_charg = DetentionPlantcharge; objAcntMast1.detenPort_charg = DetentionPortcharge; objAcntMast1.Container_charg = Containerliftcharge; objAcntMast1.Lst_No = Lst_No; objAcntMast1.Cst_No = Cst_No; objAcntMast1.LdgrGSTIN_No = GSTINNo; objAcntMast1.Short_Name = ShortName; if (IsExists(strPartyName, intAcntIdno) == true) { intValue = -1; } else { db.SaveChanges(); intValue = intAcntIdno; } if (intValue > 0) { if (IsExistsOpen(Convert.ToInt64(Year_Idno), intAcntIdno) == true) { AcntOpen open = (from o in db.AcntOpens where o.Acnt_Idno == intValue && o.Year_Idno == Year_Idno select o).FirstOrDefault(); open.Open_Bal = OpenBalns; open.Open_Type = BalnceType; open.Acnt_Idno = intValue; open.DateModified = DateTime.Now; db.SaveChanges(); } else { AcntOpen open = new AcntOpen(); open.Open_Bal = OpenBalns; open.Open_Type = BalnceType; open.Year_Idno = Year_Idno; open.Acnt_Idno = intValue; open.DateModified = DateTime.Now; open.DateAdded = DateTime.Now; db.AcntOpens.AddObject(open); db.SaveChanges(); } if (dt != null && dt.Rows.Count > 0) { tblDocHolder objDocHolderDelete = (from mast in db.tblDocHolders where mast.Acnt_idno == intValue select mast).FirstOrDefault(); if (objDocHolderDelete != null) { db.tblDocHolders.DeleteObject(objDocHolderDelete); db.SaveChanges(); } for (int i = 0; i < dt.Rows.Count; i++) { tblDocHolder objDocHolderInsert = new tblDocHolder(); objDocHolderInsert.Doc_Name = dt.Rows[i]["DocName"].ToString(); objDocHolderInsert.Doc_Remark = dt.Rows[i]["Remark"].ToString(); objDocHolderInsert.Doc_Image = dt.Rows[i]["Image"].ToString(); objDocHolderInsert.Emp_Idno = empIdno; objDocHolderInsert.Acnt_idno = intValue; objDocHolderInsert.Date_Added = System.DateTime.Now; db.tblDocHolders.AddObject(objDocHolderInsert); db.SaveChanges(); } } } return(intValue); } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }