public ActionResult AddNewDocument(IncomingCourierMasterVM master, List <IncomingCourierDetailsVM> detailRows)
{
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
List <IncomingCourierDetailsVMSave> incomingCourierDetailsList = new List <IncomingCourierDetailsVMSave>();
int parentDetailID = 0;
detailRows.Where(detail => detail.IsSubDetail == false).ToList().ForEach(element => {
IncomingCourierDetailsVMSave saveElement = element;
parentDetailID = element.DetailsID;
saveElement.DetailsID = element.DetailsID;
saveElement.MasterID = master.MasterID;
saveElement.CompanyID = master.CompanyID;
incomingCourierDetailsList.Add(saveElement);
});
detailRows.Where(detail => detail.IsSubDetail == true).ToList().ForEach(element => {
IncomingCourierDetailsVMSave saveElement = element;
saveElement.DetailsID = element.DetailsID;
saveElement.MasterID = master.MasterID;
saveElement.CompanyID = master.CompanyID;
saveElement.ParentDetailsID = parentDetailID;
incomingCourierDetailsList.Add(saveElement);
});
int masterId = trade.SaveIncomingCourierDetails(incomingCourierDetailsList);
return(Json(detailRows));
}
public IncomingCourierMasterVM GetCourierDocumentDetails(int parentDetailsID)
{
DAL.Trade trade = new DAL.Trade();
trade.TradeDBConnectionString = this.TradeDBConnectionString;
IncomingCourierMasterVM masterCourierWithDetails = trade.GetCourierDocumentDetails(parentDetailsID);
return(masterCourierWithDetails);
}
public int SaveCourierMasterAndDetails(IncomingCourierMasterVM incomingCourierMasterVM, List <IncomingCourierDetailsVM> incomingCourierDetailsVM)
{
int MasterID = SaveIncomingCourierMaster(incomingCourierMasterVM);
incomingCourierDetailsVM.ForEach(x => x.MasterID = MasterID);
DoXmlChanges(incomingCourierDetailsVM);
return(MasterID);
}
public JsonResult GetCourierDetailsRecord(string parentDetailID)
{
List <IncomingCourierDetailsVM> result = new List <IncomingCourierDetailsVM>();
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
parentDetailID = parentDetailID.IndexOf("_") > 0 ? parentDetailID.Split(new char[] { '_' }, StringSplitOptions.RemoveEmptyEntries)[1] : parentDetailID;
IncomingCourierMasterVM incomingCourierMasterVM = trade.GetCourierDocumentDetails(parentDetailID == ""? 0 : Convert.ToInt32(parentDetailID));
List <IncomingCourierDetailsVM> incomingDetails = new List <IncomingCourierDetailsVM>();
if (parentDetailID == "" || incomingCourierMasterVM.CourierDetails.Count == 0)
{
incomingCourierMasterVM.CourierDetails.AddRange(new List <IncomingCourierDetailsVM>()
{
new IncomingCourierDetailsVM()
{
DocDetail = "B/L-Bill of Leading", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "C/0-Country of origin", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "v/C-Vessel Certficate", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "P/L-Packing List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Verning List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Serail Number List", IsSubDetail = true
}
}
);
}
if (incomingCourierMasterVM != null)
{
incomingDetails = incomingCourierMasterVM.CourierDetails.ToList();
var getMainItemDetails = incomingDetails.Where(x => x.IsSubDetail == false); //&& x.SINo == masterID
incomingCourierMasterVM.CourierDetails.Clear();
foreach (var details in incomingDetails.Where(x => x.IsSubDetail == true))
{
details.ArraySubItem = CompressSubDetails(incomingDetails, details.DetailsID);
incomingCourierMasterVM.CourierDetails.Add(details);
result.Add(details);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public IncomingCourierMasterVM GetIncomingCourierandDetails(int masterID)
{
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
IncomingCourierMasterVM incomingCourierMasterVM = trade.GetCourierMasterDetails(masterID);
List <IncomingCourierDetailsVM> incomingDetails = new List <IncomingCourierDetailsVM>();
if (incomingCourierMasterVM.CourierDetails.Count == 0)
{
incomingCourierMasterVM.CourierDetails.AddRange(new List <IncomingCourierDetailsVM>()
{
new IncomingCourierDetailsVM()
{
DocDetail = "B/L-Bill of Leading", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "C/0-Country of origin", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "v/C-Vessel Certficate", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "P/L-Packing List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Verning List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Serail Number List", IsSubDetail = true
}
}
);
}
if (incomingCourierMasterVM != null)
{
incomingDetails = incomingCourierMasterVM.CourierDetails.ToList();
var getMainItemDetails = incomingDetails.Where(x => x.IsSubDetail == false);
incomingCourierMasterVM.CourierDetails.Clear();
foreach (var details in getMainItemDetails)
{
details.ArraySubItem = CompressSubDetails(incomingDetails, details.DetailsID);
incomingCourierMasterVM.CourierDetails.Add(details);
}
}
return(incomingCourierMasterVM);
}
public IncomingCourierMasterVM GetCourierDocumentDetails(int parentDetailID)
{
IncomingCourierMasterVM objIncomingCourierMaster = new IncomingCourierMasterVM();
List <IncomingCourierDetailsVM> lstIncomingCourierDetails = new List <IncomingCourierDetailsVM>();
try
{
using (SqlConnection connection = new SqlConnection(TradeDBConnectionString))
{
connection.Open();
string documentDetailsQuery = "SELECT * FROM IncomingCourierDetails WHERE ParentDetailsID=" + parentDetailID;
SqlDataAdapter documentDetailsAdapter = new SqlDataAdapter(documentDetailsQuery, connection);
DataSet incomingCourierDetails = new DataSet();
documentDetailsAdapter.Fill(incomingCourierDetails);
if (incomingCourierDetails.Tables[0].Rows.Count > 0)
{
lstIncomingCourierDetails = (from DataRow dr in incomingCourierDetails.Tables[0].Rows
select new ViewModel.IncomingCourierDetailsVM
{
CompanyID = Guid.Parse(dr["CompanyID"].ToString()),
MasterID = (int)dr["MasterID"],
DetailsID = (int)dr["DetailsID"],
DocDetail = dr["DocDetail"]?.ToString(),
RefNo = dr["RefNo"]?.ToString(),
Qty = (decimal)dr["Qty"],
Remarks = dr["Remarks"]?.ToString(),
FileName = dr["FileName"]?.ToString(),
FilePath = dr["FilePath"]?.ToString(),
ParentDetailsID = (int)dr["ParentDetailsID"],
IsSubDetail = (bool)dr["IsSubDetail"],
SINo = dr["SINo"]?.ToString(),
}).ToList();
}
if (objIncomingCourierMaster != null)
{
objIncomingCourierMaster.CourierDetails = lstIncomingCourierDetails;
}
connection.Close();
}
}
catch (Exception ex)
{
_tradeLogger.Error("Trading.DAL.Trade.LoadSheet", ex);
throw ex;
}
return(objIncomingCourierMaster);
}
public IncomingCourierMasterVM GetCourierMaster(FormCollection fc, Guid companyId)
{
IncomingCourierMasterVM incomingCourierMasterVM = new IncomingCourierMasterVM();
incomingCourierMasterVM.CompanyID = companyId;
incomingCourierMasterVM.AWBNo = (fc["AwbNo"]);
incomingCourierMasterVM.CourierCompany = Convert.ToInt32(fc["CourierCompany"]);
incomingCourierMasterVM.CourierFor = Convert.ToInt32(fc["CourierFor"]);
incomingCourierMasterVM.DocumentType = Convert.ToInt32(fc["DocumentType"]);
incomingCourierMasterVM.ReceivedFrom = Convert.ToInt32(fc["ReceivedFrom"]);
incomingCourierMasterVM.HandedOverOn = DateTime.Parse(fc["HandedOverOn"]);
incomingCourierMasterVM.ReceivedOn = DateTime.Parse(fc["ReceivedOn"]);
incomingCourierMasterVM.CreatedBy = 12;
incomingCourierMasterVM.CreationDate = DateTime.Now;
incomingCourierMasterVM.UpdatedBy = 12;
incomingCourierMasterVM.UpdatedDate = DateTime.Now;
return(incomingCourierMasterVM);
}
//public ActionResult SAUpload()
//{
// return View();
//}
public ActionResult AddNewDocument(int masterID)
{
IncomingCourierMasterVM incomingCourierMasterVM = GetIncomingCourierandDetails(masterID);
return(View(incomingCourierMasterVM));
}
