// { // "mfgunit":1, // "Dept_Code":1, // "Att_Date":"13-04-2021", // "SrNo":1, //optional // "F_MacNo":223, // "T_MacNo":232, // "Tot_Mac":10, // "Shift":"D", // "Emp_Code":25, // "BEmp_Code":0, // "IUser":"******", // "IComp":"STECH3", // "FlorNo":"FIRST", // "PDAY":1 //} public async Task <int> TrnSave(AttTrn cFl) { if (cFl.SrNo == 0) { cFl.SrNo = FindNewSrNo(cFl.MFGUNIT.ToString(), cFl.DEPT_CODE.ToString(), cFl.Att_Date.ToString(), cFl.FlorNo, cFl.SHIFT); } DynamicParameters parameter = new DynamicParameters(); parameter.Add("@mfgunit", cFl.MFGUNIT, DbType.Int16); parameter.Add("@Dept_Code", cFl.DEPT_CODE, DbType.Int16); parameter.Add("@Att_Date", cFl.Att_Date, DbType.DateTime); parameter.Add("@SrNo", cFl.SrNo, DbType.Int16); parameter.Add("@F_MacNo", cFl.F_MacNo, DbType.Int16); parameter.Add("@T_MacNo", cFl.T_MacNo, DbType.Int16); parameter.Add("@Tot_Mac", cFl.Tot_Mac, DbType.Int16); parameter.Add("@Shift", cFl.SHIFT, DbType.String); parameter.Add("@Emp_Code", cFl.Emp_Code, DbType.Int16); parameter.Add("@BEmp_Code", cFl.BEmp_Code, DbType.Int16); parameter.Add("@IUser", cFl.IUser, DbType.String); parameter.Add("@IComp", cFl.IComp, DbType.String); parameter.Add("@FlorNo", cFl.FlorNo, DbType.String); parameter.Add("@PDAY", cFl.PDAY, DbType.Double); int x = await _dapperHelper.ExecuteAsync("[dbo].[uSp_AttTrnSave]", parameter, CommandType.StoredProcedure); return(x); }
public void AttTrnFill(AttTrn cls) { Ope.Clear(); Ope.AddParams("MFGUNIT", cls.MFGUNIT); Ope.AddParams("DEPT_CODE", cls.DEPT_CODE); Ope.AddParams("ATT_DATE", cls.Att_Date); Ope.AddParams("SHIFT", cls.SHIFT); Ope.AddParams("FLOOR", cls.FlorNo); Ope.FillDataSet(Ope.EnumServer.mServer, DS, TableName, "Api_AttTrnFill", Ope.GetParams()); }
public void AttCmbDisp(AttTrn cls) { DataSet dataSet = new DataSet(); //DynamicParameters parameter = new DynamicParameters(); Ope.Clear(); Ope.AddParams("MfgUnit", cls.MFGUNIT); Ope.AddParams("Dept_Code", cls.DEPT_CODE); Ope.AddParams("Type", cls.TYPE); //Ope.AddParams("@Att_Date", cls.Att_Date ); //Ope.AddParams("@SHIFT", cls.SHIFT ); //Ope.AddParams("@FLOOR", cls.FLOOR ); //var data = _dapperHelper.GetAll<FileTrn>("[dbo].[uSp_DeptMastFill]", parameter, CommandType.StoredProcedure); //var data = _dapperHelper.GetAll<AttTrn>("[dbo].[uSp_DeptMastFill]", parameter, CommandType.StoredProcedure); Ope.FillDataSet(Ope.EnumServer.mServer, DS, TableName, "Api_CmbFill", Ope.GetParams()); }
public async Task <IHttpActionResult> TrnSave(AttTrn fileTrn) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var x = await _eTexServices.TrnSave(fileTrn); return(Ok(x.ToString())); } catch (System.Exception ex) { return(BadRequest(ex.ToString())); } }
public IHttpActionResult AttTrnFill(int mfg, int dept, string date, string shift, string floor) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } AttTrn cls = new AttTrn(); cls.MFGUNIT = mfg; cls.DEPT_CODE = dept; cls.Att_Date = Ope.DTDBDate(date.ToString()); cls.SHIFT = shift; cls.FlorNo = floor; _eTexServices.AttTrnFill(cls); if (_eTexServices.DS == null) { return(NotFound()); } return(Ok(_eTexServices.DS)); }
public IHttpActionResult DeptDisp(string type, int mfg = 0, int dept = 0) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } AttTrn cls = new AttTrn(); cls.MFGUNIT = mfg; cls.DEPT_CODE = dept; cls.TYPE = type; //cls.Att_Date = attdate; //cls.SHIFT = shift; //cls.FLOOR = floor; _eTexServices.AttCmbDisp(cls); if (_eTexServices.DS == null) { return(NotFound()); } return(Ok(_eTexServices.DS)); }