public Int32 UpdateStatus(int intPPumpIdno, bool bStatus, Int32 empIdno) { int value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { PetrolPumpMaster objPetrolPumpMast = (from mast in db.PetrolPumpMasters where mast.PPump_Idno == intPPumpIdno select mast).FirstOrDefault(); if (objPetrolPumpMast != null) { objPetrolPumpMast.Emp_Idno = empIdno; objPetrolPumpMast.Status = bStatus; objPetrolPumpMast.Date_Modified = System.DateTime.Now; db.SaveChanges(); value = 1; } } } catch (Exception ex) { } return(value); }
/// <summary> /// Delete record from /// </summary> /// <param name="intColrIdno"></param> /// <returns></returns> public int Delete(int intPPumpIdno) { int intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { PetrolPumpMaster objMast = (from mast in db.PetrolPumpMasters where mast.PComp_Idno == intPPumpIdno select mast).FirstOrDefault(); if (objMast != null) { db.DeleteObject(objMast); 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); }
/// <summary> /// To check record existence in CityMaster /// </summary> /// <param name="strCityName"></param> /// <param name="intStateIdno"></param> /// <param name="intCityIdno"></param> /// <returns></returns> public bool IsExists(string strPumpName, Int64 intStateIdno, Int64 intCityIdno, Int64 intPPumpIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { PetrolPumpMaster objPetrolPumpMast = null; if (intPPumpIdno > 0)///for update { objPetrolPumpMast = (from CM in db.PetrolPumpMasters where CM.PPump_Name == strPumpName && CM.PPump_State == intStateIdno && CM.PPump_City != intCityIdno && CM.PPump_Idno != intPPumpIdno select CM).FirstOrDefault(); } else /// for insert { objPetrolPumpMast = (from nhu in db.PetrolPumpMasters where nhu.PPump_Name == strPumpName && nhu.PPump_State == intStateIdno && nhu.PPump_City != intCityIdno select nhu).FirstOrDefault(); } if (objPetrolPumpMast != null) { return(true); } else { return(false); } } }
/// <summary> /// Insert records in PetrolPumpMaster /// </summary> /// <param name="strCityName"></param> /// <param name="strAbb"></param> /// <param name="intStateIdno"></param> /// <param name="bStatus"></param> /// <returns></returns> public Int64 InsertPPumpMaster(string strPPumpName, Int64 PetrolCompanyIdno, string strPPumpPersonName, string strPPersonDesignation, string strPPumpLadlineCode, string strPPumpLadlineno, string strPPumpMobileno, string strPPumpAddress1, string strPPumpAddress2, Int64 intStateIdno, Int64 intCityIdno, bool bStatus, Int32 empIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { Int64 value; Int32 intCompIdno = 1; PetrolPumpMaster ObjPetrolPumpMaster = new PetrolPumpMaster(); if (IsExists(strPPumpName, intStateIdno, intCityIdno, 0)) { value = -1; } else { ObjPetrolPumpMaster.Emp_Idno = empIdno; ObjPetrolPumpMaster.PPump_Name = strPPumpName; ObjPetrolPumpMaster.PComp_Idno = PetrolCompanyIdno; ObjPetrolPumpMaster.PPumpPerson_Name = strPPumpPersonName; ObjPetrolPumpMaster.PPumpPerson_Designation = strPPersonDesignation; ObjPetrolPumpMaster.PPump_LadlineCode = strPPumpLadlineCode; ObjPetrolPumpMaster.PPump_Ladlineno = strPPumpLadlineno; ObjPetrolPumpMaster.PPump_Mobileno = strPPumpMobileno; ObjPetrolPumpMaster.PPump_Address1 = strPPumpAddress1; ObjPetrolPumpMaster.PPump_Address2 = strPPumpAddress2; ObjPetrolPumpMaster.PPump_State = intStateIdno; ObjPetrolPumpMaster.PPump_City = intCityIdno; ObjPetrolPumpMaster.Status = bStatus; ObjPetrolPumpMaster.Date_Added = System.DateTime.Now; db.AddToPetrolPumpMasters(ObjPetrolPumpMaster); db.SaveChanges(); value = ObjPetrolPumpMaster.PPump_Idno; } return(value); } }
/// <summary> /// Update records in PetrolPumpMaster /// </summary> /// <param name="strCityName"></param> /// <param name="strAbb"></param> /// <param name="bStatus"></param> /// <param name="intCityIdno"></param> /// <param name="intStateIdno"></param> /// <returns></returns> public Int64 UpdatePPumpMaster(string strPPumpName, Int64 PetrolCompanyIdno, string strPPumpPersonName, string strPPersonDesignation, string strPPumpLadlineCode, string strPPumpLadlineno, string strPPumpMobileno, string strPPumpAddress1, string strPPumpAddress2, Int64 intStateIdno, Int64 intCityIdno, Int64 intPPumpIdno, bool bStatus, Int32 empIdno) { Int64 value = 0; Int32 intCompIdno = 1; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { PetrolPumpMaster objPetrolPumpMaster = (from mast in db.PetrolPumpMasters where mast.PPump_Idno == intPPumpIdno select mast).FirstOrDefault(); if (objPetrolPumpMaster != null) { objPetrolPumpMaster.Emp_Idno = empIdno; objPetrolPumpMaster.PPump_Name = strPPumpName; objPetrolPumpMaster.PComp_Idno = PetrolCompanyIdno; objPetrolPumpMaster.PPumpPerson_Name = strPPumpPersonName; objPetrolPumpMaster.PPumpPerson_Designation = strPPersonDesignation; objPetrolPumpMaster.PPump_LadlineCode = strPPumpLadlineCode; objPetrolPumpMaster.PPump_Ladlineno = strPPumpLadlineno; objPetrolPumpMaster.PPump_Mobileno = strPPumpMobileno; objPetrolPumpMaster.PPump_Address1 = strPPumpAddress1; objPetrolPumpMaster.PPump_Address2 = strPPumpAddress2; objPetrolPumpMaster.PPump_State = intStateIdno; objPetrolPumpMaster.PPump_City = intCityIdno; objPetrolPumpMaster.Status = bStatus; objPetrolPumpMaster.Date_Modified = System.DateTime.Now; if (IsExists(strPPumpName, intStateIdno, intCityIdno, intPPumpIdno) == true) { value = -1; } else { db.SaveChanges(); value = intPPumpIdno; } } } return(value); }