public LoomDownTimeDetail SaveLoomDownTimeDetail(LoomDownTimeDetail detail)
{
var res = new LoomDownTimeDetail();
var dt = new DataTable();
try
{
dt = InsertOrUpdateLoomDownTimeMaster("SP_INSERT_LOOM_DOWN_TIME_DETAIL_INFO", "SAVE_LOOM_DOWN_TIME_DETAIL", detail);
res.SaveStatus = Operation.Success.ToString();
res.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public JsonResult SaveLoomDownTimeDetail(LoomDownTimeDetail detail)
{
var res = _repository.SaveLoomDownTimeDetail(detail);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public LoomDownTimeDetail SaveLoomDownTimeDetail(LoomDownTimeDetail detail)
{
return(_service.SaveLoomDownTimeDetail(detail));
}
public DataTable InsertOrUpdateLoomDownTimeMaster(string procedure, string callname, LoomDownTimeDetail detail)
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@ID", detail.ID));
cmd.Parameters.Add(new SqlParameter("@MasterID", detail.MasterID));
cmd.Parameters.Add(new SqlParameter("@LoomID", detail.LoomID));
cmd.Parameters.Add(new SqlParameter("@ReasonID", detail.ReasonID));
cmd.Parameters.Add(new SqlParameter("@StopTime", detail.StopTime));
cmd.Parameters.Add(new SqlParameter("@RunTime", detail.RunTime));
cmd.Parameters.Add(new SqlParameter("@TotalTime", detail.TotalTime));
cmd.Parameters.Add(new SqlParameter("@Remark", detail.Remark));
cmd.Parameters.Add(new SqlParameter("@EntryBy", detail.EntryBy));
cmd.Parameters.Add(new SqlParameter("@UpdateBy", detail.UpdateBy));
cmd.Parameters.Add(new SqlParameter("@IsDeleted", detail.IsDeleted));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
