public ActionResult Create([Bind(Include = "SECCODE,SECNAME,SECNMBG,SECFLOOR,PRSYMBOL,PSLNO,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT,LAGGING_SLNO,LAGGING_HEADING")] HRP_SECTION hrp_section) { if (ModelState.IsValid) { db.HRP_SECTION.Add(hrp_section); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hrp_section)); }
public ActionResult Create([Bind(Include = "UNITCD,UNITNM,BASEFLAG,CONVUNITCD,CONVVALUE,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] MER_UNIT mer_unit) { if (ModelState.IsValid) { db.MER_UNIT.Add(mer_unit); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mer_unit)); }
public ActionResult Create([Bind(Include = "CONCD,CONNM,COUNTRY_CODE,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] CMN_COUNTRY cmn_country) { if (ModelState.IsValid) { db.CMN_COUNTRY.Add(cmn_country); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cmn_country)); }
public ActionResult Create([Bind(Include = "GAUGECD,GAUGENM,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] MER_GAUGE mer_gauge) { if (ModelState.IsValid) { db.MER_GAUGE.Add(mer_gauge); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mer_gauge)); }
public ActionResult Create([Bind(Include = "COMPCD,COMPNM,SHORTNM,COMPNMB,ADDRS1,ADDRS2,ADDRSBG1,ADDRSBG2,PHONE,MOBILNO,FAX,EMAIL,WEB,LOGO_IMAGE,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] HRP_COMPUNIT hrp_compunit) { if (ModelState.IsValid) { db.HRP_COMPUNIT.Add(hrp_compunit); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hrp_compunit)); }
public ActionResult Create([Bind(Include = "ORDCOLCD,ORDCOLNM,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] MER_ORDERCOLOR mer_ordercolor) { if (ModelState.IsValid) { db.MER_ORDERCOLOR.Add(mer_ordercolor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mer_ordercolor)); }
public ActionResult Create([Bind(Include = "YARNCD,YARNDESC,UNITCD,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] MER_YARNINFO mer_yarninfo) { if (ModelState.IsValid) { db.MER_YARNINFO.Add(mer_yarninfo); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UNITCD = new SelectList(db.MER_UNIT, "UNITCD", "UNITNM", mer_yarninfo.UNITCD); return(View(mer_yarninfo)); }
public ActionResult Create([Bind(Include = "MODCD,COMPCD,SECCODE,MODULENM,MACTYPE,GAUGECD,WORKMINTS,MACQTY,MACEFF,PERDAYMINTS,CATEGORY,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] PRP_MODULE prp_module) { if (ModelState.IsValid) { db.PRP_MODULE.Add(prp_module); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.COMPCD = new SelectList(db.HRP_COMPUNIT, "COMPCD", "COMPNM", prp_module.COMPCD); ViewBag.SECCODE = new SelectList(db.HRP_SECTION, "SECCODE", "SECNAME", prp_module.SECCODE); ViewBag.GAUGECD = new SelectList(db.MER_GAUGE, "GAUGECD", "GAUGENM", prp_module.GAUGECD); ViewBag.Category = new SelectList(unitModel.CategoryList, "Value", "Text", prp_module.CATEGORY); return(View(prp_module)); }
public ActionResult ModuleCreate(PRP_MODULE prp_module, byte COMPCD, byte SECCODE, int ModuleNm, string MACTYPE, byte GAUGECD, short WORKMINTS, short MACQTY, byte MACEFF, int PERDAYMINTS, string CATAGORY) { prp_module.COMPCD = COMPCD; prp_module.SECCODE = SECCODE; prp_module.MODULENM = ModuleNm; prp_module.MACTYPE = MACTYPE; prp_module.GAUGECD = GAUGECD; prp_module.WORKMINTS = WORKMINTS; prp_module.MACQTY = MACQTY; prp_module.MACEFF = MACEFF; prp_module.PERDAYMINTS = PERDAYMINTS; prp_module.CATEGORY = CATAGORY; prp_module.INSERTBY = 1; prp_module.INSERTDT = DateTime.Now; if (ModelState.IsValid) { int getId = db.PRP_MODULE.Select(x => x.MODCD).Max() + 1; prp_module.MODCD = getId; db.PRP_MODULE.Add(prp_module); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.COMPCD = new SelectList(db.HRP_COMPUNIT, "COMPCD", "COMPNM"); ViewBag.SECCODE = new SelectList(db.HRP_SECTION, "SECCODE", "SECNAME"); ViewBag.GAUGECD = new SelectList(db.MER_GAUGE, "GAUGECD", "GAUGENM"); return(View(prp_module)); }
public JsonResult Create_Holiday(HRP_HOLIDAY holidyinfo) { string message = ""; try { if (ModelState.IsValid) { using (ProductionPlannerEntities dc = new ProductionPlannerEntities()) { if (holidyinfo != null) { dc.HRP_HOLIDAY.Add(holidyinfo); dc.SaveChanges(); } else { message = "failed"; } } } else { message = "failed"; } } catch (Exception ex) { message = "failed" + ex.ToString(); } return(new JsonResult { Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult Create([Bind(Include = "COMPCD,COMPTYPE,COMPNM,SHORTNM,ADDRS1,ADDRS2,CONCD,POSTCODE,PHONE,FAX,EMAIL,CONPER,BHCD,STATUS,ATTN,CC,REF,TERRITORY,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] MER_COMPCODE mer_compcode) { if (ModelState.IsValid) { db.MER_COMPCODE.Add(mer_compcode); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CONCD = new SelectList(db.CMN_COUNTRY, "CONCD", "CONNM", mer_compcode.CONCD); ViewBag.BHCD = new SelectList(db.MER_COMPCODE, "COMPCD", "COMPTYPE", mer_compcode.BHCD); ViewBag.Territory = new SelectList(bdmodel.TerritoryList, "Value", "Text", mer_compcode.TERRITORY); ViewBag.Status = new SelectList(bdmodel.StatusList, "Value", "Text", mer_compcode.STATUS); ViewBag.COMPTYPE = new SelectList(bdmodel.ComTypeList, "Value", "Text", mer_compcode.COMPTYPE); return(View(mer_compcode)); }
public ActionResult Create(Order OM) { int getORDSLNO = db.MER_ORDERMAS.Select(x => x.ORDSLNO).Max(); if (db.MER_ORDERMAS.Any(x => x.ORDSLNO == getORDSLNO)) { } else { getORDSLNO += 1; MER_ORDERMAS orderMass = new MER_ORDERMAS(); orderMass.ORDSLNO = getORDSLNO; orderMass.COMPCD = OM.COMPCD; orderMass.ORDSLNO = getORDSLNO; orderMass.SKETCHNO = OM.SKETCHNO; orderMass.STYLENO = OM.STYLENO; orderMass.GAUGECD = OM.GAUGECD; orderMass.ORDTYPE = OM.ORDTYPE; orderMass.ORDMETHOD = OM.ORDMETHOD; orderMass.STATUS = OM.STATUS; orderMass.REMARKS = OM.REMARKS; orderMass.ORDFLAG = "N"; orderMass.FLAGIMG = "N"; orderMass.INSERTBY = 1; orderMass.INSERTDT = DateTime.Now; db.MER_ORDERMAS.Add(orderMass); db.SaveChanges(); } ViewBag.Guage = new SelectList(db.MER_GAUGE, "GAUGECD", "GAUGENM"); ViewBag.LC = new SelectList(db.MER_LCREGIS, "LCSLNO", "LCNO"); ViewBag.OrderColor = new SelectList(db.MER_ORDERCOLOR, "ORDCOLCD", "ORDCOLNM"); ViewBag.YarnType = new SelectList(db.MER_YARNINFO, "YARNCD", "YARNDESC"); ViewBag.Buyer = new SelectList(db.MER_COMPCODE, "COMPCD", "COMPNM"); ViewBag.Section = new SelectList(db.HRP_SECTION, "SecCode", "SecName"); ViewBag.Category = new SelectList(db.MER_ORDER_CATEGORY, "Category", "Category"); ViewBag.OrderSLNo = getORDSLNO; return(View()); }
public JsonResult EditHolidays(DateTime id, DateTime start, string htype, byte wday, string remarks, short insid) { string message = ""; try { HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id); if (hrp_holiday != null) { db.HRP_HOLIDAY.Remove(hrp_holiday); db.SaveChanges(); hrp_holiday.HOLDATE = start; hrp_holiday.HOLTYPE = htype; hrp_holiday.WORKDAY = wday; hrp_holiday.HOLREMARKS = remarks; hrp_holiday.INSERTDT = DateTime.Now; db.HRP_HOLIDAY.Add(hrp_holiday); db.SaveChanges(); } } catch (Exception ex) { message = "failed"; } return(new JsonResult { Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }