public int Delete(Int64 intstckDetlIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Stckdetl objMast = (from mast in db.Stckdetls
where mast.SerlDetl_id == intstckDetlIdno
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);
}
public int DeleteStcktransfer(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblStckTrans_Head qth = db.tblStckTrans_Head.Where(h => h.StckTrans_Idno == HeadId).FirstOrDefault();
List <tblStckTrans_Detl> qtd = db.tblStckTrans_Detl.Where(d => d.StckTrans_Idno == HeadId).ToList();
if (qth != null)
{
foreach (var d in qtd)
{
db.tblStckTrans_Detl.DeleteObject(d);
db.SaveChanges();
if (d.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == d.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = false;
db.SaveChanges();
}
}
db.tblStckTrans_Head.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public int Delete(Int64 HeadId)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblClaimToComHead qth = db.tblClaimToComHeads.Where(h => h.ClaimToComHead_Idno == HeadId).FirstOrDefault();
List <tblClaimToComDetl> qtd = db.tblClaimToComDetls.Where(d => d.ClaimToComHead_Idno == HeadId).ToList();
if (qth != null)
{
foreach (var d in qtd)
{
db.tblClaimToComDetls.DeleteObject(d);
Stckdetl SD = db.Stckdetls.Where(B => B.SerlDetl_id == d.StckDetl_Idno).FirstOrDefault();
SD.Claim_Status = 1;
db.SaveChanges();
}
db.tblClaimToComHeads.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public Int64 InsertPurBillStock(Int64 PBill_Idno, Int64 Item_Idno, string SerialNO, string Company, Int32 Type, string PurcFrom, Int64 LocIdno, Int32 YearIdno, Int64 tyresizeId)
{
Int64 SerialIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Stckdetl objSerial = new Stckdetl();
objSerial.SerialNo = SerialNO;
objSerial.PBillIdno = PBill_Idno;
objSerial.ItemIdno = Item_Idno;
objSerial.Item_from = "PB";
objSerial.Loc_Idno = LocIdno;
objSerial.MtrlIssue_Idno = 0;
objSerial.Is_Issued = false;
objSerial.CompName = Company;
objSerial.Type = Type;
objSerial.PurFrom = PurcFrom;
objSerial.yearId = YearIdno;
objSerial.Billed = false;
objSerial.TyresizeIdno = tyresizeId;
db.Stckdetls.AddObject(objSerial);
db.SaveChanges();
SerialIdno = objSerial.SerlDetl_id;
return(SerialIdno);
}
}
public Int64 UpdatePurBillStock(Int64 Lorry_Idno, string SerialNO, Int64 PositionIdno, string Company, Int32 Type, string purcFrom, string Kms)
{
Int64 SerialIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
List <Stckdetl> objSerial = db.Stckdetls.Where(stckd => stckd.lorry_Idno == Lorry_Idno).ToList();
if (objSerial != null)
{
foreach (var H in objSerial)
{
db.Stckdetls.DeleteObject(H);
db.SaveChanges();
}
}
Stckdetl objSerial1 = new Stckdetl();
objSerial1.SerialNo = SerialNO;
objSerial1.lorry_Idno = Lorry_Idno;
objSerial1.Tyre_PostionIdno = PositionIdno;
objSerial1.CompName = Company;
objSerial1.Type = Type;
objSerial1.PurFrom = purcFrom;
objSerial1.FittingKMs = Kms;
db.Stckdetls.AddObject(objSerial1);
db.SaveChanges();
SerialIdno = objSerial1.SerlDetl_id;
return(SerialIdno);
}
return(SerialIdno);
}
public Int64 UpdatePurBillStock(Int64 PBill_Idno, Int64 Item_Idno, string SerialNO, string Company, Int32 Type, string PurcFrom, Int64 LocIdno, Int64 StckDetlId, Int32 YearIdno, Int64 tyresizeId)
{
Int64 SerialIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Stckdetl objSerial = db.Stckdetls.Where(stckd => stckd.SerlDetl_id == StckDetlId).FirstOrDefault();
if (objSerial != null)
{
objSerial.SerialNo = SerialNO;
objSerial.PBillIdno = PBill_Idno;
objSerial.ItemIdno = Item_Idno;
objSerial.Item_from = "PB";
objSerial.Loc_Idno = LocIdno;
objSerial.MtrlIssue_Idno = 0;
objSerial.Is_Issued = false;
objSerial.CompName = Company;
objSerial.Type = Type;
objSerial.PurFrom = PurcFrom;
objSerial.yearId = YearIdno;
objSerial.TyresizeIdno = tyresizeId;
db.SaveChanges();
SerialIdno = objSerial.SerlDetl_id;
}
}
return(SerialIdno);
}
public Stckdetl SelectById(Int64 intStckdetlIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Stckdetl lst = (from tbl in db.Stckdetls where tbl.SerlDetl_id == intStckdetlIdno select tbl).FirstOrDefault();
return(lst);
}
}
public Int64 UpdateForRecvd(tblClaimToComHead obj, Int32 Head_Idno, DataTable Dttemp)
{
Int64 ClaimHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
try
{
tblClaimToComHead CHead = db.tblClaimToComHeads.Where(ch => ch.ClaimToComHead_Idno == Head_Idno).FirstOrDefault();
if (CHead != null)
{
CHead.ClaimToComRec_Date = obj.ClaimToComRec_Date;
CHead.Against = obj.Against;
db.SaveChanges();
ClaimHeadIdno = CHead.ClaimToComHead_Idno;
List <tblClaimToComDetl> ClaimDetl = db.tblClaimToComDetls.Where(cd => cd.ClaimToComHead_Idno == Head_Idno).ToList();
foreach (tblClaimToComDetl tcd in ClaimDetl)
{
for (int i = 0; i < Dttemp.Rows.Count; i++)
{
Int64 Value = Convert.ToInt64(Dttemp.Rows[i]["ClaimDetailsIdno"]);
List <tblClaimToComDetl> ClaimDetls = db.tblClaimToComDetls.Where(cd => cd.ClaimToComDetl_Idno == Value).ToList();
foreach (tblClaimToComDetl tcds in ClaimDetls)
{
tcds.Status = Convert.ToInt64(Dttemp.Rows[i]["Status"]);
tcds.New_SerialNo = Convert.ToString(Dttemp.Rows[i]["NewSerialNo"]);
tcds.Remark = Convert.ToString(Dttemp.Rows[i]["Remark"]);
db.SaveChanges();
string NewSerialNo = Dttemp.Rows[i]["NewSerialNo"].ToString();
if (string.IsNullOrEmpty(NewSerialNo) == false)
{
Stckdetl SD = db.Stckdetls.Where(d => d.SerialNo == NewSerialNo).FirstOrDefault();
tcds.NewStckDetl_Idno = SD.SerlDetl_id;
db.SaveChanges();
}
}
}
}
}
}
catch
{
ClaimHeadIdno = 0;
}
}
return(ClaimHeadIdno);
}
public Int64 Insert(tblStckTrans_Head StckHead, List <tblStckTrans_Detl> StransDetl)
{
Int64?HeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblStckTrans_Head TH = db.tblStckTrans_Head.Where(SH => SH.StckTrans_No == StckHead.StckTrans_No).FirstOrDefault();
if (TH != null)
{
HeadId = -1;
}
else
{
db.tblStckTrans_Head.AddObject(StckHead);
db.SaveChanges();
HeadId = StckHead.StckTrans_Idno;
if (StransDetl.Count > 0)
{
foreach (tblStckTrans_Detl std in StransDetl)
{
std.StckTrans_Idno = Convert.ToInt32(HeadId);
db.tblStckTrans_Detl.AddObject(std);
db.SaveChanges();
if (std.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == std.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = true;
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(Convert.ToInt64(HeadId));
}
public Int64 Insert(tblClaimToComHead obj, DataTable Dttemp)
{
Int64 ClaimToComHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblClaimToComHead Claimhead = new tblClaimToComHead();
try
{
tblClaimToComHead CH = db.tblClaimToComHeads.Where(ch => ch.ClaimToCom_No == obj.ClaimToCom_No && ch.Prefix_No == obj.Prefix_No && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (CH != null)
{
ClaimToComHeadIdno = -1;
}
else
{
db.tblClaimToComHeads.AddObject(obj);
db.SaveChanges();
ClaimToComHeadIdno = obj.ClaimToComHead_Idno;
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblClaimToComDetl objtblClaimDetl = new tblClaimToComDetl();
objtblClaimDetl.ClaimToComHead_Idno = ClaimToComHeadIdno;
objtblClaimDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]);
objtblClaimDetl.ClaimToHead_Idno = Convert.ToInt64(Dr["ClaimIdno"]);
objtblClaimDetl.Defect_Remark = Convert.ToString(Dr["DefectRemark"]);
objtblClaimDetl.VechApp_Details = Convert.ToString(Dr["VechAppDetails"]);
objtblClaimDetl.Status = Convert.ToInt64(Dr["Status"]);
objtblClaimDetl.Remark = Convert.ToString(Dr["Remark"]);
objtblClaimDetl.New_SerialNo = Convert.ToString(Dr["NewSerialNo"]);
db.tblClaimToComDetls.AddObject(objtblClaimDetl);
Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == objtblClaimDetl.StckDetl_Idno).FirstOrDefault();
SD.Claim_Status = 1;
db.SaveChanges();
}
}
}
}
catch
{
ClaimToComHeadIdno = 0;
}
return(ClaimToComHeadIdno);
}
}
public int Delete(Int64 HeadId)
{
//clsAccountPosting objclsAccountPosting = new clsAccountPosting();
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
MatIssHead qth = db.MatIssHeads.Where(h => h.MatIss_Idno == HeadId).FirstOrDefault();
List <MatIssDetl> qtd = db.MatIssDetls.Where(d => d.MatIssDet_Idno == HeadId).ToList();
if (qth != null)
{
foreach (var d in qtd)
{
if (d.Serial_Idno > 0)
{
Stckdetl Sd = db.Stckdetls.Where(r => r.SerlDetl_id == d.Serial_Idno).FirstOrDefault();
Sd.MtrlIssue_Idno = 0;
Sd.Is_Issued = false;
db.MatIssDetls.DeleteObject(d);
db.SaveChanges();
}
}
db.MatIssHeads.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
List <MatIssIdDetl> MtId = db.MatIssIdDetls.Where(d => d.DocIdno == HeadId).ToList();
if (MtId != null)
{
foreach (var d in MtId)
{
if (d.StckIdno > 0)
{
Stckdetl Sd = db.Stckdetls.Where(r => r.SerlDetl_id == d.StckIdno).FirstOrDefault();
Sd.MtrlIssue_Idno = 0;
Sd.Is_Issued = false;
db.MatIssIdDetls.DeleteObject(d);
db.SaveChanges();
}
}
}
}
return(value);
}
public Int64 Insert(string strSerialNo, Int64 intLocIdno, Int64 intItemIdNo, string strCompName, Int32 intTyreType, string strPurFrom, Int32 intYearIdno, double dblRate, Int64 intAcntIdno)
{
Int64 StckDetlIdno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
if (IsExists(strSerialNo) == false)
{
Stckdetl obj = new Stckdetl();
obj.SerialNo = strSerialNo;
obj.Loc_Idno = intLocIdno;
obj.ItemIdno = intItemIdNo;
obj.CompName = strCompName;
obj.Type = intTyreType;
obj.PurFrom = strPurFrom;
obj.yearId = intYearIdno;
obj.OpenRate = dblRate;
obj.Acnt_Idno = intAcntIdno;
obj.PBillIdno = 0;
obj.Item_from = "CP";
obj.SaleBill_Idno = 0;
obj.lorry_Idno = 0;
obj.Tyre_PostionIdno = 0;
obj.MtrlIssue_Idno = 0;
obj.OpenAmnt = 0;
obj.Is_Issued = false;
obj.Claim_Idno = 0;
obj.Billed = true;
db.AddToStckdetls(obj);
db.SaveChanges();
StckDetlIdno = obj.SerlDetl_id;
}
else
{
StckDetlIdno = -1;
}
}
}
catch
{
StckDetlIdno = 0;
}
return(StckDetlIdno);
}
public Int64 InsertPurBillStock(Int64 Lorry_Idno, string SerialNO, Int64 PositionIdno, string Company, Int32 Type, string purcFrom, string Kms)
{
Int64 SerialIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Stckdetl objSerial = new Stckdetl();
objSerial.SerialNo = SerialNO;
objSerial.lorry_Idno = Lorry_Idno;
objSerial.Tyre_PostionIdno = PositionIdno;
objSerial.CompName = Company;
objSerial.Type = Type;
objSerial.Item_from = "LM";
objSerial.PurFrom = purcFrom;
objSerial.FittingKMs = Kms;
db.Stckdetls.AddObject(objSerial);
db.SaveChanges();
SerialIdno = objSerial.SerlDetl_id;
return(SerialIdno);
}
}
public Int64 Update(Int64 intStckDetlIdno, string strSerialNo, Int64 intLocIdno, Int64 intItemIdNo, string strCompName, Int32 intTyreType, string strPurFrom, Int32 intYearIdno, double dblRate, Int64 intAcntIdno)
{
Int64 Value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
if (IsExists(strSerialNo) == false)
{
Stckdetl stckdetlValue = (from obj in db.Stckdetls
where obj.SerlDetl_id == intStckDetlIdno
select obj).SingleOrDefault();
if (stckdetlValue != null)
{
stckdetlValue.SerialNo = strSerialNo;
stckdetlValue.Loc_Idno = intLocIdno;
stckdetlValue.ItemIdno = intItemIdNo;
stckdetlValue.CompName = strCompName;
stckdetlValue.Type = intTyreType;
stckdetlValue.PurFrom = strPurFrom;
stckdetlValue.yearId = intYearIdno;
stckdetlValue.OpenRate = dblRate;
stckdetlValue.Acnt_Idno = intAcntIdno;
db.SaveChanges();
Value = stckdetlValue.SerlDetl_id;
}
}
else
{
Value = -1;
}
}
}
catch
{
}
return(Value);
}
private void Populate(Int64 StckDetlIdno)
{
VechDetlClmPrtyDAL obj = new VechDetlClmPrtyDAL();
Stckdetl lst = obj.SelectById(StckDetlIdno);
if (lst != null)
{
ddlDateRange.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.yearId)) ? "0" : Convert.ToString(lst.yearId);
ddlLocation.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.Loc_Idno)) ? "0" : Convert.ToString(lst.Loc_Idno);
ddlItemName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.ItemIdno)) ? "0" : Convert.ToString(lst.ItemIdno);
txtSerialNo.Text = string.IsNullOrEmpty(Convert.ToString(lst.SerialNo)) ? "" : Convert.ToString(lst.SerialNo);
txtCompName.Text = string.IsNullOrEmpty(Convert.ToString(lst.CompName)) ? "" : Convert.ToString(lst.CompName);
txtPurchaseFrom.Text = string.IsNullOrEmpty(Convert.ToString(lst.PurFrom)) ? "" : Convert.ToString(lst.PurFrom);
ddltype.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.Type)) ? "0" : Convert.ToString(lst.Type);
txtOpenRate.Text = string.IsNullOrEmpty(Convert.ToString(lst.OpenRate)) ? "" : Convert.ToString(lst.OpenRate);
hidstckidno.Value = StckDetlIdno.ToString();
}
else
{
this.ClearControls();
}
}
public bool CheckChasisForStck(string Serial, int VPurBillId, string SaveUpdate)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Stckdetl objStckDetl = null;
if (SaveUpdate.ToLower() == "save")
{
objStckDetl = db.Stckdetls.Where(stckd => stckd.SerialNo == Serial).FirstOrDefault();
}
else
{
objStckDetl = db.Stckdetls.Where(stckd => stckd.SerialNo == Serial && stckd.PBillIdno != VPurBillId).FirstOrDefault();
}
if (objStckDetl != null)
{
return(true);
}
else
{
return(false);
}
}
}
public Int32 Insert(DataTable DT, int yearId, int itemId, int locId, DataTable dtDelete)
{
Int32 value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Int64 locidno = Convert.ToInt64(locId);
//For Deleting ID's
for (int i = 0; i < dtDelete.Rows.Count; i++)
{
string SerialNo = Convert.ToString(dtDelete.Rows[i]["SerialNo"]);
Int64 ItemId = Convert.ToInt64(dtDelete.Rows[i]["TyreIdno"]);
List <Stckdetl> SD1 = db.Stckdetls.Where(r => r.ItemIdno == ItemId && r.Loc_Idno == locidno && r.SerialNo == SerialNo).ToList();
if (SD1 != null && SD1.Count > 0)
{
foreach (Stckdetl sd in SD1)
{
db.Stckdetls.DeleteObject(sd);
}
db.SaveChanges();
}
}
// End ID's
for (int i = 0; i < DT.Rows.Count; i++)
{
string SerialNo = Convert.ToString(DT.Rows[i]["SerialNo"]);
Int64 ItemId = Convert.ToInt64(DT.Rows[i]["TyreIdno"]);
List <Stckdetl> SD = db.Stckdetls.Where(r => r.ItemIdno == ItemId && r.Loc_Idno == locidno && r.SerialNo == SerialNo).ToList();
if (SD != null && SD.Count > 0)
{
foreach (Stckdetl sd in SD)
{
db.Stckdetls.DeleteObject(sd);
}
db.SaveChanges();
}
Int64 SerailIdno = string.IsNullOrEmpty(Convert.ToString(DT.Rows[i]["SerialIdno"])) ? 0 : Convert.ToInt64(DT.Rows[i]["SerialIdno"]);
List <Stckdetl> SD1 = db.Stckdetls.Where(r => r.ItemIdno == ItemId && r.Loc_Idno == locidno && r.SerlDetl_id == SerailIdno).ToList();
if (SD1 != null && SD1.Count > 0)
{
foreach (Stckdetl sd in SD1)
{
db.Stckdetls.DeleteObject(sd);
}
db.SaveChanges();
}
Stckdetl TblStckDetl = new Stckdetl();
TblStckDetl.yearId = yearId;
TblStckDetl.SerialNo = Convert.ToString(DT.Rows[i]["SerialNo"]);
TblStckDetl.CompName = Convert.ToString(DT.Rows[i]["CompName"]);
TblStckDetl.Type = Convert.ToInt32(DT.Rows[i]["TypeId"]);
TblStckDetl.PurFrom = Convert.ToString(DT.Rows[i]["PurFrom"]);
TblStckDetl.OpenRate = Convert.ToDouble(DT.Rows[i]["OpenRate"]);
TblStckDetl.PBillIdno = 0;
TblStckDetl.Loc_Idno = locId;
TblStckDetl.ItemIdno = Convert.ToInt32(DT.Rows[i]["TyreIdno"]);
TblStckDetl.TyresizeIdno = string.IsNullOrEmpty(Convert.ToString(DT.Rows[i]["TyreSizeIdno"])) ? 0 : Convert.ToInt32(DT.Rows[i]["TyreSizeIdno"]);
TblStckDetl.Item_from = "O";
TblStckDetl.MtrlIssue_Idno = 0;
TblStckDetl.Is_Issued = false;
TblStckDetl.Billed = false;
db.Stckdetls.AddObject(TblStckDetl);
db.SaveChanges();
}
}
value = 1;
}
catch (Exception Ex)
{
value = 0;
}
return(value);
}
public Int64 MatUpdate(Int64 intGRIdno, DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno)
{
Int64 intGrIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
TyreIssHead objGRHead = db.TyreIssHeads.Where(rh => (rh.MatIss_Idno != intGRIdno) && (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault();
if (objGRHead == null)
{
TyreIssHead objMatIssHead1 = db.TyreIssHeads.Where(rh => rh.MatIss_Idno == intGRIdno).FirstOrDefault();
if (objMatIssHead1 != null)
{
objMatIssHead1.MatIss_Date = dtMat_Date;
objMatIssHead1.MatIss_Typ = IAgainst;
objMatIssHead1.MatIss_No = intMat_No;
objMatIssHead1.Loc_Idno = intLoc_Idno;
objMatIssHead1.Truck_Idno = TruckNoIdno;
objMatIssHead1.Net_Amnt = DNetAmnt;
objMatIssHead1.Year_Idno = YearIdno;
objMatIssHead1.Issue_To = intIssueTo;
objMatIssHead1.ReMark = strRemark;
objMatIssHead1.Date_Modified = System.DateTime.Now;
objMatIssHead1.Mat_Frm = "BK";
objMatIssHead1.Driver_Idno = DriverIdno;
db.SaveChanges();
intGrIdno = objMatIssHead1.MatIss_Idno;
if (intGrIdno > 0)
{
List <TyreIssDetl> lstGrDetl = db.TyreIssDetls.Where(obj => obj.MatIssHead_Idno == intGrIdno).ToList();
if (lstGrDetl.Count > 0)
{
foreach (TyreIssDetl obj in lstGrDetl)
{
db.TyreIssDetls.DeleteObject(obj);
}
db.SaveChanges();
}
List <Stckdetl> ObjStckDetl = db.Stckdetls.Where(h => h.MtrlIssue_Idno == intGrIdno).ToList();
if (ObjStckDetl != null)
{
foreach (var b in ObjStckDetl)
{
b.MtrlIssue_Idno = 0;
b.Is_Issued = false;
db.SaveChanges();
}
}
foreach (DataRow row in dtDetail.Rows)
{
Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]);
Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault();
objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intGrIdno);
objStckDetl.Is_Issued = true;
TyreIssDetl objMatIssDetl = new TyreIssDetl();
objMatIssDetl.MatIssHead_Idno = Convert.ToInt64(intGrIdno);
objMatIssDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]);
objMatIssDetl.Item_Qty = Convert.ToInt64(row["Quantity"]);
objMatIssDetl.Item_Weght = Convert.ToDouble(row["Weight"]);
objMatIssDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objMatIssDetl.Item_Amnt = Convert.ToDouble(row["Amount"]);
objMatIssDetl.Remark = Convert.ToString(row["Detail"]);
objMatIssDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]);
db.TyreIssDetls.AddObject(objMatIssDetl);
db.SaveChanges();
}
}
}
}
else
{
intGrIdno = -1;
}
}
catch (Exception Ex)
{
intGrIdno = 0;
}
}
return(intGrIdno);
}
public Int64 Update(tblStckTrans_Head StckHead, List <tblStckTrans_Detl> StransDetl)
{
Int64 HeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblStckTrans_Head TH = db.tblStckTrans_Head.Where(SH => SH.StckTrans_No == StckHead.StckTrans_No && SH.StckTrans_Idno != StckHead.StckTrans_Idno).FirstOrDefault();
if (TH != null)
{
HeadId = -1;
}
else
{
tblStckTrans_Head Stk = db.tblStckTrans_Head.Where(sd => sd.StckTrans_Idno == StckHead.StckTrans_Idno).FirstOrDefault();
if (Stk != null)
{
//qtn.Chln_Idno = QtnHead.Chln_Idno;
Stk.Date_Modified = DateTime.Now;
Stk.StckTrans_Date = StckHead.StckTrans_Date;
Stk.IssLoc_Idno = StckHead.IssLoc_Idno;
Stk.RecLoc_Idno = StckHead.RecLoc_Idno;
Stk.User_Idno = StckHead.User_Idno;
Stk.Net_Amnt = StckHead.Net_Amnt;
Stk.Year_Idno = StckHead.Year_Idno;
Stk.Remark = StckHead.Remark;
db.SaveChanges();
HeadId = StckHead.StckTrans_Idno;
List <tblStckTrans_Detl> StkDel = db.tblStckTrans_Detl.Where(qnd => qnd.StckTrans_Idno == StckHead.StckTrans_Idno).ToList();
foreach (tblStckTrans_Detl qtd1 in StkDel)
{
db.tblStckTrans_Detl.DeleteObject(qtd1);
db.SaveChanges();
if (qtd1.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == qtd1.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = false;
db.SaveChanges();
}
}
foreach (tblStckTrans_Detl std1 in StransDetl)
{
std1.StckTrans_Idno = Convert.ToInt32(HeadId);
db.tblStckTrans_Detl.AddObject(std1);
db.SaveChanges();
if (std1.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == std1.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = true;
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(HeadId);
}
public Int64 Update(tblClaimToComHead obj, Int32 Head_Idno, DataTable Dttemp)
{
Int64 ClaimHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblClaimToComHead CH = db.tblClaimToComHeads.Where(ch => ch.ClaimToCom_No == obj.ClaimToCom_No && ch.ClaimToComHead_Idno != Head_Idno && ch.Against == obj.Against && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (CH != null)
{
ClaimHeadIdno = -1;
}
else
{
tblClaimToComHead CHead = db.tblClaimToComHeads.Where(ch => ch.ClaimToComHead_Idno == Head_Idno).FirstOrDefault();
if (CHead != null)
{
db.SaveChanges();
ClaimHeadIdno = CHead.ClaimToComHead_Idno;
List <tblClaimToComDetl> ClaimDetl = db.tblClaimToComDetls.Where(cd => cd.ClaimToHead_Idno == Head_Idno).ToList();
foreach (tblClaimToComDetl tcd in ClaimDetl)
{
db.tblClaimToComDetls.DeleteObject(tcd);
Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == tcd.StckDetl_Idno).FirstOrDefault();
SD.Claim_Status = 1;
db.SaveChanges();
}
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblClaimToComDetl objtblClaimDetl = new tblClaimToComDetl();
objtblClaimDetl.ClaimToComHead_Idno = ClaimHeadIdno;
objtblClaimDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]);
objtblClaimDetl.ClaimToHead_Idno = Convert.ToInt64(Dr["ClaimIdno"]);
objtblClaimDetl.Defect_Remark = Convert.ToString(Dr["DefectRemark"]);
objtblClaimDetl.VechApp_Details = Convert.ToString(Dr["VechAppDetails"]);
objtblClaimDetl.Status = Convert.ToInt64(Dr["Status"]);
objtblClaimDetl.Remark = Convert.ToString(Dr["Remark"]);
objtblClaimDetl.New_SerialNo = Convert.ToString(Dr["NewSerialNo"]);
db.tblClaimToComDetls.AddObject(objtblClaimDetl);
Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == objtblClaimDetl.StckDetl_Idno).FirstOrDefault();
SD.Claim_Status = 1;
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(ClaimHeadIdno);
}
public Int64 InsertMat(DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno)
{
Int64 intMateIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
TyreIssHead objMatHead = db.TyreIssHeads.Where(rh => (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault();
if (objMatHead == null)
{
objMatHead = new TyreIssHead();
objMatHead.MatIss_Date = dtMat_Date;
objMatHead.MatIss_Typ = IAgainst;
objMatHead.MatIss_No = intMat_No;
objMatHead.Loc_Idno = intLoc_Idno;
objMatHead.Truck_Idno = TruckNoIdno;
objMatHead.Net_Amnt = DNetAmnt;
objMatHead.Year_Idno = YearIdno;
objMatHead.Issue_To = intIssueTo;
objMatHead.ReMark = strRemark;
objMatHead.Date_Added = System.DateTime.Now;
objMatHead.Mat_Frm = "BK";
objMatHead.Driver_Idno = DriverIdno;
db.TyreIssHeads.AddObject(objMatHead);
db.SaveChanges();
intMateIdno = objMatHead.MatIss_Idno;
if (intMateIdno > 0)
{
foreach (DataRow row in dtDetail.Rows)
{
Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]);
Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault();
objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intMateIdno);
objStckDetl.Is_Issued = true;
TyreIssDetl objMatDetl = new TyreIssDetl();
objMatDetl.MatIssHead_Idno = Convert.ToInt64(intMateIdno);
objMatDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]);
objMatDetl.Item_Qty = Convert.ToInt64(row["Quantity"]);
objMatDetl.Item_Weght = Convert.ToDouble(row["Weight"]);
objMatDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objMatDetl.Item_Amnt = Convert.ToDouble(row["Amount"]);
objMatDetl.Remark = Convert.ToString(row["Detail"]);
objMatDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]);
db.TyreIssDetls.AddObject(objMatDetl);
db.SaveChanges();
}
// tScope.Complete();
}
}
else
{
intMateIdno = -1;
}
}
catch (Exception Ex)
{
intMateIdno = 0;
}
}
return(intMateIdno);
}
