public ActionResult SaveDetailInfo(InspFlagginDetail obj)
{
var user = (User)Session["CurrentUser"];
//objMaster.UserId = user.EMPID;
obj.UserName = user.EMPID;
var res = _repository.SaveDetailInfo(obj);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public string SaveDetailInfo(InspFlagginDetail obj)
{
string rv = "";
try
{
var result = Insert_Update_DetailInfo("sp_insert_insp_flaggin_Detail_info", "SAVE_DETAIL", obj);
rv = Operation.Success.ToString();
return(result.Rows[0]["IID"].ToString());
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_DetailInfo(string procedure, string callname, InspFlagginDetail obj)
{
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("@IID", obj.IID));
cmd.Parameters.Add(new SqlParameter("@ID", obj.ID));
cmd.Parameters.Add(new SqlParameter("@DCode", obj.DCode));
cmd.Parameters.Add(new SqlParameter("@DName", obj.DName));
cmd.Parameters.Add(new SqlParameter("@OName", obj.OName));
cmd.Parameters.Add(new SqlParameter("@OCode", obj.OCode));
cmd.Parameters.Add(new SqlParameter("@CapName", obj.CapName));
cmd.Parameters.Add(new SqlParameter("@CapCode", obj.CapCode));
cmd.Parameters.Add(new SqlParameter("@RollNo", obj.RollNo));
cmd.Parameters.Add(new SqlParameter("@StyleNo", obj.StyleNo));
cmd.Parameters.Add(new SqlParameter("@StyleCode", obj.StyleCode));
cmd.Parameters.Add(new SqlParameter("@YdsOpOBS", obj.YdsOpOBS));
cmd.Parameters.Add(new SqlParameter("@YdsReChOBS", obj.YdsReChOBS));
cmd.Parameters.Add(new SqlParameter("@DeffOpOBS", obj.DeffOpOBS));
cmd.Parameters.Add(new SqlParameter("@DeffReChOBS", obj.DeffReChOBS));
cmd.Parameters.Add(new SqlParameter("@QOpOBS", obj.QOpOBS));
cmd.Parameters.Add(new SqlParameter("@QReChOBS", obj.QReChOBS));
cmd.Parameters.Add(new SqlParameter("@PointOpOBS", obj.PointOpOBS));
cmd.Parameters.Add(new SqlParameter("@PointReChOBS", obj.PointReChOBS));
cmd.Parameters.Add(new SqlParameter("@WidthAvg", obj.WidthAvg));
cmd.Parameters.Add(new SqlParameter("@SinglePoint", obj.SinglePoint));
cmd.Parameters.Add(new SqlParameter("@Remarks", obj.Remarks));
cmd.Parameters.Add(new SqlParameter("@UserName", obj.UserName));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public string SaveDetailInfo(InspFlagginDetail obj)
{
return(_service.SaveDetailInfo(obj));
}
