private void Populate(Int64 stckid)
{
OpenTyreDAL objMast = new OpenTyreDAL();
StckMast objStckMast = objMast.SelectById(stckid);
if (objStckMast != null)
{
var VarStckDetl = objMast.SelectDetlById(Convert.ToInt64(objStckMast.Item_Idno), Convert.ToInt64(objStckMast.Loc_Idno));
if (VarStckDetl != null && VarStckDetl.Count > 0)
{
for (int i = 0; i < VarStckDetl.Count; i++)
{
ApplicationFunction.DatatableAddRow(dtTemp, i + 1, Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Loc_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Loc_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "SerialNo")));
}
ViewState["dt"] = dtTemp;
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
ddlItemName.Enabled = false;
ddlLocation.Enabled = false;
ddlItemName.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Item_Idno"));
ddlLocation.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Loc_Idno"));
}
else
{
ddlItemName.Enabled = true;
ddlLocation.Enabled = true;
}
this.BindGridT();
}
}
objMast = null;
}
public Int32 Insert(DataTable DT, DataTable dtDelete)
{
Int32 value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
//For Deleting ID's
for (int i = 0; i < dtDelete.Rows.Count; i++)
{
Int64 ItemId = Convert.ToInt64(dtDelete.Rows[i]["ItemIdno"]);
Int64 locidno = Convert.ToInt64(dtDelete.Rows[i]["LocIdno"]);
List <StckMast> SD1 = db.StckMasts.Where(r => r.Item_Idno == ItemId && r.Loc_Idno == locidno).ToList();
if (SD1 != null && SD1.Count > 0)
{
foreach (StckMast sd in SD1)
{
db.StckMasts.DeleteObject(sd);
}
db.SaveChanges();
}
}
// End ID's
for (int i = 0; i < DT.Rows.Count; i++)
{
Int64 ItemId = Convert.ToInt64(DT.Rows[i]["ItemIdno"]);
Int64 locidno = Convert.ToInt64(DT.Rows[i]["LocIdno"]);
List <StckMast> SD = db.StckMasts.Where(r => r.Item_Idno == ItemId && r.Loc_Idno == locidno).ToList();
if (SD != null && SD.Count > 0)
{
foreach (StckMast sd in SD)
{
db.StckMasts.DeleteObject(sd);
}
db.SaveChanges();
}
StckMast Mast = new StckMast();
Mast.Item_Idno = Convert.ToInt64(DT.Rows[i]["ItemIdno"]);
Mast.Loc_Idno = Convert.ToInt64(DT.Rows[i]["LocIdno"]);
Mast.Year_Idno = Convert.ToInt64(DT.Rows[i]["YearIdno"]);
Mast.Open_Qty = Convert.ToInt64(DT.Rows[i]["Qty"]);
Mast.Open_Rate = Convert.ToDouble(DT.Rows[i]["Rate"]);
db.StckMasts.AddObject(Mast);
db.SaveChanges();
value = Convert.ToInt32(Mast.Id);
}
}
value = 1;
}
catch (Exception Ex)
{
value = 0;
}
return(value);
}
public int Delete(Int64 intStckid)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
StckMast objMast = (from mast in db.StckMasts
where mast.Id == intStckid
select mast).FirstOrDefault();
if (objMast != null)
{
Int64 ItemIdno = Convert.ToInt64(objMast.Item_Idno); Int64 Loc_idno = Convert.ToInt64(objMast.Loc_Idno);
List <Stckdetl> ObjDetl = db.Stckdetls.Where(r => r.ItemIdno == ItemIdno && r.Loc_Idno == Loc_idno && r.Item_from == "O" && r.MtrlIssue_Idno == 0 && r.Is_Issued == false).ToList();
if (ObjDetl.Count > 0)
{
foreach (Stckdetl sd in ObjDetl)
{
db.Stckdetls.DeleteObject(sd);
}
}
db.StckMasts.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);
}
