public StickyEndsDetails SaveStickyEndDeatil(StickyEndsDetails stickyEndDetail)
{
var res = new StickyEndsDetails();
var dt = new DataTable();
try
{
dt = InsertOrUpdateStickyEndDetail("sp_insert_sticky_end", "save_sticky_end", stickyEndDetail);
res.SaveStatus = Operation.Success.ToString();
res.SIID = Convert.ToInt32(dt.Rows[0]["SIID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public JsonResult SaveStickyEndData(StickyEnds stickyEnd, StickyEndsDetails stickyEndDetail)
{
var res1 = new StickyEnds();
if (ModelState.IsValid)
{
//res1 = _repository.SaveStickyEnd(stickyEnd);
if (res1.SaveStatus == Operation.Success.ToString())
{
var res2 = new StickyEndsDetails();
stickyEndDetail.SID = res1.SID;
//res2 = _repository.SaveStickyEndDeatils(stickyEndDetail);
res1.SaveStatus = res2.SaveStatus;
}
}
else
{
res1.SaveStatus = Operation.Failed.ToString();
}
return(Json(res1, JsonRequestBehavior.AllowGet));
}
public StickyEndsDetails SaveStickyEndDeatils(StickyEndsDetails stickyEndDetail)
{
return(_service.SaveStickyEndDeatil(stickyEndDetail));
}
public DataTable InsertOrUpdateStickyEndDetail(string procedure, string callname, StickyEndsDetails stickyEndDetail)
{
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", stickyEndDetail.SIID));
cmd.Parameters.Add(new SqlParameter("@SID", stickyEndDetail.SID));
cmd.Parameters.Add(new SqlParameter("@Loom", stickyEndDetail.Loom));
cmd.Parameters.Add(new SqlParameter("@SetNo", stickyEndDetail.SetNo));
cmd.Parameters.Add(new SqlParameter("@StyleNo", stickyEndDetail.StyleNo));
cmd.Parameters.Add(new SqlParameter("@SSNo", stickyEndDetail.SSNo));
cmd.Parameters.Add(new SqlParameter("@BeamNo", stickyEndDetail.BeamNo));
cmd.Parameters.Add(new SqlParameter("@TEnds", stickyEndDetail.TEnds));
cmd.Parameters.Add(new SqlParameter("@Knott", stickyEndDetail.Knott));
cmd.Parameters.Add(new SqlParameter("@ByPass2ndDay", stickyEndDetail.ByPass2ndDay));
cmd.Parameters.Add(new SqlParameter("@Remarks", stickyEndDetail.Remarks));
cmd.Parameters.Add(new SqlParameter("@BeamLength", stickyEndDetail.BeamLength));
cmd.Parameters.Add(new SqlParameter("@ByPass1stDay", stickyEndDetail.ByPass1stDay));
cmd.Parameters.Add(new SqlParameter("@SizingD", stickyEndDetail.SizingD));
cmd.Parameters.Add(new SqlParameter("@SizingW", stickyEndDetail.SizingW));
cmd.Parameters.Add(new SqlParameter("@GConstruction", stickyEndDetail.GConstruction));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
