public bool IsDocExists(string strDocName, Int64 intDocIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDocHolder objDocHolder = new tblDocHolder();
if (intDocIdno <= 0)
{
}
else if (intDocIdno > 0)
{
objDocHolder = (from mast in db.tblDocHolders
where mast.Doc_Name == strDocName &&
mast.Doc_Idno != intDocIdno
select mast).FirstOrDefault();
}
if (objDocHolder != null)
{
return(true);
}
else
{
return(false);
}
}
}
public Int64 InsertDocHolderDetails(DataTable dt, Int64 intLorryIdno, Int32 empIdno)
{
Int64 intValue = 0;
Int32 intCompIdno = 1;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
if (dt != null && dt.Rows.Count > 0)
{
tblDocHolder objDocHolderDelete = (from mast in db.tblDocHolders
where mast.Lorry_Idno == intLorryIdno
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.Lorry_Idno = intLorryIdno;
objDocHolderInsert.Date_Added = System.DateTime.Now;
db.tblDocHolders.AddObject(objDocHolderInsert);
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
/// <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);
}
