public ActionResult SaveFinishingDetailInfo(FinishingProductionDetail objDetail) { var user = (User)Session["CurrentUser"]; //objMaster.UserId = user.EMPID; //objDetail.UName = user.EMPID; var res = _repository.SaveDetailInfo(objDetail); return(Json(res, JsonRequestBehavior.AllowGet)); }
public DataTable Insert_Update_DetailInfo(string procedure, string callname, FinishingProductionDetail objDetail) { 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("@FPID ", objDetail.FPID)); cmd.Parameters.Add(new SqlParameter("@FID ", objDetail.FID)); cmd.Parameters.Add(new SqlParameter("@BeamNo ", objDetail.BeamNo)); cmd.Parameters.Add(new SqlParameter("@SizingNo ", objDetail.SizingNo)); cmd.Parameters.Add(new SqlParameter("@LoomNo ", objDetail.LoomNo)); cmd.Parameters.Add(new SqlParameter("@StyleCode ", objDetail.StyleCode)); cmd.Parameters.Add(new SqlParameter("@Weave ", objDetail.Weave)); cmd.Parameters.Add(new SqlParameter("@Color ", objDetail.Color)); cmd.Parameters.Add(new SqlParameter("@Weight ", objDetail.Weight)); cmd.Parameters.Add(new SqlParameter("@Width ", objDetail.Width)); cmd.Parameters.Add(new SqlParameter("@BeamLenght ", objDetail.BeamLenght)); cmd.Parameters.Add(new SqlParameter("@FabShrinkage ", objDetail.FabShrinkage)); cmd.Parameters.Add(new SqlParameter("@BeforeFin ", objDetail.BeforeFin)); cmd.Parameters.Add(new SqlParameter("@AfterFin ", objDetail.AfterFin)); cmd.Parameters.Add(new SqlParameter("@AfterFinShrinkage ", objDetail.AfterFinShrinkag)); cmd.Parameters.Add(new SqlParameter("@TotalProd ", objDetail.TotalProd)); cmd.Parameters.Add(new SqlParameter("@TotalPoint ", objDetail.TotalPoint)); cmd.Parameters.Add(new SqlParameter("@Remnarks ", objDetail.Remnarks)); cmd.Parameters.Add(new SqlParameter("@SetNo ", objDetail.SetNo)); cmd.Parameters.Add(new SqlParameter("@TrollyNo ", objDetail.TrollyNo)); cmd.Parameters.Add(new SqlParameter("@BeforeWidth ", objDetail.BeforeWidth)); cmd.Parameters.Add(new SqlParameter("@AfterWidth ", objDetail.AfterWidth)); cmd.Parameters.Add(new SqlParameter("@Skew ", objDetail.Skew)); cmd.Parameters.Add(new SqlParameter("@Buyer ", objDetail.Buyer)); cmd.Parameters.Add(new SqlParameter("@OCode ", objDetail.OCode)); cmd.Parameters.Add(new SqlParameter("@OName ", objDetail.OName)); cmd.Parameters.Add(new SqlParameter("@OpCode ", objDetail.OpCode)); cmd.Parameters.Add(new SqlParameter("@OpName ", objDetail.OpName)); cmd.Parameters.Add(new SqlParameter("@ShiftCode ", objDetail.ShiftCode)); cmd.Parameters.Add(new SqlParameter("@Conostration ", objDetail.Conostration)); cmd.Parameters.Add(new SqlParameter("@FConstraction ", objDetail.FConstraction)); cmd.Parameters.Add(new SqlParameter("@UserName ", objDetail.UserName)); cmd.Parameters.Add(new SqlParameter("@MCRunTime ", objDetail.MCRunTime)); cmd.Parameters.Add(new SqlParameter("@MCOffTime ", objDetail.MCOffTime)); cmd.Parameters.Add(new SqlParameter("@Temparature ", objDetail.Temparature)); cmd.Parameters.Add(new SqlParameter("@RPM ", objDetail.RPM)); cmd.Parameters.Add(new SqlParameter("@ProdCode ", objDetail.ProdCode)); cmd.Parameters.Add(new SqlParameter("@ProdType ", objDetail.ProdType)); cmd.Parameters.Add(new SqlParameter("@FinishRoute ", objDetail.FinishRoute)); cmd.Parameters.Add(new SqlParameter("@UCode ", objDetail.UCode)); cmd.Parameters.Add(new SqlParameter("@Moisture ", objDetail.Moisture)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public string SaveDetailInfo(FinishingProductionDetail objDetail) { string rv = ""; try { var result = Insert_Update_DetailInfo("sp_insert_finishing_Production_detail_info", "SAVE_FINISHING_PRODUCTION_DETAIL", objDetail); rv = Operation.Success.ToString(); return(result.Rows[0]["FPID"].ToString()); } catch (Exception ex) { rv = ex.Message; } return(rv); }
public string SaveDetailInfo(FinishingProductionDetail objDetail) { return(_service.SaveDetailInfo(objDetail)); }