public int updateJOB(PrevJOB tbl)
{
try
{
DynamicParameters param;
var rst = 0;
string sqlcmd;
param = new DynamicParameters();
param.Add("@idDtl", tbl.idDtl);
param.Add("@idHdr", tbl.idHdr);
param.Add("@desc", tbl.JobDesc);
param.Add("@cost", tbl.Cost);
sqlcmd = "UPDATE tPMDetail SET JobDesc=@desc, Cost=@cost WHERE idDTL=@idDtl";
rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int insJOB(PrevJOB tbl)
{
try
{
DynamicParameters param;
var rst = 0;
string sqlcmd;
param = new DynamicParameters();
param.Add("@idHdr", tbl.idHdr);
param.Add("@desc", tbl.JobDesc);
param.Add("@cost", tbl.Cost);
sqlcmd = "INSERT INTO tPMDetail(idHdr, JobDesc, Cost)" +
" VALUES(@idHdr, @desc, @cost) ";
rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int updateJOB(PrevJOB tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.updateJOB(tbl));
}
public int insJOB(PrevJOB tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.insJOB(tbl));
}
