public static DataTable Search(ReleaseNoteBusinessValueDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
public static int Create(ReleaseNoteBusinessValueDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Create"); var releaseNoteBusinessValueId = DBDML.RunScalarSQL("ReleaseNoteBusinessValue.Insert", sql, DataStoreKey); return(Convert.ToInt32(releaseNoteBusinessValueId)); }
public JsonResult IndexResult(string name, int?page, int?pageSize) { var obj = new ReleaseNoteBusinessValueDataModel(); obj.Name = name; var list = ReleaseNoteBusinessValueDataManager.GetEntitySearch(obj, SessionVariables.RequestProfile); return(Json(list, JsonRequestBehavior.AllowGet)); }
public static bool DoesExist(ReleaseNoteBusinessValueDataModel data, RequestProfile requestProfile) { var doesExistRequest = new ReleaseNoteBusinessValueDataModel(); doesExistRequest.Name = data.Name; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
public ActionResult Create(ReleaseNoteBusinessValueDataModel obj) { if (ModelState.IsValid) { ReleaseNoteBusinessValueDataManager.Create(obj, SessionVariables.RequestProfile); return(RedirectToAction("Index")); } return(View(obj)); }
public ReleaseNoteBusinessValueDataModel GetById(int id) { var obj = new ReleaseNoteBusinessValueDataModel(); obj.ReleaseNoteBusinessValueId = id; var list = ReleaseNoteBusinessValueDataManager.GetEntityDetails(obj, SessionVariables.RequestProfile); if (list == null || list.Count == 0) { return(null); } return(list[0]); }
public static void Delete(ReleaseNoteBusinessValueDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.ReleaseNoteBusinessValueDelete "; var parameters = new { AuditId = requestProfile.AuditId , ReleaseNoteBusinessValueId = data.ReleaseNoteBusinessValueId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public static string ToSQLParameter(ReleaseNoteBusinessValueDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ReleaseNoteBusinessValueDataModel.DataColumns.ReleaseNoteBusinessValueId: if (data.ReleaseNoteBusinessValueId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseNoteBusinessValueDataModel.DataColumns.ReleaseNoteBusinessValueId, data.ReleaseNoteBusinessValueId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseNoteBusinessValueDataModel.DataColumns.ReleaseNoteBusinessValueId); } break; case ReleaseNoteBusinessValueDataModel.DataColumns.DateCreated: if (data.DateCreated != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseNoteBusinessValueDataModel.DataColumns.DateCreated, data.DateCreated); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseNoteBusinessValueDataModel.DataColumns.DateCreated); } break; case ReleaseNoteBusinessValueDataModel.DataColumns.DateModified: if (data.DateModified != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseNoteBusinessValueDataModel.DataColumns.DateModified, data.DateModified); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseNoteBusinessValueDataModel.DataColumns.DateModified); } break; default: returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
static private List <ReleaseNoteBusinessValueDataModel> ToList(DataTable dt) { var list = new List <ReleaseNoteBusinessValueDataModel>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { var dataItem = new ReleaseNoteBusinessValueDataModel(); dataItem.ReleaseNoteBusinessValueId = (int?)dr[ReleaseNoteBusinessValueDataModel.DataColumns.ReleaseNoteBusinessValueId]; dataItem.DateCreated = (DateTime)dr[ReleaseNoteBusinessValueDataModel.DataColumns.DateCreated]; dataItem.DateModified = (DateTime)dr[ReleaseNoteBusinessValueDataModel.DataColumns.DateModified]; dataItem.CreatedByAuditId = (int?)dr[BaseDataModel.BaseDataColumns.CreatedByAuditId]; dataItem.ModifiedByAuditId = (int?)dr[BaseDataModel.BaseDataColumns.ModifiedByAuditId]; SetStandardInfo(dataItem, dr); list.Add(dataItem); } } return(list); }
public static List <ReleaseNoteBusinessValueDataModel> GetEntityDetails(ReleaseNoteBusinessValueDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.ReleaseNoteBusinessValueSearch "; var parameters = new { AuditId = requestProfile.AuditId , ReleaseNoteBusinessValueId = dataQuery.ReleaseNoteBusinessValueId , Name = dataQuery.Name , Description = dataQuery.Description , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo }; List <ReleaseNoteBusinessValueDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <ReleaseNoteBusinessValueDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static void Update(ReleaseNoteBusinessValueDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("ReleaseNoteBusinessValue.Update", sql, DataStoreKey); }
static public List <ReleaseNoteBusinessValueDataModel> GetEntitySearch(ReleaseNoteBusinessValueDataModel obj, RequestProfile requestProfile) { return(GetEntityDetails(obj, requestProfile, 0)); }
public static ReleaseNoteBusinessValueDataModel GetDetails(ReleaseNoteBusinessValueDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }