public ActionResult SaveInventoryGroup(InventoryGroupEntity groupEntity) { var user = (User)Session["CurrentUser"]; groupEntity.UserName = user.EMPID; groupEntity.EDate = DateTime.Now; var res = _repository.SaveGroup(groupEntity); return(Json(res, JsonRequestBehavior.AllowGet)); }
public string SaveGroup(InventoryGroupEntity groupEntity) { string rv = ""; try { Insert_Update_Group("sp_insert_AGroup", "save_group_data", groupEntity); rv = Operation.Success.ToString(); } catch (Exception ex) { rv = ex.Message; } return(rv); }
public DataTable Insert_Update_Group(string procedure, string callname, InventoryGroupEntity groupEntity) { _dbConn = new SqlConnection(_connectionString); _dbConn.Open(); _cmd = new SqlCommand(procedure, _dbConn) { CommandType = CommandType.StoredProcedure }; _cmd.Parameters.Add(new SqlParameter("@call_name", callname)); _cmd.Parameters.Add(new SqlParameter("@p_AGIG", groupEntity.AGIG)); _cmd.Parameters.Add(new SqlParameter("@p_IGCode", groupEntity.IGCode)); _cmd.Parameters.Add(new SqlParameter("@p_IGName", groupEntity.IGName)); _cmd.Parameters.Add(new SqlParameter("@p_UserName", groupEntity.UserName)); _cmd.Parameters.Add(new SqlParameter("@p_EDate", groupEntity.EDate)); _da = new SqlDataAdapter(_cmd); _dt = new DataTable(); _da.Fill(_dt); _dbConn.Close(); return(_dt); }
public string SaveGroup(InventoryGroupEntity groupEntity) { return(_dataService.SaveGroup(groupEntity)); }