public DataTable FetchChallanDetail(string ConString, int yearid)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
SqlParameter[] objSqlPara = new SqlParameter[2];
objSqlPara[0] = new SqlParameter("@Action", "SelectChlnDet");
objSqlPara[1] = new SqlParameter("@YearIdno", yearid);
DataSet objDsTemp = SqlHelper.ExecuteDataset(ConString, CommandType.StoredProcedure, "spChlnConfirm", objSqlPara);
DataTable objDtTemp = new DataTable();
if (objDsTemp.Tables.Count > 0)
{
if (objDsTemp.Tables[0].Rows.Count > 0)
{
objDtTemp = objDsTemp.Tables[0];
}
}
return(objDtTemp);
}
}
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);
}
}
}
public IList SelectForSearch(string PostionName)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from CT in db.tblPositionMasts
select new
{
PositIdno = CT.Position_id,
PositName = CT.Position_name,
Status = CT.IsActive,
}).ToList();
if (PostionName != "")
{
lst = (from I in lst where I.PositName.ToLower().Contains(PostionName.ToLower()) select I).ToList();
}
return(lst);
}
}
public IList SelectDetlByItemIdno(Int64 YearIdno, Int64 LocIdno, Int64 itemIdno, Int64 tyresizeIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var Lst = (from mast in db.Stckdetls
join PM in db.tblItemMastPurs on mast.ItemIdno equals PM.Item_Idno
join L in db.tblCityMasters on mast.Loc_Idno equals L.City_Idno
join TS in db.TyreSizeMasters on mast.TyresizeIdno equals TS.TyreSize_Idno into temptyre
from TS in temptyre.DefaultIfEmpty()
where mast.Item_from == "O"
select new
{
Item_Name = PM.Item_Name,
YearIdno = mast.yearId,
Item_Idno = mast.ItemIdno,
Loc_Idno = mast.Loc_Idno,
Loc_Name = L.City_Name,
SerialNo = mast.SerialNo,
SerialIdno = mast.SerlDetl_id,
CompName = mast.CompName,
ItemType = mast.Type,
PurFrom = mast.PurFrom,
OpenRate = mast.OpenRate,
tyresizeidno = mast.TyresizeIdno,
tyresize = TS.TyreSize
}).ToList();
if (YearIdno > 0)
{
Lst = Lst.Where(r => r.YearIdno == YearIdno).ToList();
}
if (LocIdno > 0)
{
Lst = Lst.Where(r => r.Loc_Idno == LocIdno).ToList();
}
if (itemIdno > 0)
{
Lst = Lst.Where(r => r.Item_Idno == itemIdno).ToList();
}
return(Lst);
}
}
/// <summary>
///
/// </summary>
/// <param name="intUOMIdno"></param>
/// <param name="strItemName"></param>
/// <returns></returns>
public IList SelectForSearch(int intItemTypeIdno, string strItemName, Int64 itemtype)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from mast in db.tblItemMastPurs
join ig in db.tblIGrpMasts on mast.IGrp_Idno equals ig.IGrp_Idno
join IM in db.tblItemTypeMasts on mast.ItemType equals IM.ItemTpye_Idno
join u in db.UOMMasts on mast.Unit_Idno equals u.UOM_Idno
select new
{
ItemIdno = mast.Item_Idno,
ItemName = mast.Item_Name,
IgrpName = ig.IGrp_Name,
UOMName = u.UOM_Name,
ItemDesc = mast.Item_Desc,
PurRate = mast.Pur_Rate,
VATTaxPer = mast.VATTax_Per,
CSTTaxPer = mast.CSTTax_Per,
Status = mast.Status,
IGrp_Idno = ig.IGrp_Idno,
Item_TypeID = mast.ItemType,
TypeName = IM.ItemType_Name,
SGST = mast.SGST,
CGST = mast.CGST,
IGST = mast.IGST
}).ToList();
if (strItemName != "")
{
lst = (from I in lst where I.ItemName.ToLower().Contains(strItemName.ToLower()) select I).ToList();
}
if (intItemTypeIdno > 0)
{
lst = (from I in lst where I.IGrp_Idno == intItemTypeIdno select I).ToList();
}
if (itemtype > 0)
{
lst = (from I in lst where I.Item_TypeID == itemtype select I).ToList();
}
return(lst);
}
}
public IList SelectForSearch(string strPPumpName, Int32 intStateIdno, Int32 intCityIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from CT in db.PetrolPumpMasters
join sm in db.tblStateMasters on CT.PPump_State equals sm.State_Idno
join cm in db.tblCityMasters on CT.PPump_City equals cm.City_Idno
join com in db.tblPCompanyMasters on CT.PComp_Idno equals com.PComp_Idno
select new
{
PPumpIdno = CT.PPump_Idno,
PPumpName = CT.PPump_Name,
PCompIdno = com.PComp_Idno,
PCompName = com.PComp_Name,
PPumpPersonName = CT.PPumpPerson_Name,
PPumpPersonDesignation = CT.PPumpPerson_Designation,
PPumpLadlineCode = CT.PPump_LadlineCode,
PPumpLadlineno = CT.PPump_Ladlineno,
PPumpMobileno = CT.PPump_Mobileno,
PPumpAddress1 = CT.PPump_Address1,
PPumpAddress2 = CT.PPump_Address2,
PPumpStateIdno = sm.State_Idno,
PPumpCityIdno = cm.City_Idno,
PPumpState = sm.State_Name,
PPumpCity = cm.City_Name,
Status = CT.Status,
}).ToList();
if (intStateIdno > 0)
{
lst = (from l in lst where l.PPumpStateIdno == intStateIdno select l).ToList();
}
if (intCityIdno > 0)
{
lst = (from l in lst where l.PPumpCityIdno == intCityIdno select l).ToList();
}
if (strPPumpName != "")
{
lst = (from l in lst where l.PPumpName.ToLower().Contains(strPPumpName.ToLower()) select l).ToList();
}
return(lst);
}
}
public DataTable SelectPayDet(string ConString, int id)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
SqlParameter[] objSqlPara = new SqlParameter[2];
objSqlPara[0] = new SqlParameter("@Action", "SelectPayDet");
objSqlPara[1] = new SqlParameter("@Id", id);
DataSet objDsTemp = SqlHelper.ExecuteDataset(ConString, CommandType.StoredProcedure, "spPayRecAgChlnBk", objSqlPara);
DataTable objDtTemp = new DataTable();
if (objDsTemp.Tables.Count > 0)
{
if (objDsTemp.Tables[0].Rows.Count > 0)
{
objDtTemp = objDsTemp.Tables[0];
}
}
return(objDtTemp);
}
}
public DataTable SelecthireDetail(Int64 hireIDNO, string con)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
SqlParameter[] objSqlPara = new SqlParameter[2];
objSqlPara[0] = new SqlParameter("@Action", "SelectHireDetail");
objSqlPara[1] = new SqlParameter("@Id", hireIDNO);
DataSet objDsTemp = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spHireLorryDetl", objSqlPara);
DataTable objDtTemp = new DataTable();
if (objDsTemp.Tables.Count > 0)
{
if (objDsTemp.Tables[0].Rows.Count > 0)
{
objDtTemp = objDsTemp.Tables[0];
}
}
return(objDtTemp);
}
}
public Int64 Count(Int64 YearIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
return((from SM in db.StckMasts
join
IM in db.tblItemMastPurs on SM.Item_Idno equals IM.Item_Idno
join
CM in db.tblCityMasters on SM.Loc_Idno equals CM.City_Idno
where SM.Year_Idno == YearIdno && IM.ItemType == 2
select new
{
YearIdno = SM.Year_Idno,
LocIdno = SM.Loc_Idno,
LocName = CM.City_Name,
Qty = (from S in db.StckMasts where S.Loc_Idno == SM.Loc_Idno select S.Open_Qty).Sum()
}).Distinct().Count());
}
}
public DataTable selectInvoiceReportDetails(string strAction, Int32 Inv_Idno, string con)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
SqlParameter[] objSqlPara = new SqlParameter[2];
objSqlPara[0] = new SqlParameter("@Action", strAction);
objSqlPara[1] = new SqlParameter("@InvoiceNo", Inv_Idno);
DataSet objDsTemp = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spInvoiceReport", objSqlPara);
DataTable objDtTemp = new DataTable();
if (objDsTemp.Tables.Count > 0)
{
if (objDsTemp.Tables[0].Rows.Count > 0)
{
objDtTemp = objDsTemp.Tables[0];
}
}
return(objDtTemp);
}
}
/// <summary>
///
/// </summary>
/// <param name="intUOMIdno"></param>
/// <param name="strUOMName"></param>
/// <returns></returns>
public IList SelectForSearch(string strUOMName)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from mast in db.UOMMasts
select new
{
UOMIdno = mast.UOM_Idno,
UOMName = mast.UOM_Name,
UOMDesc = mast.UOM_Desc,
Status = mast.Status
}).ToList();
if (strUOMName != "")
{
lst = (from I in lst where I.UOMName.ToLower().Contains(strUOMName.ToLower()) select I).ToList();
}
return(lst);
}
}
/// <summary>
/// Update records in ItemMast
/// </summary>
/// <param name="strUOMName"></param>
/// <param name="strUOMDesc"></param>
/// <param name="bStatus"></param>
/// <param name="intUOMIdno"></param>
/// <returns></returns>
public Int64 Update(tblFreightMemo obj, Int64 HeadIdno)
{
Int64 intValue = 0;
//Int32 intCompIdno = 1;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblFreightMemo objItemMast = (from mast in db.tblFreightMemoes
where mast.FMemo_Idno == HeadIdno
select mast).FirstOrDefault();
if (objItemMast != null)
{
objItemMast.Rcpt_Date = obj.Rcpt_Date;
objItemMast.Rcpt_No = obj.Rcpt_No;
objItemMast.Gr_No = obj.Gr_No;
objItemMast.ToCity_Idno = obj.ToCity_Idno;
objItemMast.Receiver_Idno = obj.Receiver_Idno;
objItemMast.Tot_Qty = obj.Tot_Qty;
objItemMast.Tot_Weight = obj.Tot_Weight;
objItemMast.Freight_Amnt = obj.Freight_Amnt;
objItemMast.Service_Amnt = obj.Service_Amnt;
objItemMast.Labour_Amnt = obj.Labour_Amnt;
objItemMast.Delivery_Amnt = obj.Delivery_Amnt;
objItemMast.Octrai_Amnt = obj.Octrai_Amnt;
objItemMast.Damage_Amnt = obj.Damage_Amnt;
objItemMast.Net_Amnt = obj.Net_Amnt;
objItemMast.GR_Idno = obj.GR_Idno;
objItemMast.Year_Idno = obj.Year_Idno;
objItemMast.Remarks = obj.Remarks;
db.SaveChanges();
intValue = objItemMast.FMemo_Idno;
// }
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public Int64 Insert(string CompName, string OwnerName, string LastName, string EmailId, string OwnPhoneNum, string OwnMobileNum, string Ipaddress, Boolean Status)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities())
{
if (IsExists(EmailId) == true)
{
intValue = -1;
}
else
{
tblNewReg objtblRegister = new tblNewReg();
objtblRegister.Comp_Name = CompName;
objtblRegister.Name = OwnerName;
objtblRegister.LastName = LastName;
//objtblRegister.NewReg_Addr2 = Address2;
//objtblRegister.City_Idno = CityIdno;
//objtblRegister.State_Idno = StateIdno;
//objtblRegister.Pin_No = PinNo;
objtblRegister.Email_Id = EmailId;
//objtblRegister.Phone_No = OwnPhoneNum;
objtblRegister.Mobile_No = OwnMobileNum;
objtblRegister.Date_Addedd = System.DateTime.Now;
objtblRegister.Ipaddress = Ipaddress;
objtblRegister.Status = Status;
db.AddTotblNewRegs(objtblRegister);
db.SaveChanges();
intValue = objtblRegister.NewReg_Idno;
}
}
}
catch (Exception ex)
{
}
return(intValue);
}
public IList SelectMatDetail(int matIDNO)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from GD in db.MatIssDetls
join IM in db.tblItemMastPurs on GD.Iteam_Idno equals IM.Item_Idno
join TS in db.TyreSizeMasters on GD.TyresizeIdno equals TS.TyreSize_Idno into temptyre
join TP in db.tblPositionMasts on GD.Tyreposition_Idno equals TP.Position_id into temptyreP
from TS in temptyre.DefaultIfEmpty()
from TP in temptyreP.DefaultIfEmpty()
where GD.MatIssHead_Idno == matIDNO
select new
{
GD.Item_Qty,
GD.Item_Weght,
GD.Item_Amnt,
GD.MatIssHead_Idno,
GD.Iteam_Idno,
GD.Item_Rate,
GD.Remark,
IM.Item_Name,
SerialNo = (from n in db.Stckdetls join MT in db.MatIssIdDetls on GD.MatIssHead_Idno equals MT.DocIdno where n.SerlDetl_id == MT.StckIdno && MT.MtrlDetlIdno == GD.MatIssDet_Idno select n.SerialNo).FirstOrDefault(),
SerialId = (from n in db.Stckdetls join MT in db.MatIssIdDetls on GD.MatIssHead_Idno equals MT.DocIdno where n.SerlDetl_id == MT.StckIdno && MT.MtrlDetlIdno == GD.MatIssDet_Idno select n.SerlDetl_id).FirstOrDefault(),
NSD = GD.NSD,
PSI = GD.PSI,
TType = GD.TType,
RSerial_No = GD.RSerial_No,
RSerial_Idno = GD.RSerial_Idno,
RNSD = GD.RNSD,
RPSI = GD.RPSI,
RTType = GD.RTType,
PrevAlignDate = GD.Prev_AlignDate,
Align = GD.Align,
AlignDate = GD.AlignDate,
RPrice = GD.RPrice,
GD.TyresizeIdno,
TS.TyreSize,
TP.Position_name, GD.Tyreposition_Idno
}).ToList();
return(lst);
}
}
public IList Search(DateTime?DtFrom, DateTime?DtTo, Int32 RcptNo, Int32 ToCity, Int32 YearIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from obj in db.tblFreightMemoes
join CM in db.tblCityMasters on obj.ToCity_Idno equals CM.City_Idno
select
new
{
obj.Rcpt_Date,
obj.Rcpt_No,
obj.ToCity_Idno,
obj.Year_Idno,
CM.City_Name,
obj.FMemo_Idno,
obj.Net_Amnt
}
).ToList();
if (DtFrom != null)
{
lst = (from l in lst where l.Rcpt_Date >= DtFrom select l).ToList();
}
if (DtTo != null)
{
lst = (from l in lst where l.Rcpt_Date <= DtTo select l).ToList();
}
if (ToCity > 0)
{
lst = (from l in lst where l.ToCity_Idno == ToCity select l).ToList();
}
if (RcptNo > 0)
{
lst = (from l in lst where l.Rcpt_No == RcptNo select l).ToList();
}
if (YearIdno > 0)
{
lst = (from l in lst where l.Year_Idno == YearIdno select l).ToList();
}
return(lst);
}
}
/// <summary>
/// Insert records in ItemMast
/// </summary>
/// <param name="strUOMName"></param>
/// <param name="strItemDesc"></param>
/// <param name="bStatus"></param>
/// <returns></returns>
public Int64 Insert(tblFreightMemo obj)
{
Int64 intValue = 0;
try
{
tblFreightMemo CHead = new tblFreightMemo();
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.tblFreightMemoes.AddObject(obj);
db.SaveChanges();
intValue = obj.FMemo_Idno;
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public Int32 UpdateStatus(Int32 Emp_ID, bool bStatus)
{
Int32 intValue = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblEmpSalary objSal = (from mast in db.tblEmpSalaries
where mast.EmpSal_ID == Emp_ID
select mast).FirstOrDefault();
if (objSal != null)
{
objSal.EmpSal_Status = bStatus;
db.SaveChanges();
intValue = Emp_ID;
}
}
return(intValue);
}
public int Delete(int LaneId)
{
int Value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
LaneMaster tbl = db.LaneMasters.Where(t => t.Lane_Idno == LaneId).FirstOrDefault();
db.LaneMasters.DeleteObject(tbl);
db.SaveChanges();
Value = 1;
}
}
catch (Exception ex)
{
Value = 0;
}
return(Value);
}
public ItemDetailForGrid GetItemByItemId(Int64 ItemId)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from item in db.ItemMasts
join uom in db.UOMMasts on item.Unit_Idno equals uom.UOM_Idno
where item.Item_Idno == ItemId
select new { item.Item_Name, item.Item_Idno, Uom = uom.UOM_Name, item.Unit_Idno }
).FirstOrDefault();
ItemDetailForGrid idg = new ItemDetailForGrid();
if (lst != null)
{
idg.ItemId = lst.Item_Idno;
idg.ItemName = lst.Item_Name;
idg.Uom = lst.Uom;
idg.UomId = Convert.ToInt64(lst.Unit_Idno);
}
return(idg);
}
}
public Int64 UpdateLogDetails(Int64 LogId, bool LoginStatus)
{
Int64 value = 0;
Int32 intCompIdno = 1;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblLogDetail objtblLogDetail = (from mast in db.tblLogDetails
where mast.Id == LogId
select mast).FirstOrDefault();
if (objtblLogDetail != null)
{
objtblLogDetail.Logout_DateTime = System.DateTime.Now;
objtblLogDetail.Login_Status = LoginStatus;
db.SaveChanges();
value = LogId;
}
}
return(value);
}
/// <summary>
/// Fill Grid
/// </summary>
/// <returns></returns>
public IList SelectAll(string strCategoryName)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from mast in db.tblCategoryMasts
orderby mast.Category_Name ascending
select new
{
// Item_Name = loc.Item_Name,
Cat_Name = mast.Category_Name,
Cat_Idno = mast.Category_Idno,
Status = mast.Status
}).ToList();
if (strCategoryName != "")
{
lst = (from I in lst where I.Cat_Name.ToLower().Contains(strCategoryName.ToLower()) select I).ToList();
}
return(lst);
}
}
public IList Select_ClaimDetl(Int64 ClaimHead_Idno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var Ilst = (from TCD in db.tblClaimDetls
join SD in db.Stckdetls on TCD.StckDetl_Idno equals SD.SerlDetl_id
join CM in db.tblCityMasters on SD.Loc_Idno equals CM.City_Idno
join IM in db.tblItemMastPurs on SD.ItemIdno equals IM.Item_Idno
join TSB in db.tblSBillHeads on TCD.SBillHead_Idno equals TSB.SBillHead_Idno
join AM in db.AcntMasts on TSB.Prty_Idno equals AM.Acnt_Idno
where TCD.ClaimHead_Idno == ClaimHead_Idno
select new
{
SD.SerlDetl_id,
SD.SerialNo,
}).ToList();
return(Ilst);
}
}
public Int64 UpdateAdminApproval(Int32 InvIdno, bool AdminApproval)
{
Int64 value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblInvGenHead objTblInvHead = (from obj1 in db.tblInvGenHeads where obj1.Inv_Idno == InvIdno select obj1).FirstOrDefault();
objTblInvHead.Admin_Approval = AdminApproval;
db.SaveChanges();
value = Convert.ToInt64(objTblInvHead.Inv_Idno);
}
}
catch (Exception Ex)
{
value = 0;
}
return(value);
}
public IList SelectForSearch(string strPCompName)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from CT in db.tblPCompanyMasters
//join sm in db.tblStateMasters on CT.PComp_Idno equals sm.intPCompIdno
select new
{
PCompIdno = CT.PComp_Idno,
PCompName = CT.PComp_Name,
Status = CT.Status,
//StateName = sm.State_Name
}).ToList();
if (strPCompName != "")
{
lst = (from l in lst where l.PCompName.ToLower().Contains(strPCompName.ToLower()) select l).ToList();
}
return(lst);
}
}
public IList CheckItemGrpExistInGRPrep(Int64 ConSizeIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
return((from obj in db.TblGrHeads
where obj.GRContanr_Size == ConSizeIdno
select new
{
ItemGrp = obj.GRContanr_Size
}
).ToList()
.Union
(from obj1 in db.tblAdvGrOrders
where obj1.Contanr_Size == ConSizeIdno
select new
{
ItemGrp = obj1.Contanr_Size
}).ToList());
}
}
public Int64 Insert(tblRcptGoodHead rcptGoodHead, List <tblRcptGoodDetl> rcptGoodDetl)
{
Int64 RcptGoodHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblRcptGoodHead RH = db.tblRcptGoodHeads.Where(rh => rh.RcptGoodHead_No == rcptGoodHead.RcptGoodHead_No && rh.FromCity_Idno == rcptGoodHead.FromCity_Idno && rh.Year_Idno == rcptGoodHead.Year_Idno).FirstOrDefault();
if (RH != null)
{
RcptGoodHeadId = -1;
}
else
{
db.tblRcptGoodHeads.AddObject(rcptGoodHead);
db.SaveChanges();
RcptGoodHeadId = rcptGoodHead.RcptGoodHead_Idno;
if (rcptGoodDetl.Count > 0)
{
foreach (tblRcptGoodDetl rgd in rcptGoodDetl)
{
rgd.RcptGoodHead_Idno = RcptGoodHeadId;
db.tblRcptGoodDetls.AddObject(rgd);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(RcptGoodHeadId);
}
public Int64 Insert(tblChlnBookHead ChallanBookHead, List <tblChlnBookDetl> ChallanBookDetl)
{
Int64 ChallanBookHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblChlnBookHead RH = db.tblChlnBookHeads.Where(rh => rh.Chln_No == ChallanBookHead.Chln_No).FirstOrDefault();
if (RH != null)
{
ChallanBookHeadId = -1;
}
else
{
db.tblChlnBookHeads.AddObject(ChallanBookHead);
db.SaveChanges();
ChallanBookHeadId = ChallanBookHead.Chln_Idno;
if (ChallanBookDetl.Count > 0)
{
foreach (tblChlnBookDetl rgd in ChallanBookDetl)
{
rgd.ChlnBookHead_Idno = ChallanBookHeadId;
db.tblChlnBookDetls.AddObject(rgd);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(ChallanBookHeadId);
}
public Int64 Insert(tblQuatationHead QtnHead, List <tblQuatationDetl> QtnDetl)
{
Int64 QtnHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblQuatationHead QH = db.tblQuatationHeads.Where(qh => qh.QuHead_No == QtnHead.QuHead_No && qh.Year_Idno == QtnHead.Year_Idno).FirstOrDefault();
if (QH != null)
{
QtnHeadId = -1;
}
else
{
db.tblQuatationHeads.AddObject(QtnHead);
db.SaveChanges();
QtnHeadId = QtnHead.QuHead_Idno;
if (QtnDetl.Count > 0)
{
foreach (tblQuatationDetl qtd in QtnDetl)
{
qtd.QuHead_Idno = QtnHeadId;
db.tblQuatationDetls.AddObject(qtd);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(QtnHeadId);
}
public Int64 Update(DataTable ChallanBookDetl, Int32 Chlnidno)
{
Int64 ChallanBookHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
List <tblChlnBookDetl> rcptdetl = db.tblChlnBookDetls.Where(rd => rd.ChlnBookHead_Idno == Chlnidno).ToList();
//foreach (tblChlnBookDetl rgd in rcptdetl)
//{
// db.tblChlnBookDetls.DeleteObject(rgd);
// db.SaveChanges();
//}
tblChlnBookDetl obj = new tblChlnBookDetl();
foreach (DataRow rgd in ChallanBookDetl.Rows)
{
if (Convert.ToBoolean(rgd["Delivered"]) == true)
{
obj.Delivered = Convert.ToBoolean(rgd["Delivered"]);
obj.Delvry_Date = Convert.ToDateTime((rgd["Delvry_Date"]));
obj.Shrtg = Convert.ToBoolean(rgd["Shrtg"]);
obj.remark = Convert.ToString(rgd["remark"]);
db.SaveChanges();
}
}
dbTran.Commit();
}
catch
{
dbTran.Rollback();
}
}
return(ChallanBookHeadId);
}
}
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);
}
