public ActionResult SaveDetailInfo(StyleDetailsFinishingRecepi objRec)
{
var user = (User)Session["CurrentUser"];
//objMaster.UserId = user.EMPID;
// objMaster.UName = user.EMPID;
var res = _repository.SaveDetailInfo(objRec);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public string SaveDetailInfo(StyleDetailsFinishingRecepi objRec)
{
string rv = "";
try
{
var result = Insert_Update_Detail_Info("sp_insert_style_recipe_detail_info", "SAVE_DETAIL_INFO", objRec);
rv = Operation.Success.ToString();
return(result.Rows[0]["SIID"].ToString());
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_Detail_Info(string procedure, string callname, StyleDetailsFinishingRecepi objRec)
{
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("@SIID", Convert.ToInt32(objRec.SIID)));
cmd.Parameters.Add(new SqlParameter("@SID", Convert.ToInt32(objRec.SID)));
cmd.Parameters.Add(new SqlParameter("@IName", objRec.IName));
cmd.Parameters.Add(new SqlParameter("@ICode", Convert.ToInt32(objRec.ICode)));
cmd.Parameters.Add(new SqlParameter("@IPercent", objRec.IPercent));
cmd.Parameters.Add(new SqlParameter("@IGPL", objRec.IGPL));
cmd.Parameters.Add(new SqlParameter("@ILtr", objRec.ILtr));
cmd.Parameters.Add(new SqlParameter("@IVolume", objRec.IVolume));
cmd.Parameters.Add(new SqlParameter("@Remarks", objRec.Remarks));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
