public Int64 InsertPartyChangeDetails(DataTable dt)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tblLorryPrtyDetl objNewPartyInsert = new tblLorryPrtyDetl();
if (IsPartyExists(Convert.ToInt64(dt.Rows[i]["LorryIdNo"]), Convert.ToInt64(dt.Rows[i]["AcntIdno"]), Convert.ToDateTime(dt.Rows[i]["ValidFrom"])) == true)
{
intValue = -1;
}
else
{
objNewPartyInsert.Lorry_Idno = Convert.ToInt64(dt.Rows[i]["LorryIdNo"]);
objNewPartyInsert.Acnt_Idno = Convert.ToInt64(dt.Rows[i]["AcntIdno"]);
objNewPartyInsert.Valid_From = Convert.ToDateTime(dt.Rows[i]["ValidFrom"]);
db.tblLorryPrtyDetls.AddObject(objNewPartyInsert);
db.SaveChanges();
LorryMast objLorryMast = new LorryMast();
Int64 LorryIdno = Convert.ToInt64(dt.Rows[i]["LorryIdNo"]);
objLorryMast = (from mast in db.LorryMasts
where mast.Lorry_Idno == LorryIdno
select mast).FirstOrDefault();
if (objLorryMast != null)
{
objLorryMast.Prty_Idno = Convert.ToInt64(dt.Rows[i]["AcntIdno"]);
db.SaveChanges();
}
}
}
intValue = 1;
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public bool IsPartyExists(Int64 lorryIdno, Int64 AcntIdno, DateTime date)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblLorryPrtyDetl objLorryMast = new tblLorryPrtyDetl();
objLorryMast = (from mast in db.tblLorryPrtyDetls
where mast.Acnt_Idno == AcntIdno &&
mast.Lorry_Idno == lorryIdno && mast.Valid_From == date
select mast).FirstOrDefault();
if (objLorryMast != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Update records in LorryMast
/// </summary>
/// <param name="strNarrName"></param>
/// <param name="strNarrDesc"></param>
/// <param name="bStatus"></param>
/// <param name="intNarrIdno"></param>
/// <returns></returns>
public Int64 UpdateLorryMast(string strLorryMake, string strLorryMakeYar, string strOwnerName, Int32 LorryType, Int64 PartyName, string strChasisNo, string strNumberOfTyres, string strEngineNo, string strLorryNo, string strPanNo, bool bStatus, bool bcommsn, Int64 intType, Int64 intLorryIdno, int pantypeIdno, DateTime?FitnessDate, DateTime?RCDate, DateTime?NatPermitDate, DateTime?AuthPermitDate, string TrollyLength, string TrollyHeight, string TrollyWeight, string TrollyTyerNo, string InsNo, string InsCompName, DateTime?InsValidDate, string FinName, string FinAmount, string FinEMIAmount, string FinTotalInstall, DateTime?FinPeriodFrom, DateTime?FinPeriodTo, bool CalOnDF, Int64 DriverIdno, Double InsurAmount, int FITwarn, int INSwarn, int RCwarn, int NatWarn, int AuthWarn, Int32 empIdno, bool LowRate, string strOwnerAdd, string strOwnerMobile)
{
Int64 intValue = 0;
//Int32 intLorryIdno = 1;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
LorryMast objLorryMast = (from mast in db.LorryMasts
where mast.Lorry_Idno == intLorryIdno
select mast).FirstOrDefault();
if (objLorryMast != null)
{
objLorryMast.Lorry_Make = strLorryMake;
objLorryMast.Lorry_Year = strLorryMakeYar;
objLorryMast.Owner_Name = strOwnerName;
objLorryMast.Owner_Address = strOwnerAdd;
objLorryMast.Owner_Mobile = strOwnerMobile;
objLorryMast.Lorry_Type = LorryType;
objLorryMast.Status = bStatus;
objLorryMast.chk_ComsnCal = bcommsn;
objLorryMast.Type = intType;
objLorryMast.Ins_Amount = InsurAmount;
objLorryMast.Emp_Idno = empIdno;
objLorryMast.Prty_Idno = PartyName;
objLorryMast.Chassis_no = strChasisNo;
objLorryMast.Tyres_No = strNumberOfTyres;
objLorryMast.Eng_No = strEngineNo;
objLorryMast.Lorry_No = strLorryNo;
objLorryMast.Pan_No = strPanNo;
objLorryMast.PANTyp_Idno = pantypeIdno;
objLorryMast.Fitness_Date = FitnessDate;
objLorryMast.RC_Date = RCDate;
objLorryMast.Nat_Permit_Date = NatPermitDate;
objLorryMast.Auth_Permit_Date = AuthPermitDate;
objLorryMast.Trolly_Length = TrollyLength;
objLorryMast.Trolly_Height = TrollyHeight;
objLorryMast.Trolly_Weight = TrollyWeight;
objLorryMast.Trolly_TyerNo = TrollyTyerNo;
objLorryMast.Ins_No = InsNo;
objLorryMast.Ins_Comp_Name = InsCompName;
objLorryMast.Ins_Valid_Date = InsValidDate;
objLorryMast.Fin_Name = FinName;
objLorryMast.Fin_Amount = FinAmount;
objLorryMast.Fin_EMI_Amount = FinEMIAmount;
objLorryMast.Fin_Total_Install = FinTotalInstall;
objLorryMast.Fin_Period_From = FinPeriodFrom;
objLorryMast.Fin_Period_To = FinPeriodTo;
objLorryMast.Driver_Idno = DriverIdno;
objLorryMast.FITwarn = FITwarn;
objLorryMast.INSwarn = INSwarn;
objLorryMast.RCwarn = RCwarn;
objLorryMast.NatWarn = NatWarn;
objLorryMast.AuthWarn = AuthWarn;
objLorryMast.CalOn_DF = CalOnDF;
objLorryMast.LowRateWise = LowRate;
objLorryMast.Date_Added = System.DateTime.Now;
if (IsExists(strLorryNo, intLorryIdno) == true)
{
intValue = -1;
}
else
{
db.SaveChanges();
intValue = intLorryIdno;
}
if (intValue > 0)
{
tblLorryPrtyDetl lPrty = db.tblLorryPrtyDetls.Where(X => X.Lorry_Idno == intValue && X.Acnt_Idno == PartyName).FirstOrDefault();
if (lPrty != null)
{
//string strSQL = @"select Convert(nvarchar(11),convert(datetime,StartDate,105),105) AS SDate from tblFinYear order by Fin_Idno desc";
//DataSet ds = SqlHelper.ExecuteDataset(MultipleDBDAL.strDynamicConString(), CommandType.Text, strSQL);
//string strNewDate = ds.Tables[0].Rows[0]["SDate"].ToString();
var strNewDate = db.tblFinYears.Select(o => o.StartDate).Max();
// lPrty.Lorry_Idno = intValue;
// lPrty.Acnt_Idno = PartyName;
//lPrty.Valid_From = Convert.ToDateTime(strNewDate);
db.SaveChanges();
}
}
IList <LorryMast> obj = db.LorryMasts.Where(lm => lm.Pan_No == objLorryMast.Pan_No).ToList();
if (obj.Count > 0)
{
foreach (LorryMast rw in obj)
{
rw.CalOn_DF = objLorryMast.CalOn_DF;
rw.LowRateWise = objLorryMast.LowRateWise;
db.SaveChanges();
}
}
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}