public List <tblTranType> BindTranType()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <tblTranType> objTran = new List <tblTranType>();
objTran = (from obj in db.tblTranTypes
select obj).ToList();
return(objTran);
}
}
public List <tblItemMastPur> BindItemName()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <tblItemMastPur> objItemMast = new List <tblItemMastPur>();
objItemMast = (from obj in db.tblItemMastPurs
select obj).ToList();
return(objItemMast);
}
}
public IList CheckItemExistInOtherMaster(string SerialNo)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
return((from obj2 in db.Stckdetls
where obj2.SerialNo == SerialNo && (obj2.Is_Issued == true || obj2.MtrlIssue_Idno > 0 || obj2.Billed == true || obj2.Br_Trans == true)
select new
{
Idno = obj2.SerlDetl_id
}).ToList());
}
}
public Int64 CheckChallanDetails(Int64 GRHeadIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Int64 ChallanNo = 0;
ChallanNo = Convert.ToInt64((from a in db.TblGrHeads
join b in db.tblChlnBookHeads on a.Chln_Idno equals b.Chln_Idno
where a.GR_Idno == GRHeadIdno && a.Chln_Idno > 0
select b.Chln_No).FirstOrDefault());
return(ChallanNo);
}
}
public Int64 CountALL()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
return((from CH in db.tblChlnBookHeads
join cifrom in db.tblCityMasters on CH.BaseCity_Idno equals cifrom.City_Idno
join cito in db.tblCityMasters on CH.BaseCity_Idno equals cito.City_Idno
join LM in db.LorryMasts on CH.Truck_Idno equals LM.Lorry_Idno
where CH.Chln_type == 2 select CH.Chln_Idno).Count());
}
}
public List <AcntMast> BindPump()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <AcntMast> lst = new List <AcntMast>();
lst = (from cm in db.AcntMasts
where cm.Acnt_Type == 10 && cm.Status == true
orderby cm.Acnt_Name
select cm).ToList();
return(lst);
}
}
public List <tblCityMaster> BindToCity()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <tblCityMaster> objtblCityMaster = new List <tblCityMaster>();
objtblCityMaster = (from obj in db.tblCityMasters
where obj.AsLocation == true
orderby obj.City_Name
select obj).ToList();
return(objtblCityMaster);
}
}
public Int64 Countall()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Int32 Count = 0;
Count = (from obj in db.tblFreightMemoes
join CM in db.tblCityMasters on obj.ToCity_Idno equals CM.City_Idno
select obj.FMemo_Idno).Count();
return(Count);
}
}
//public List<AcntMast> BindGeneral(int Comp)
//{
// using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
// {
// List<AcntMast> objAcntMastList = new List<AcntMast>();
// objAcntMastList = (from obj in db.AcntMasts
// orderby obj.Acnt_Name
// where obj.Acnt_Type == 1 && obj.Comp_Idno == Comp
// select obj).ToList();
// return objAcntMastList;
// }
//}
//public List<AcntMast> BindSupplier(int Comp)
//{
// using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
// {
// List<AcntMast> objAcntMastList = new List<AcntMast>();
// objAcntMastList = (from obj in db.AcntMasts
// orderby obj.Acnt_Name
// where obj.Acnt_Type == 2 && obj.Comp_Idno == Comp
// select obj).ToList();
// return objAcntMastList;
// }
//}
//public List<USER> BindSupervisor()
//{
// using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
// {
// List<USER> objUserList = new List<USER>();
// objUserList = (from obj in db.USERS
// orderby obj.Name
// where obj.Desig_Idno == 4
// select obj).ToList();
// return objUserList;
// }
//}
public List <tblDesignation> BindDesignation()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <tblDesignation> objDesignationList = new List <tblDesignation>();
objDesignationList = (from obj in db.tblDesignations
orderby obj.Desig_Name
select obj).ToList();
return(objDesignationList);
}
}
//public Int64 SelectClaimByIdno(Int64 ClaimIdno)
//{
// using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
// {
// Int64 lst = Convert.ToInt64((from SBH in db.tblClaimHeads where SBH.ClaimHead_Idno == ClaimIdno select SBH.ClaimHead_Idno).FirstOrDefault());
// return lst;
// }
//}
public IList SelectSearchListReport(DateTime?DateFrom, DateTime?DateTo, string strClaimNo, Int64 intPrtyIdno, Int64 intFromLocation, Int64 intCompIdno, Int64 intYearIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from CH in db.tblClaimHeads
join acnts in db.AcntMasts on CH.Prty_Idno equals acnts.Acnt_Idno
join cifrom in db.tblCityMasters on CH.FromLoc_Idno equals cifrom.City_Idno
join acnts1 in db.AcntMasts on CH.Comp_Idno equals acnts1.Acnt_Idno
select new
{
CH.ClaimHead_Idno,
ClaimDate = CH.ClaimHead_Date,
PrefNo = CH.Prefix_No,
ClaimNo = CH.Claim_No,
YearIdno = CH.Year_Idno,
PartyIdno = acnts.Acnt_Idno,
PartyName = acnts.Acnt_Name,
CompanyIdno = acnts1.Acnt_Idno,
CompanyName = acnts1.Acnt_Name,
CityIdno = cifrom.City_Idno,
CityName = cifrom.City_Name,
}).ToList();
if (intYearIdno > 0)
{
lst = (from l in lst where l.YearIdno == intYearIdno select l).ToList();
}
if (intFromLocation > 0)
{
lst = (from l in lst where l.CityIdno == intFromLocation select l).ToList();
}
if (DateFrom != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.ClaimDate).Date >= Convert.ToDateTime(DateFrom).Date).ToList();
}
if (DateTo != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.ClaimDate).Date <= Convert.ToDateTime(DateTo).Date).ToList();
}
if (intPrtyIdno > 0)
{
lst = (from l in lst where l.PartyIdno == intPrtyIdno select l).ToList();
}
if (intCompIdno > 0)
{
lst = (from l in lst where l.CompanyIdno == intCompIdno select l).ToList();
}
if (strClaimNo != "")
{
lst = (from l in lst where ((l.PrefNo) + "" + (l.ClaimNo)) == strClaimNo select l).ToList();
}
return(lst);
}
}
public IList search(Int32 yearid, Int32 InvNo, DateTime?dtfrom, DateTime?dtto, int SenderIdno, Int32 FromCity, string GrType)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from CH in db.tblInvGenHeads
join AM in db.AcntMasts on CH.Sendr_Idno equals AM.Acnt_Idno
join CM in db.tblCityMasters on CH.BaseCity_Idno equals CM.City_Idno
where CH.Gr_Type == GrType
select new
{
CH.Inv_Idno,
CH.Sendr_Idno,
AM.Acnt_Name,
CH.Inv_Date,
CH.Inv_No,
CH.Inv_prefix,
CH.Net_Amnt,
CH.Year_Idno,
CH.BaseCity_Idno,
CM.City_Name,
CH.Admin_Approval,
CH.Gr_Type,
}).ToList();
if (InvNo > 0)
{
lst = lst.Where(l => l.Inv_No == InvNo).ToList();
}
if (dtto != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.Inv_Date).Date <= Convert.ToDateTime(dtto).Date).ToList();
}
if (dtfrom != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.Inv_Date).Date >= Convert.ToDateTime(dtfrom).Date).ToList();
}
if (SenderIdno > 0)
{
lst = lst.Where(l => l.Sendr_Idno == SenderIdno).ToList();
}
if (FromCity > 0)
{
lst = lst.Where(l => l.BaseCity_Idno == FromCity).ToList();
}
if (yearid > 0)
{
lst = lst.Where(l => l.Year_Idno == yearid).ToList();
}
return(lst);
}
}
public List <tblItemMastPur> BindPurchaseItemNameAll()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <tblItemMastPur> objItemMast = new List <tblItemMastPur>();
objItemMast = (from obj in db.tblItemMastPurs
orderby obj.Item_Name
where obj.ItemType == 1
select obj).ToList();
return(objItemMast);
}
}
public IList search(Int32 yearid, Int64 GrNo, DateTime?dtfrom, DateTime?dtto, int FromCity, Int32 SenderIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from CH in db.tblChlnAmntPayment_Head
//join cifrom in db.tblCityMasters on CH.BaseCity_Idno equals cifrom.City_Idno
join cito in db.tblCityMasters on CH.Loc_Idno equals cito.City_Idno
join AM in db.AcntMasts on CH.Party_IdNo equals AM.Acnt_Idno
join Am1 in db.AcntMasts on CH.RcptType_Idno equals Am1.Acnt_Idno into AM2
from Am3 in AM2.DefaultIfEmpty()
select new
{
CH.BaseCity_Idno,
CH.Rcpt_date,
CH.Rcpt_No,
CH.Id,
CH.Inst_Dt,
CH.Inst_No,
FromCity = cito.City_Name,
CH.Year_IdNo,
AM.Acnt_Name,
AM.Acnt_Idno,
ReciptName = Am3.Acnt_Name,
CH.Net_Amnt
}).ToList();
if (GrNo > 0)
{
lst = lst.Where(l => l.Rcpt_No == GrNo).ToList();
}
if (dtto != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.Rcpt_date).Date <= Convert.ToDateTime(dtto).Date).ToList();
}
if (dtfrom != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.Rcpt_date).Date >= Convert.ToDateTime(dtfrom).Date).ToList();
}
if (FromCity > 0)
{
lst = lst.Where(l => l.BaseCity_Idno == FromCity).ToList();
}
if (yearid > 0)
{
lst = lst.Where(l => l.Year_IdNo == yearid).ToList();
}
if (SenderIdno > 0)
{
lst = lst.Where(l => l.Acnt_Idno == SenderIdno).ToList();
}
return(lst);
}
}
public IList Select(Int64 YearIdno, Int64 LocIdno, Int64 TruckIdno, Int64 DriverIdno, Int64 PumpIdno, Int64 SlipNo)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var Lst = (from FSH in db.tblFuelSlipHeads
join FSD in db.tblFuelSlipDetls on FSH.FuelSlip_Idno equals FSD.FuelSlipHead_Idno
join CM in db.tblCityMasters on FSH.Loc_Idno equals CM.City_Idno
join LM in db.LorryMasts on FSH.Truck_Idno equals LM.Lorry_Idno
// join DM in db.DriverMasts on FSH.Driver_Idno equals DM.Driver_Idno
join PM in db.AcntMasts on FSH.Pump_Idno equals PM.Acnt_Idno
join IM in db.tblItemMastPurs on FSD.Iteam_Idno equals IM.Item_Idno
select new
{
SlipNo = FSH.FuelSlip_No,
Id = FSH.FuelSlip_Idno,
LocId = FSH.Loc_Idno,
LocName = CM.City_Name,
LorryId = LM.Lorry_Idno,
LorryName = LM.Lorry_No,
DriverId = LM.Driver_Idno,
Driver = LM.Lorry_Type == 1 ? (from N in db.DriverMasts where N.Driver_Idno == LM.Driver_Idno select N.Driver_Name).FirstOrDefault() : (from M in db.AcntMasts where M.Acnt_Idno == FSH.Driver_Idno select M.Acnt_Name).FirstOrDefault(),
PumpId = PM.Acnt_Idno,
Pump = PM.Acnt_Name,
ItemName = IM.Item_Name,
Qty = FSD.Item_Qty,
Amount = FSD.Item_Amnt,
Date = FSH.FuelSlip_Date,
YearIdno = FSH.Year_Idno,
}).ToList();
if (YearIdno > 0)
{
Lst = Lst.Where(r => r.YearIdno == YearIdno).ToList();
}
if (LocIdno > 0)
{
Lst = Lst.Where(r => r.LocId == LocIdno).ToList();
}
if (TruckIdno > 0)
{
Lst = Lst.Where(r => r.LorryId == TruckIdno).ToList();
}
if (PumpIdno > 0)
{
Lst = Lst.Where(r => r.PumpId == PumpIdno).ToList();
}
if (SlipNo > 0)
{
Lst = Lst.Where(r => r.SlipNo == SlipNo).ToList();
}
return(Lst);
}
}
//
public Int64 countallslip()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Int32 count = 0;
count = (from lorryhire in db.tblLorryHireSlips
join Listlorry in db.LorryMasts on lorryhire.Lry_Idno equals Listlorry.Lorry_Idno
join ListCity in db.tblCityMasters on lorryhire.Loc_Idno equals ListCity.City_Idno
select lorryhire.LryHire_Idno).Count();
return(count);
}
}
public Double FillChlnDetNetAmnt(string ConString, int id)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
SqlParameter[] objSqlPara = new SqlParameter[2];
objSqlPara[0] = new SqlParameter("@Action", "FillChlnDetNetAmnt");
objSqlPara[1] = new SqlParameter("@Id", id);
Double Amnt = Convert.ToDouble(SqlHelper.ExecuteScalar(ConString, CommandType.StoredProcedure, "spPayRecAgChlnBk", objSqlPara));
return(Amnt);
}
}
public Int64 Count()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
return((from CT in db.tblCityMasters
join sm in db.tblStateMasters on CT.State_Idno equals sm.State_Idno
select new
{
CityIdno = CT.City_Idno,
}).Count());
}
}
public List <AcntMast> BindPrty()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <AcntMast> lst = null;
lst = (from cm in db.AcntMasts
join LM in db.LorryMasts on cm.Acnt_Idno equals LM.Prty_Idno
where cm.INTERNAL == false
select cm).OrderBy(c => c.Acnt_Name).Distinct().ToList();
return(lst);
}
}
public Int64 Update(tblMatIssueAgnClaimHead obj, Int32 Head_Idno, DataTable Dttemp)
{
Int64 MatIssueHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblMatIssueAgnClaimHead CH = db.tblMatIssueAgnClaimHeads.Where(ch => ch.MatIss_No == obj.MatIss_No && ch.MatIssAgnClaimHead_Idno != Head_Idno && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (CH != null)
{
MatIssueHeadIdno = -1;
}
else
{
tblMatIssueAgnClaimHead CHead = db.tblMatIssueAgnClaimHeads.Where(ch => ch.MatIssAgnClaimHead_Idno == Head_Idno).FirstOrDefault();
if (CHead != null)
{
db.SaveChanges();
MatIssueHeadIdno = CHead.MatIssAgnClaimHead_Idno;
List <tblMatIssueAgnClaimDetl> ClaimDetl = db.tblMatIssueAgnClaimDetls.Where(cd => cd.MatIssAgnClaimHead_Idno == Head_Idno).ToList();
foreach (tblMatIssueAgnClaimDetl tcd in ClaimDetl)
{
db.tblMatIssueAgnClaimDetls.DeleteObject(tcd);
db.SaveChanges();
}
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblMatIssueAgnClaimDetl objDetl = new tblMatIssueAgnClaimDetl();
objDetl.MatIssAgnClaimHead_Idno = MatIssueHeadIdno;
objDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]);
db.tblMatIssueAgnClaimDetls.AddObject(objDetl);
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(MatIssueHeadIdno);
}
public List <LaneMaster> SelectList(string Name)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var Lst = db.LaneMasters.OrderBy(obj => obj.Lane_Name).ToList();
if (Name != "")
{
Lst = Lst.Where(e => e.Lane_Name.ToLower().Contains(Name.ToLower())).ToList();
}
return(Lst);
}
}
//
public IList SearchLorryHire(Int64 intLorryidno, Int32 intYearId, Int64 intlocidno, Int32 intslipno, DateTime?dtfrom, DateTime?dtto)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from lorryhire in db.tblLorryHireSlips
join Listlorry in db.LorryMasts on lorryhire.Lry_Idno equals Listlorry.Lorry_Idno
join ListCity in db.tblCityMasters on lorryhire.Loc_Idno equals ListCity.City_Idno
select new
{
lorryhire.Loc_Idno,
lorryhire.Lry_Date,
lorryhire.Lry_SlipNo,
lorryhire.Net_amnt,
lorryhire.AdvanceAmnt,
lorryhire.SupliedTo,
lorryhire.TotalFrghtAmnt,
lorryhire.Lry_Idno,
lorryhire.LryHire_Idno,
lorryhire.Year_Idno,
Listlorry.Lorry_No,
ListCity.City_Name,
}).Distinct().ToList();
if (dtto != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.Lry_Date).Date <= Convert.ToDateTime(dtto).Date).ToList();
}
if (dtfrom != null)
{
lst = lst.Where(l => Convert.ToDateTime(l.Lry_Date).Date >= Convert.ToDateTime(dtfrom).Date).ToList();
}
if (intYearId > 0)
{
lst = lst.Where(l => l.Year_Idno == intYearId).ToList();
}
if (intlocidno > 0)
{
lst = lst.Where(l => l.Loc_Idno == intlocidno).ToList();
}
if (intslipno > 0)
{
lst = lst.Where(l => l.Lry_SlipNo == intslipno).ToList();
}
if (intLorryidno > 0)
{
lst = lst.Where(l => l.Lry_Idno == intLorryidno).ToList();
}
return(lst);
}
}
public int DeleteALL(Int64 HeadIdno)
{
int Value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
List <tblChlnDelvDetl> objTranDetl = (from objDetl in db.tblChlnDelvDetls
where objDetl.ChlnDelvHead_Idno == HeadIdno
select objDetl).ToList();
if (objTranDetl != null)
{
foreach (var d in objTranDetl)
{
db.tblChlnDelvDetls.DeleteObject(d);
db.SaveChanges();
}
List <TblGrHead> objTblGrHead = (from objDetl in db.TblGrHeads
where objDetl.ChlnDelv_Idno == HeadIdno
select objDetl).ToList();
if (objTblGrHead != null)
{
foreach (var lst in objTblGrHead)
{
lst.ChlnDelv_Idno = 0;
lst.Gr_Delv = false;
db.SaveChanges();
}
}
tblChlnDelvHead objTransHead = (from objHead in db.tblChlnDelvHeads
where objHead.ChlnDelvHead_Idno == HeadIdno
select objHead).SingleOrDefault();
if (objTransHead != null)
{
db.tblChlnDelvHeads.DeleteObject(objTransHead);
db.SaveChanges();
Value = 1;
tScope.Complete();
}
}
}
}
}
catch (Exception Ex)
{
}
return(Value);
}
public Int64 Insert(Int64 FuelSlip_No, DateTime?FuelSlip_Date, Int64 Loc_Idno, Int64 Truck_Idno, Int64 Pump_Idno, Int64 Driver_Idno, Int64 Year_Idno, DateTime?Date_Added, double NetAmnt, DataTable dtDetail, string InvoiceNo)
{
Int64 FuelSlip_Idno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblFuelSlipHead objFuelSlipHead = db.tblFuelSlipHeads.Where(bill => (bill.FuelSlip_No == FuelSlip_No) && (bill.Year_Idno == Year_Idno) && (bill.Loc_Idno == Loc_Idno)).FirstOrDefault();
if (objFuelSlipHead == null)
{
objFuelSlipHead = new tblFuelSlipHead();
objFuelSlipHead.FuelSlip_No = FuelSlip_No;
objFuelSlipHead.FuelSlip_Date = FuelSlip_Date;
objFuelSlipHead.Loc_Idno = Loc_Idno;
objFuelSlipHead.Truck_Idno = Truck_Idno;
objFuelSlipHead.Pump_Idno = Pump_Idno;
objFuelSlipHead.Driver_Idno = Driver_Idno;
objFuelSlipHead.Year_Idno = Year_Idno;
objFuelSlipHead.Date_Added = Date_Added;
objFuelSlipHead.Net_Amnt = NetAmnt;
objFuelSlipHead.Invoice_No = InvoiceNo;
db.tblFuelSlipHeads.AddObject(objFuelSlipHead);
db.SaveChanges();
FuelSlip_Idno = objFuelSlipHead.FuelSlip_Idno;
if (FuelSlip_Idno > 0)
{
foreach (DataRow dr in dtDetail.Rows)
{
tblFuelSlipDetl objFuelSlipDetl = new tblFuelSlipDetl();
objFuelSlipDetl.FuelSlipHead_Idno = FuelSlip_Idno;
objFuelSlipDetl.Iteam_Idno = Convert.ToInt64(dr["ItemNameIdno"]);
objFuelSlipDetl.Item_Qty = Convert.ToDouble(String.Format("{0:0,0.00}", Convert.ToString(dr["Qty"])));
objFuelSlipDetl.Item_Rate = Convert.ToDouble(String.Format("{0:0,0.00}", Convert.ToString(dr["Rate"])));
objFuelSlipDetl.Item_Amnt = Convert.ToDouble(String.Format("{0:0,0.00}", Convert.ToString(dr["Amount"])));
db.tblFuelSlipDetls.AddObject(objFuelSlipDetl);
db.SaveChanges();
}
}
}
else
{
return(FuelSlip_Idno);
}
}
catch (Exception ex)
{
return(-1);
}
return(FuelSlip_Idno);
}
}
/// <summary>
/// Update records in tblItemMastPur
/// </summary>
/// <param name="strUOMName"></param>
/// <param name="strUOMDesc"></param>
/// <param name="bStatus"></param>
/// <param name="intUOMIdno"></param>
/// <returns></returns>
public Int64 Update(string strItemName, string strItemNameHindi, string strItemDesc, Int64 GrpType, Int64 ItemUnit, Double PurRate, Double VATTaxPer, Double CSTTaxPer, bool bStatus, Int64 intItemIdno, Int64 ItemType, Int64 TyreIdno, string Companyname, string ModelName, Int32 empIdno, double sgst, double cgst, double igst, double itemmrp)
{
Int64 intValue = 0;
//Int32 intCompIdno = 1;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblItemMastPur objItemMast = (from mast in db.tblItemMastPurs
where mast.Item_Idno == intItemIdno
select mast).FirstOrDefault();
if (objItemMast != null)
{
objItemMast.Item_Name = strItemName;
objItemMast.ItemNamel_Hindi = strItemNameHindi;
objItemMast.Item_Desc = strItemDesc;
objItemMast.Pur_Rate = PurRate;
objItemMast.VATTax_Per = VATTaxPer;
objItemMast.CSTTax_Per = CSTTaxPer;
objItemMast.Status = bStatus;
objItemMast.Unit_Idno = ItemUnit;
objItemMast.IGrp_Idno = GrpType;
objItemMast.ItemType = ItemType;
objItemMast.Tyre_Type = TyreIdno;
objItemMast.Comp_Name = Companyname;
objItemMast.Model_Name = ModelName;
objItemMast.Emp_Idno = empIdno;
objItemMast.SGST = sgst;
objItemMast.CGST = cgst;
objItemMast.IGST = igst;
objItemMast.Item_MRP = itemmrp;
objItemMast.Date_Modified = System.DateTime.Now;
if (IsExists(strItemName, intItemIdno) == true)
{
intValue = -1;
}
else
{
db.SaveChanges();
intValue = intItemIdno;
}
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public Int64 SelectTotal()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from mast in db.tblCategoryMasts
orderby mast.Category_Name ascending
select new
{
mast
}).Count();
return(lst);
}
}
public IList CheckIExistInOther(Int32 Pbillidno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
return((from obj in db.tblTripFuelDetls
where obj.Pbill_Idno == Pbillidno
select new
{
ItemGrp = obj.Pbill_Idno
}
).ToList());
}
}
public IList checkPurchaseBillNumberExist(Int64 BillNumberm, Int64 BillYear)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from obj in db.tblPBillHeads
where obj.Loc_Idno == BillNumberm && obj.Year_Idno == BillYear
select new
{
obj.Loc_Idno
}).ToList();
return(lst);
}
}
public DataSet SelecGRdetl(string Constring, string Action, Int64 Locid, Int64 Grno, Int64 YearId)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
SqlParameter[] objSqlParameter = new SqlParameter[4];
objSqlParameter[0] = new SqlParameter("@Action", Action);
objSqlParameter[1] = new SqlParameter("@GrNO", Grno);
objSqlParameter[2] = new SqlParameter("@LOCID", Locid);
objSqlParameter[3] = new SqlParameter("@YearId", YearId);
DataSet ds = SqlHelper.ExecuteDataset(Constring, CommandType.StoredProcedure, "spUpdateGr", objSqlParameter);
return(ds);
}
}
public List <tblPositionMast> Bindtyreposition()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <tblPositionMast> obj1 = new List <tblPositionMast>();
obj1 = (from obj in db.tblPositionMasts
orderby obj.Position_name
select obj).ToList();
return(obj1);
}
}
public IList CheckDuplicateGrNo(Int64 intMatNo, Int64 LoctionIdno, Int64 intYearIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from m in db.MatIssHeads
where m.MatIss_No == intMatNo && m.Year_Idno == intYearIdno && m.Mat_Frm == "BK" && m.Loc_Idno == LoctionIdno
select new
{
m.MatIss_No
}).ToList();
return(lst);
}
}
