public bool UpdateGrDetl(DataTable Dttemp, Int64 LocId)
{
Int64 Grdetlidno = 0;
bool value = false;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
if (Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
Grdetlidno = Convert.ToInt64(Dr["GrDetl_Idno"]);
TblGrDetl objtblGrdetl = (from obj in db.TblGrDetls
where obj.GrDetl_Idno == Grdetlidno
select obj).SingleOrDefault();
objtblGrdetl.Qty = Convert.ToInt32(Dr["Qty"]);
objtblGrdetl.Tot_Weght = Convert.ToDouble(Dr["Weight"]);
db.SaveChanges();
value = true;
}
}
}
}
catch (Exception ex)
{
value = false;
}
return(value);
}
public string InsertGR(string ChlnNo, Int32 TruckNoIdno, Int32 YearIdno, Boolean isTBBRate, Int32 itruckcitywise, DataTable dtDetail)
{
Int64 intGrIdno = 0;
string GrIdnos = "";
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
//using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
//{
try
{
TblGrHead objGRHead = null;
if (objGRHead == null)
{
foreach (DataRow row in dtDetail.Rows)
{
objGRHead = new TblGrHead();
objGRHead.Gr_Date = Convert.ToDateTime(row["GR_Date"]);
objGRHead.GR_Agnst = 1;
objGRHead.GR_Typ = Convert.ToInt32(row["Gr_TypeIdno"]);
objGRHead.DI_NO = "";
objGRHead.EGP_NO = "";
objGRHead.Gr_No = Convert.ToInt32(row["GR_No"]);
objGRHead.Lorry_Idno = TruckNoIdno;
objGRHead.Sender_Idno = Convert.ToInt64(row["SenderNameIdno"]);
objGRHead.Recivr_Idno = Convert.ToInt64(row["ReciverNameIdno"]);
objGRHead.From_City = Convert.ToInt64(row["FromCityIdno"]);
objGRHead.To_City = Convert.ToInt64(row["ToCityIdno"]);
objGRHead.DelvryPlce_Idno = 1;
objGRHead.Agnt_Idno = 0;
objGRHead.Remark = "Against Challan Crossing [ No." + ChlnNo + "]";
objGRHead.STax_Typ = 1;
objGRHead.RcptType_Idno = 1;
objGRHead.Inst_No = "";
objGRHead.Inst_Dt = Convert.ToDateTime(row["GR_Date"]);
objGRHead.Bank_Idno = 0;
objGRHead.Gross_Amnt = Convert.ToDouble(row["Amount"]);
objGRHead.AgntComisn_Amnt = 0.00;
objGRHead.TollTax_Amnt = 0.00;
objGRHead.Cartg_Amnt = 0.00;
objGRHead.Bilty_Amnt = 0.00;
objGRHead.SubTot_Amnt = 0.00;
objGRHead.Total_Amnt = Convert.ToDouble(row["Amount"]);
objGRHead.Wages_Amnt = 0.00;
objGRHead.ServTax_Amnt = 0.00;
objGRHead.Surcrg_Amnt = 0.00;
objGRHead.PF_Amnt = 0.00;
objGRHead.Net_Amnt = Convert.ToDouble(row["Amount"]);
objGRHead.RndOff_Amnt = 0.00;
objGRHead.Year_Idno = YearIdno;
objGRHead.TBB_Rate = isTBBRate;
objGRHead.cmb_type = itruckcitywise;
objGRHead.GR_Frm = "CC";
objGRHead.AgnstRcpt_No = "";
objGRHead.Chln_Idno = 0;
objGRHead.ChlnCrsng_Idno = 0;
objGRHead.Billed = false;
db.TblGrHeads.AddObject(objGRHead);
db.SaveChanges();
intGrIdno = objGRHead.GR_Idno;
if (intGrIdno > 0)
{
GrIdnos += "," + intGrIdno;
TblGrDetl objGRDetl = new TblGrDetl();
objGRDetl.GrHead_Idno = Convert.ToInt64(intGrIdno);
objGRDetl.Item_Idno = Convert.ToInt32(0);
objGRDetl.Unit_Idno = Convert.ToInt32(0);
objGRDetl.Rate_Type = Convert.ToInt32(1);
objGRDetl.Qty = Convert.ToInt64(row["Qty"]);
objGRDetl.Tot_Weght = Convert.ToDouble(row["Weight"]);
objGRDetl.Item_Rate = 0.00;
objGRDetl.Amount = Convert.ToDouble(row["Amount"]);
objGRDetl.Detail = Convert.ToString(row["Detail"]);
objGRDetl.Shrtg_Limit = Convert.ToDouble(0);
objGRDetl.Shrtg_Rate = Convert.ToDouble(0);
db.TblGrDetls.AddObject(objGRDetl);
db.SaveChanges();
}
}
// tScope.Complete();
}
else
{
GrIdnos = "";
}
}
catch (Exception Ex)
{
// tScope.Dispose();
GrIdnos = "";
}
}
//}
return(GrIdnos);
}
