public ActionResult Search(string p_keysearch, int p_CurrentPage)
{
try
{
decimal _total_record = 0;
string p_to = "";
string p_from = CommonFuc.Get_From_To_Page(p_CurrentPage, ref p_to);
if (p_keysearch == "" || p_keysearch == null)
{
p_keysearch = "ALL";
}
CarriersBL _bl = new CarriersBL();
List <CarriersInfo> _lst = _bl.Search(p_keysearch, ref _total_record, p_from, p_to);
string htmlPaging = NaviCommon.CommonFuc.Get_HtmlPaging <CarriersInfo>((int)_total_record, p_CurrentPage, "nhà cung cấp");
ViewBag.Paging = htmlPaging;
ViewBag.List = _lst;
ViewBag.SumRecord = _total_record;
return(PartialView("~/Areas/ModuleBaseData/Views/Carriers/_Partial_List.cshtml"));
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(PartialView("~/Areas/ModuleBaseData/Views/Carriers/_Partial_List.cshtml"));
}
}
public ActionResult Delete(decimal id)
{
try
{
CarriersBL _bl = new CarriersBL();
decimal ck = _bl.Delete(id);
return(Json(new { success = ck }));
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(Json(new { success = "-1" }));
}
}
public ActionResult Register(CarriersInfo carriersinfo)
{
try
{
CarriersBL _bl = new CarriersBL();
carriersinfo.Created_by = "";
carriersinfo.Created_date = DateTime.Now;
decimal ck = _bl.Insert(carriersinfo);
return(Json(new { success = ck }));
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(Json(new { success = "-1" }));
}
}
public static List <CarriersInfo> Get_All_Carriers()
{
List <CarriersInfo> list = new List <CarriersInfo>();
try
{
CarriersBL _BL = new CarriersBL();
list = _BL.GetAll();
return(list);
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(new List <CarriersInfo>());
}
}
public ActionResult ViewDetail(decimal id)
{
CarriersInfo _obj = new CarriersInfo();
try
{
CarriersBL _bl = new CarriersBL();
_obj = _bl.GetbyId(id);
}
catch (Exception ex)
{
_obj = new CarriersInfo();
NaviCommon.Common.log.Error(ex.ToString());
}
ViewBag.Carriers = _obj;
return(PartialView("~/Areas/ModuleBaseData/Views/Carriers/_Partial_Detail.cshtml"));
}
public ActionResult Edit(CarriersInfo carriersinfo)
{
try
{
CarriersBL _bl = new CarriersBL();
CarriersInfo _obj = new CarriersInfo();
_obj = _bl.GetbyId(carriersinfo.Id);
carriersinfo.Created_date = _obj.Created_date;
carriersinfo.Created_by = _obj.Created_by;
decimal ck = _bl.Update(carriersinfo);
return(Json(new { success = ck }));
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(Json(new { success = "-1" }));
}
}
// GET: Carrierss
public ActionResult CarriersDisplay()
{
List <CarriersInfo> list = new List <CarriersInfo>();
try
{
CarriersBL _bl = new CarriersBL();
decimal _total_record = 0;
list = _bl.Search("ALL", ref _total_record);
string htmlPaging = NaviCommon.CommonFuc.Get_HtmlPaging <CarriersInfo>((int)_total_record, 1, "hãng tàu");
ViewBag.Paging = htmlPaging;
ViewBag.List = list;
ViewBag.SumRecord = _total_record;
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
}
return(View());
}
public Decimal Import_file_excel(HttpPostedFileBase fileImport)
{
try
{
DataSet _ds = new DataSet();
if (fileImport != null && fileImport.ContentLength > 0)
{
if (!fileImport.FileName.EndsWith(".xls") && !fileImport.FileName.EndsWith(".xlsx"))
{
return(-3);
}
else
{
Stream stream = fileImport.InputStream;
IExcelDataReader reader = null;
if (fileImport.FileName.EndsWith(".xls"))
{
reader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (fileImport.FileName.EndsWith(".xlsx"))
{
reader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
_ds = reader.AsDataSet();
reader.Close();
}
}
if (_ds != null)
{
_ds.Tables[0].Rows[0].Delete();//xóa dòng title
_ds.AcceptChanges();
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _ds.Tables[0].Rows)
{
CarriersInfo obj_info = new CarriersInfo();
obj_info.Name = dr[0] == null ? "" : dr[0].ToString();
obj_info.Code = dr[1] == null ? "" : dr[1].ToString();
obj_info.Phone = dr[2] == null ? "" : dr[2].ToString();
obj_info.Fax = dr[3] == null ? "" : dr[3].ToString();
obj_info.Email = dr[4] == null ? "" : dr[4].ToString();
obj_info.Notes = dr[5] == null ? "" : dr[5].ToString();
obj_info.Created_date = DateTime.Now;
obj_info.Created_by = "";
CarriersBL _bl = new CarriersBL();
_bl.Insert(obj_info);
}
}
else
{
return(-4);//không có dữ liệu
}
}
return(1);
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(-1);
}
}
