public DataTable Insert_Update_MasterInfo(string procedure, string callname, RubberBelt objMaster) { 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("@RID", objMaster.RID)); cmd.Parameters.Add(new SqlParameter("@MCNo", objMaster.MCNo)); cmd.Parameters.Add(new SqlParameter("@SettingDate", objMaster.SettingDate.ToString("dd-MMM-yyyy"))); cmd.Parameters.Add(new SqlParameter("@BName", objMaster.BName)); cmd.Parameters.Add(new SqlParameter("@OCountry", objMaster.OCountry)); cmd.Parameters.Add(new SqlParameter("@SerialNo", objMaster.SerialNo)); cmd.Parameters.Add(new SqlParameter("@ThicknessMM", objMaster.ThicknessMM)); cmd.Parameters.Add(new SqlParameter("@Hardness", objMaster.Hardness)); cmd.Parameters.Add(new SqlParameter("@Width", objMaster.Width)); cmd.Parameters.Add(new SqlParameter("@Type", objMaster.Type)); cmd.Parameters.Add(new SqlParameter("@Remarks ", objMaster.Remarks)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public ActionResult SaveMasterInfo(RubberBelt objMaster) { var user = (User)Session["CurrentUser"]; //objMaster.UserId = user.EMPID; // objMaster.UName = user.EMPID; var res = _repository.SaveMasterInfo(objMaster); return(Json(res, JsonRequestBehavior.AllowGet)); }
public string SaveMasterInfo(RubberBelt objMaster) { string rv = ""; try { var result = Insert_Update_MasterInfo("sp_insert_finishing_rubberb_belt_master_info", "SAVE_FINISHING_RUBBER_BELT_MASTER", objMaster); rv = Operation.Success.ToString(); return(result.Rows[0]["RID"].ToString()); } catch (Exception ex) { rv = ex.Message; } return(rv); }
public string SaveMasterInfo(RubberBelt objMaster) { return(_service.SaveMasterInfo(objMaster)); }