public EXP_PLPIItemColorBale SetToModelObject(EXPPLPIItemColorBale model, int userid)
{
EXP_PLPIItemColorBale Entity = new EXP_PLPIItemColorBale();
Entity.PLPIItemColorBaleID = model.PLPIItemColorBaleID;
Entity.PLPIItemColorBaleNo = model.PLPIItemColorBaleNo;
Entity.PLPIItemColorID = model.PLPIItemColorID;
Entity.PcsInBale = model.PcsInBale;
Entity.SideInBale = model.SideInBale;
Entity.MeterPLPIBaleQty = model.MeterPLPIBaleQty;
Entity.FootPLPIBaleQty = model.FootPLPIBaleQty;
Entity.PLPIBaleNetWeight = model.PLPIBaleNetWeight;
Entity.PLPIBGrossaleWeight = model.PLPIBGrossaleWeight;
if (string.IsNullOrEmpty(model.GradeName))
{
Entity.GradeID = null;
}
else
{
Entity.GradeID = _context.Sys_Grade.Where(m => m.GradeName == model.GradeName).FirstOrDefault().GradeID;
}
//if (string.IsNullOrEmpty(model.GrossBaleWeightUnitName))
//{
// Entity.NetWeightUnit = null;
// Entity.GrossBaleWeightUnit = null;
//}
//else
//{
//Entity.NetWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == model.GrossBaleWeightUnitName).FirstOrDefault().UnitID;
//Entity.GrossBaleWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == model.GrossBaleWeightUnitName).FirstOrDefault().UnitID;
//}
Entity.NetWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == "KG").FirstOrDefault().UnitID;
Entity.GrossBaleWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == "KG").FirstOrDefault().UnitID;
Entity.Remarks = model.Remarks;
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public EXPPLPIItemColorBale SetToBussinessObject(EXP_PLPIItemColorBale Entity)
{
EXPPLPIItemColorBale Model = new EXPPLPIItemColorBale();
Model.PLPIItemColorBaleID = Entity.PLPIItemColorBaleID;
Model.PLPIItemColorBaleNo = Entity.PLPIItemColorBaleNo;
Model.PLPIItemColorID = Entity.PLPIItemColorID;
Model.GradeID = Entity.GradeID;
Model.GradeName = Entity.GradeID == null ? "" : _context.Sys_Grade.Where(m => m.GradeID == Entity.GradeID).FirstOrDefault().GradeName;
Model.PcsInBale = Entity.PcsInBale;
Model.SideInBale = Entity.SideInBale;
Model.MeterPLPIBaleQty = Entity.MeterPLPIBaleQty;
Model.FootPLPIBaleQty = Entity.FootPLPIBaleQty;
Model.PLPIBaleNetWeight = Entity.PLPIBaleNetWeight;
//Model.NetWeightUnit = Entity.NetWeightUnit;
Model.PLPIBGrossaleWeight = Entity.PLPIBGrossaleWeight;
Model.GrossBaleWeightUnit = Entity.GrossBaleWeightUnit;
Model.GrossBaleWeightUnitName = Entity.GrossBaleWeightUnit == null ? "" : _context.Sys_Unit.Where(m => m.UnitID == Entity.GrossBaleWeightUnit).FirstOrDefault().UnitName;
Model.Remarks = Entity.Remarks;
return(Model);
}
public ActionResult LoadExcelFile(string fileName)
{
//return Json(Dalobject.LoadExcelFile(fileName), JsonRequestBehavior.AllowGet);
try
{
if (string.IsNullOrEmpty(TempData["file"].ToString()))
{
return(Json("", JsonRequestBehavior.AllowGet));
}
var results = new List <EXPPLPIItemColorBale>();
string connectionString = "";
string filename = Path.Combine(Server.MapPath("~/Content"), TempData["file"].ToString());
//string filename = @"C:\Test\" + TempData["file"].ToString();
string[] d = filename.Split('.');
string fileExtension = "." + d[d.Length - 1].ToString();
if (d.Length > 0)
{
if (fileExtension == ".xls")
{
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
}
//connection String for xlsx file format.
else if (fileExtension == ".xlsx")
{
connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filename + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";
}
// connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";", filename);
}
string query = String.Format("SELECT * from [{0}$]", "Sheet1");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
DataTable myDataTable = dataSet.Tables[0];
foreach (DataRow dr in myDataTable.Rows)
{
EXPPLPIItemColorBale objColorBale = new EXPPLPIItemColorBale();
objColorBale.PLPIItemColorBaleNo = dr["BaleNo"].ToString();
objColorBale.GradeName = dr["Grade"].ToString();
if (string.IsNullOrEmpty(dr["Pcs"].ToString()))
{
objColorBale.PcsInBale = null;
}
else
{
objColorBale.PcsInBale = Convert.ToDecimal(dr["Pcs"].ToString());
}
if (string.IsNullOrEmpty(dr["Side"].ToString()))
{
objColorBale.SideInBale = null;
}
else
{
objColorBale.SideInBale = Convert.ToDecimal(dr["Side"].ToString());
}
if (string.IsNullOrEmpty(dr["SFT"].ToString()))
{
objColorBale.FootPLPIBaleQty = null;
}
else
{
objColorBale.FootPLPIBaleQty = Convert.ToDecimal(dr["SFT"].ToString());
}
if (string.IsNullOrEmpty(dr["SMT"].ToString()))
{
objColorBale.MeterPLPIBaleQty = null;
}
else
{
objColorBale.MeterPLPIBaleQty = Convert.ToDecimal(dr["SMT"].ToString());
}
if (string.IsNullOrEmpty(dr["NetWeight"].ToString()))
{
objColorBale.PLPIBaleNetWeight = null;
}
else
{
objColorBale.PLPIBaleNetWeight = Convert.ToDecimal(dr["NetWeight"].ToString());
}
if (string.IsNullOrEmpty(dr["GrossWeight"].ToString()))
{
objColorBale.PLPIBGrossaleWeight = null;
}
else
{
objColorBale.PLPIBGrossaleWeight = Convert.ToDecimal(dr["GrossWeight"].ToString());
}
//objColorBale.GrossBaleWeightUnitName = dr["WeightUnit"].ToString();
results.Add(objColorBale);
}
Remove(TempData["file"].ToString());
return(Json(results, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
_vmMsg.Msg = ex.Message.ToString();
//return _vmMsg.Msg;
}
return(Json(new { msg = _vmMsg }, JsonRequestBehavior.AllowGet));
}
