public static void Sync(int newApplicationId, int oldApplicationId, RequestProfile requestProfile) { // get all records for old Application Id var sql = "EXEC dbo.ReleaseLogStatusSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, oldApplicationId); var oDT = new DBDataTable("ReleaseLogStatus.Search", sql, DataStoreKey); // formaulate a new request Profile which will have new Applicationid var newRequestProfile = new RequestProfile(); newRequestProfile.ApplicationId = newApplicationId; newRequestProfile.AuditId = requestProfile.AuditId; foreach (DataRow dr in oDT.DBTable.Rows) { var data = new ReleaseLogStatusDataModel(); data.ApplicationId = newApplicationId; data.Name = dr[StandardDataModel.StandardDataColumns.Name].ToString(); // check for existing record in new Application Id if (!DoesExist(data, newRequestProfile)) { data.Description = dr[StandardDataModel.StandardDataColumns.Description].ToString(); data.SortOrder = Convert.ToInt32(dr[StandardDataModel.StandardDataColumns.SortOrder]); //create in new application id Create(data, newRequestProfile); } } }
private static string Save(ReleaseLogStatusDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.ReleaseLogStatusInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.ApplicationId); break; case "Update": sql += "dbo.ReleaseLogStatusUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Name) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Description) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.SortOrder); return(sql); }
public static DataTable GetDetails(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); var table = list.ToDataTable(); return(table); }
public static DataTable DoesExist(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { var doesExistRequest = new ReleaseLogStatusDataModel(); doesExistRequest.Name = data.Name; return(Search(doesExistRequest, requestProfile)); }
static public DataSet DeleteChildren(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.ReleaseLogStatusChildrenDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId); var oDT = new DBDataSet("Delete Children", sql, DataStoreKey); return(oDT.DBDataset); }
public static bool DoesExist(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { var doesExistRequest = new ReleaseLogStatusDataModel(); doesExistRequest.Name = data.Name; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
public static void Delete(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.ReleaseLogStatusDelete "; var parameters = new { AuditId = requestProfile.AuditId , ReleaseLogStatusId = data.ReleaseLogStatusId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public static bool IsDeletable(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { var isDeletable = true; var ds = GetChildren(data, requestProfile); if (ds != null && ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { isDeletable = false; break; } } } return(isDeletable); }
public static void Sync(int newApplicationId, int oldApplicationId, RequestProfile requestProfile) { // get all records for old Application Id var sql = "EXEC dbo.ReleaseLogSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, oldApplicationId); var oDT = new DBDataTable("ReleaseLog.Search", sql, DataStoreKey); // formaulate a new request Profile which will have new Applicationid var newRequestProfile = new RequestProfile(); newRequestProfile.ApplicationId = newApplicationId; newRequestProfile.AuditId = requestProfile.AuditId; var releaseLogStatusData = new ReleaseLogStatusDataModel(); var releaseLogStatusList = ReleaseLogStatusDataManager.GetEntityDetails(releaseLogStatusData, newRequestProfile, 0); foreach (DataRow dr in oDT.DBTable.Rows) { var fcModeName = dr[ReleaseLogDataModel.DataColumns.ReleaseLogStatus].ToString(); //get new release log status id based on release log status name var newReleaseLogStatusId = releaseLogStatusList.Find(x => x.Name == fcModeName).ReleaseLogStatusId; var data = new ReleaseLogDataModel(); data.ApplicationId = newApplicationId; data.Name = dr[ReleaseLogDataModel.DataColumns.Name].ToString(); data.ReleaseLogStatusId = newReleaseLogStatusId; // check for existing record in new Application Id if (!DoesExist(data, newRequestProfile)) { data.VersionNo = dr[ReleaseLogDataModel.DataColumns.VersionNo].ToString(); data.ReleaseDate = Convert.ToDateTime(dr[ReleaseLogDataModel.DataColumns.ReleaseDate]); data.Description = dr[ReleaseLogDataModel.DataColumns.Description].ToString(); data.SortOrder = Convert.ToInt32(dr[ReleaseLogDataModel.DataColumns.SortOrder]); //create in new application id Create(data, newRequestProfile); } } }
public static List <ReleaseLogStatusDataModel> GetEntityDetails(ReleaseLogStatusDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.ReleaseLogStatusSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReleaseLogStatusId = dataQuery.ReleaseLogStatusId , Name = dataQuery.Name , ReturnAuditInfo = returnAuditInfo }; List <ReleaseLogStatusDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <ReleaseLogStatusDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static string ToSQLParameter(ReleaseLogStatusDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId: if (data.ReleaseLogStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId, data.ReleaseLogStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId); } break; default: returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static void Update(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("ReleaseLogStatus.Update", sql, DataStoreKey); }
public static ReleaseLogStatusDataModel GetDetails(ReleaseLogStatusDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }