public ActionResult SaveReFinishInfo(InspRefinishDetail objRe)
{
var user = (User)Session["CurrentUser"];
//objMaster.UserId = user.EMPID;
//objRec.UserName = user.EMPID;
var res = _repository.SaveReFinishInfo(objRe);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public string SaveReFinishInfo(InspRefinishDetail objRe)
{
string rv = "";
try
{
var result = Insert_Update_ReFinishInfo("sp_insert_insp_refinish_detail_info", "SAVE_INS_REFIN_DETAIL", objRe);
rv = Operation.Success.ToString();
return(result.Rows[0]["DID"].ToString());
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_ReFinishInfo(string procedure, string callname, InspRefinishDetail objRe)
{
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("@DID", objRe.DID));
cmd.Parameters.Add(new SqlParameter("@ID", objRe.ID));
cmd.Parameters.Add(new SqlParameter("@StyleCode", objRe.StyleCode));
cmd.Parameters.Add(new SqlParameter("@StyleNo", objRe.StyleNo));
cmd.Parameters.Add(new SqlParameter("@SetNo", objRe.SetNo));
cmd.Parameters.Add(new SqlParameter("@SS", objRe.SS));
cmd.Parameters.Add(new SqlParameter("@Beam", objRe.Beam));
cmd.Parameters.Add(new SqlParameter("@FCode", objRe.FCode));
cmd.Parameters.Add(new SqlParameter("@FType", objRe.FType));
cmd.Parameters.Add(new SqlParameter("@Prod", objRe.Prod));
cmd.Parameters.Add(new SqlParameter("@FinishDate", objRe.FinishDate));
cmd.Parameters.Add(new SqlParameter("@POCode", objRe.POCode));
cmd.Parameters.Add(new SqlParameter("@POName", objRe.POName));
cmd.Parameters.Add(new SqlParameter("@ChqDCode", objRe.ChqDCode));
cmd.Parameters.Add(new SqlParameter("@ChqDName", objRe.ChqDName));
cmd.Parameters.Add(new SqlParameter("@DCode", objRe.DCode));
cmd.Parameters.Add(new SqlParameter("@DName", objRe.DName));
cmd.Parameters.Add(new SqlParameter("@Remarks", objRe.Remarks));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public string SaveReFinishInfo(InspRefinishDetail objRe)
{
return(_service.SaveReFinishInfo(objRe));
}
