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
});
}