public int DeleteGR(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblAdvGrOrder qth = db.tblAdvGrOrders.Where(h => h.AdvOrderGR_Idno == HeadId).FirstOrDefault();
List <tblAdvGrOrderDetl> CD = db.tblAdvGrOrderDetls.Where(d => d.AdvOrderGRHead_Idno == HeadId).ToList();
if (qth != null)
{
SqlParameter[] objSqlPara = new SqlParameter[3];
objSqlPara[0] = new SqlParameter("@Action", "DeleteAdvBookGR");
objSqlPara[1] = new SqlParameter("@Idno", HeadId);
objSqlPara[2] = new SqlParameter("@UserIdno", UserIdno);
Int32 del = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spDeleteFunctionality", objSqlPara);
foreach (var d in CD)
{
db.tblAdvGrOrderDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblAdvGrOrders.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public Int64 InsertAdvBookGROrder(Int64 YearIdno, Int64 intLocIDno, DateTime strOrdrDate, DateTime?strOrdrRecDate, Int64 intOrderNo, String ReferNum, Int64 TruckNoIdno, Int64 intPartyIdno, Int64 intTocityIDno, Int32 intCityViaIdno, Int64 intDelPlaceIdno, String strShipmentNo, string ContainerNum, string ContainerSealNum, Int64 ContainerSize, Int64 ContainerType, String PortNum, String strRemark, Double GrossAmnt, Double RoundOff, Double NetAmnt, DataTable dtDetail, Int32 GRType, Int64 UserIdno, Int64 AgentIdno, DateTime?strBKGDateFrom, DateTime?strBKGDateTo, string ConsrName, string Container_Num2, string SealNum_2, Int32 ExpImp_id, string CharFrwder_Name)
{
Int64 intGrIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblAdvGrOrder objGRHead = db.tblAdvGrOrders.Where(rh => (rh.AdvOrder_No == intOrderNo) && (rh.Loc_Idno == intLocIDno) && (rh.YearIdno == YearIdno)).FirstOrDefault();
if (objGRHead == null)
{
objGRHead = new tblAdvGrOrder();
objGRHead.YearIdno = YearIdno;
objGRHead.Loc_Idno = intLocIDno;
objGRHead.AdvOrder_Date = strOrdrDate;
objGRHead.AdvOrderRec_Date = strOrdrRecDate;
objGRHead.AdvOrder_No = intOrderNo;
objGRHead.Ref_No = ReferNum;
objGRHead.Truck_Idno = TruckNoIdno;
objGRHead.Party_Idno = intPartyIdno;
objGRHead.Loc_To = intTocityIDno;
objGRHead.Loc_DelvPlace = intDelPlaceIdno;
objGRHead.Shipment_No = strShipmentNo;
objGRHead.Contanr_No = ContainerNum;
objGRHead.Contanr_Size = ContainerSize;
objGRHead.Contanr_Type = ContainerType;
objGRHead.Contanr_SealNo = ContainerSealNum;
objGRHead.Port_no = PortNum;
objGRHead.Remark = strRemark;
objGRHead.GRType = GRType;
objGRHead.Gross_Amnt = GrossAmnt;
objGRHead.RoundOff_Amnt = RoundOff;
objGRHead.Net_Amnt = NetAmnt;
objGRHead.Agent_Idno = AgentIdno;
objGRHead.BKGDate_From = strBKGDateFrom;
objGRHead.BKGDate_To = strBKGDateTo;
objGRHead.Cityvia_Idno = intCityViaIdno;
objGRHead.Consignor_Name = ConsrName;
objGRHead.UserIdno = UserIdno;
objGRHead.GRContanr_No2 = Container_Num2;
objGRHead.GRContanr_SealNo2 = SealNum_2;
objGRHead.ImpExp_idno = ExpImp_id;
objGRHead.ChaFrwdr_Name = CharFrwder_Name;
db.tblAdvGrOrders.AddObject(objGRHead);
db.SaveChanges();
intGrIdno = objGRHead.AdvOrderGR_Idno;
if (intGrIdno > 0)
{
foreach (DataRow row in dtDetail.Rows)
{
tblAdvGrOrderDetl objGRDetl = new tblAdvGrOrderDetl();
objGRDetl.AdvOrderGRHead_Idno = Convert.ToInt64(intGrIdno);
objGRDetl.Item_Idno = Convert.ToInt32(row["Item_Idno"]);
objGRDetl.Unit_Idno = Convert.ToInt32(row["Unit_Idno"]);
objGRDetl.RateType_Idno = Convert.ToInt32(row["Rate_TypeIdno"]);
objGRDetl.Quantity = Convert.ToInt64(row["Quantity"]);
objGRDetl.Item_Weight = Convert.ToDouble(row["Weight"]);
objGRDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objGRDetl.Item_Amount = Convert.ToDouble(row["Amount"]);
db.tblAdvGrOrderDetls.AddObject(objGRDetl);
db.SaveChanges();
}
}
}
else
{
intGrIdno = -1;
}
}
catch (Exception Ex)
{
intGrIdno = 0;
}
}
return(intGrIdno);
}
