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); }