public ActionResult SaveProductMaster(ProductUpdateGrid_Model objModel, int page = 1, int pageSize = 5)
{
if (!ModelState.IsValid)
{
var message = string.Join("|", ModelState.Values.SelectMany(e => e.Errors).Select(em => em.ErrorMessage));
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, message));
}
//Save
ProductManager context = new ProductManager(new DataContext());
objModel.Table.BalanceQty = objModel.Table.ProductQty - objModel.Table.FinishedQty;
var msg = context.SaveProductMaster(objModel.Table);
if (msg.Contains("exists"))
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "exists"));
}
else
{
if (objModel.StaticPageSize != 0)
{
pageSize = objModel.StaticPageSize;
}
objModel.StaticPageSize = pageSize;//objModel.StaticPageSize = 10;
BindProductGrid(objModel, page, pageSize);
return(PartialView("ProductGridList", objModel));
}
}
public ActionResult AddEditProductMaster(int ProductID = 0)
{
BuyerListManager objBuyerListManager = new BuyerListManager(new DataContext());
BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext());
ProcessListManager objProcessListManager = new ProcessListManager(new DataContext());
SupplierListManager objSupplierListManager = new SupplierListManager(new DataContext());
ProductListManager objProductListManager = new ProductListManager(new DataContext());
UnitListManager objUnitListManager = new UnitListManager(new DataContext());
SetNoteListManager objSetNoteListManager = new SetNoteListManager(new DataContext());
ProductManager context = new ProductManager(new DataContext());
ProductUpdateGrid_Model objModel = new ProductUpdateGrid_Model();
if (ProductID != 0)
{
objModel.Table = context.GetProductMasterById(ProductID);
}
else
{
objModel.Table = new ProductUpdateGrid();
}
objModel.BuyerList = Extens.ToSelectList(objBuyerListManager.GetDtBuyer(), "Buyername", "Buyername");
objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName");
objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname");
objModel.SupplierList = Extens.ToSelectList(objSupplierListManager.GetDtSupplier(), "Suppliername", "Suppliername");
objModel.ProductList = Extens.ToSelectList(objProductListManager.GetDtProduct(), "Productname", "Productname");
objModel.UnitList = Extens.ToSelectList(objUnitListManager.GetDtUnit(), "Unitname", "Unitname");
objModel.SetNoteList = Extens.ToSelectList(objSetNoteListManager.GetDtSetNote(), "Setnotename", "Setnotename");
return(PartialView("ProductMasterCRUD", objModel));
}
// GET: Product
public ActionResult Index()
{
ProductUpdateGrid_Model objModel = new ProductUpdateGrid_Model();
objModel.page = 1;
objModel.StaticPageSize = 5;
BindProductGrid(objModel, Convert.ToInt32(objModel.page), objModel.StaticPageSize);
return(View(objModel));
}
public void BindProductGrid(ProductUpdateGrid_Model objModel, int page, int pageSize)
{
ProductManager context = new ProductManager(new DataContext());
//objModel.ProductsList = context.GetProductList(objModel.OPM_ID);
var ProductsList = context.GetProductList(objModel.OPM_ID);
objModel.ProductsList = ProductsList.ToPagedList(page, pageSize).ToList();
objModel.pageList = new PagedList <ProductUpdateGrid>(ProductsList, page, pageSize);
}
public ActionResult ProductFilterSearch(int OPM_ID, int page = 1, int pageSize = 5)
{
ProductUpdateGrid_Model objModel = new ProductUpdateGrid_Model();
objModel.OPM_ID = OPM_ID;
objModel.StaticPageSize = pageSize;
BindProductGrid(objModel, page, pageSize);
return(PartialView("ProductList", objModel));
}
public ActionResult DeleteProduct(string ProductID, int OPM_ID, int page = 1, int pageSize = 5)
{
ProductManager context = new ProductManager(new DataContext());
if (!string.IsNullOrEmpty(ProductID))
{
context.DeleteProductMaster(Convert.ToInt32(ProductID));
}
ProductUpdateGrid_Model objModel = new ProductUpdateGrid_Model();
objModel.OPM_ID = OPM_ID;
BindProductGrid(objModel, page, pageSize);
return(PartialView("ProductList", objModel));
}
public void BindProductGrid(ProductUpdateGrid_Model objModel, int page, int pageSize)
{
BuyerListManager objBuyerListManager = new BuyerListManager(new DataContext());
BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext());
ProcessListManager objProcessListManager = new ProcessListManager(new DataContext());
SupplierListManager objSupplierListManager = new SupplierListManager(new DataContext());
ProductListManager objProductListManager = new ProductListManager(new DataContext());
UnitListManager objUnitListManager = new UnitListManager(new DataContext());
SetNoteListManager objSetNoteListManager = new SetNoteListManager(new DataContext());
ProductManager context = new ProductManager(new DataContext());
PlannerManager pln_context = new PlannerManager(new DataContext());
FinishingManager fis_context = new FinishingManager(new DataContext());
objModel.PlannerUpdateGridList = pln_context.GetPlannerUpdateGridList();
objModel.FinishingUpdateGridList = fis_context.GetFinishingUpdateGridList();
StringBuilder query = new StringBuilder();
var colName = common.GetColumns(CommonFunction.module.ProductMaster.ToString());
query = common.GetSqlTableQuery(CommonFunction.module.ProductMaster.ToString());
string uProcess = "";
if (Session["UserProcess"] != null)
{
uProcess = Session["UserProcess"].ToString();
}
uProcess = "'" + uProcess.Replace(",", "','") + "'";
query.Append(" AND Processname IN (" + uProcess + ") AND ");
if (objModel != null)
{
objModel.StaticPageSize = pageSize;
}
objModel.BuyerList = Extens.ToSelectList(objBuyerListManager.GetDtBuyer(), "ByrID", "Buyername");
objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberID", "BuyerOrderNumberName");
objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "ProcID", "Processname");
objModel.SupplierList = Extens.ToSelectList(objSupplierListManager.GetDtSupplier(), "SupID", "Suppliername");
objModel.ProductList = Extens.ToSelectList(objProductListManager.GetDtProduct(), "PrdID", "Productname");
objModel.UnitList = Extens.ToSelectList(objUnitListManager.GetDtUnit(), "UnitID", "Unitname");
objModel.SetNoteList = Extens.ToSelectList(objSetNoteListManager.GetDtSetNote(), "SetID", "Setnotename");
objModel.sortOrder = "desc";
objModel.fieldName = "ProductID";
context.setModel(query, objModel, colName, "ProductID", page, pageSize);
}
public ActionResult DeleteProductMaster(string ProductID, ProductUpdateGrid_Model objModel, int page = 1, int pageSize = 5)
{
ProductManager context = new ProductManager(new DataContext());
if (!string.IsNullOrEmpty(ProductID))
{
context.DeleteProductMaster(Convert.ToInt32(ProductID));
}
if (objModel.StaticPageSize != 0)
{
pageSize = objModel.StaticPageSize;
}
objModel.StaticPageSize = pageSize;//objModel.StaticPageSize = 10;
BindProductGrid(objModel, page, pageSize);
return(PartialView("ProductGridList", objModel));
}
public ActionResult ProductImport(int Import_OPM_ID, HttpPostedFileBase FileUpload)
{
HttpPostedFileBase file = Request.Files[0];
if (FileUpload != null)
{
if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = FileUpload.FileName;
if (filename.EndsWith(".xlsx"))
{
string targetpath = Server.MapPath("~/Content/Excel/");
if (!System.IO.Directory.Exists(targetpath))
{
System.IO.Directory.CreateDirectory(targetpath);
}
FileUpload.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
DataTable dtExcel = Excel_To_DataTable(pathToExcelFile, 0);
List <ProductUpdateGrid> lstProductUpdateGrid = dtExcel.DataTableToList <ProductUpdateGrid>();
SaveImportProduct(lstProductUpdateGrid, Import_OPM_ID);
ProductUpdateGrid_Model objModel = new ProductUpdateGrid_Model();
objModel.OPM_ID = Import_OPM_ID;
BindProductGrid(objModel, 1, 10);
return(PartialView("ProductList", objModel));
}
else
{
return(Json(new { msg = "Select Excel File" }));
}
}
else
{
return(Json(new { msg = "Select Excel File" }));
}
}
else
{
return(Json(new { msg = "Select Excel File" }));
}
}
public ActionResult SaveProduct(ProductUpdateGrid_Model objModel, int page = 1, int pageSize = 5)
{
if (!ModelState.IsValid)
{
var message = string.Join("|", ModelState.Values.SelectMany(e => e.Errors).Select(em => em.ErrorMessage));
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, message));
}
int OPM_ID = objModel.Table.OPM_ID != null ? objModel.Table.OPM_ID.Value : 0;
//Save
ProductManager context = new ProductManager(new DataContext());
var msg = context.SaveProductMaster(objModel.Table);
if (msg.Contains("exists"))
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "exists"));
}
else
{
objModel.OPM_ID = OPM_ID;
BindProductGrid(objModel, page, pageSize);
string vwString = HtmlHelpers.RenderViewToString(this.ControllerContext, "ProductList", objModel);
return(Json(new { OPM_ID = OPM_ID, viewData = vwString }));
}
}
public ActionResult ProductGridFilterSearch(ProductUpdateGrid_Model objModel, int page = 1, int pageSize = 5)
{
BindProductGrid(objModel, page, pageSize);
return(PartialView("ProductGridList", objModel));
}
