public string SaveOrder(Order Ord, string FDNAME)
{
GBCCon gbc_con = new GBCCon();
Global objGlobal = new Global();
string name = gbc_con.Database.Connection.Database;
//Get VrNo
string vrno = GenrateVrNo(FDNAME, name + ".dbo.OB", (string.IsNullOrEmpty(Ord.series) ? "GC" : Ord.series), DateTime.Now.Date, "VRID");
double amt = 0.0;
OB obj_ob = gbc_con.db_ob.SingleOrDefault(p => p.VrId == vrno);
obj_ob.FromUserId = Ord.FromUserId;
obj_ob.ToUserId = Ord.ToUserId;
obj_ob.VrDate = DateTime.Now.Date;
obj_ob.VrId = vrno;
obj_ob.VrNo = Ord.VrNo;
obj_ob.ImgName = Ord.ImgName;
obj_ob.AppType = Ord.AppType;
int i = 1;
string isWQty = "0";
try
{
ServiceReg obj = gbc_con.db_SerReg.SingleOrDefault(p => p.Pcode == Ord.ToUserId);
if (obj != null)
{
isWQty = obj.pretailordQty;
}
}
catch
{
isWQty = "0";
}
foreach (var item in Ord.oi)
{
string slno = "00" + i;
i = i + 1;
OI obj_oi = new OI();
obj_oi.Icode = item.Icode;
obj_oi.IName = item.IName;
obj_oi.MRP = item.MRP;
obj_oi.OrdQty = item.Qty;
obj_oi.FreeQty = item.Free;
obj_oi.Packing = item.Packing;
obj_oi.SlNo = slno.Substring(slno.Length - 3, 3);
if (isWQty == "1")
{
obj_oi.Rate = item.WRate;
obj_oi.Value = obj_oi.Rate * obj_oi.OrdQty;
}
else
{
obj_oi.Rate = item.Rate;
obj_oi.Value = obj_oi.Rate * obj_oi.OrdQty;
}
obj_oi.VrId = vrno;
amt = Convert.ToDouble(amt + obj_oi.Value);
gbc_con.db_oi.Add(obj_oi);
}
amt = amt + Convert.ToDouble(Ord.DelCharges);
//obj_ob.OrdAmt = amt;
obj_ob.OrdAmt = Ord.OrdAmt;
obj_ob.DelCharge = Convert.ToDouble(Ord.DelCharges);
gbc_con.SaveChanges();
return(vrno);
}
