// {
// "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));
}
