private static string Save(FieldConfigurationDisplayNameDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.FieldConfigurationDisplayNameInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.FieldConfigurationDisplayNameUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; } sql = sql + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationDisplayNameId) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.LanguageId) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.Value) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationId) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.IsDefault); return(sql); }
public static List <FieldConfigurationDisplayNameDataModel> GetEntityDetails(FieldConfigurationDisplayNameDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.FieldConfigurationDisplayNameSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , LanguageId = dataQuery.LanguageId , FieldConfigurationId = dataQuery.FieldConfigurationId , Value = dataQuery.Value , FieldConfigurationDisplayNameId = dataQuery.FieldConfigurationDisplayNameId , IsDefault = dataQuery.IsDefault }; List <FieldConfigurationDisplayNameDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <FieldConfigurationDisplayNameDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static bool DoesExist(FieldConfigurationDisplayNameDataModel data, RequestProfile requestProfile) { var doesExistRequest = new FieldConfigurationDisplayNameDataModel(); doesExistRequest.FieldConfigurationId = data.FieldConfigurationId; doesExistRequest.LanguageId = data.LanguageId; var dt = Search(doesExistRequest, requestProfile, 0); return(dt.Rows.Count > 0); }
public static DataTable Search(FieldConfigurationDisplayNameDataModel data, RequestProfile requestProfile, int applicationModeId = 0) { // formulate SQL var sql = "EXEC dbo.FieldConfigurationDisplayNameSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationMode, applicationModeId) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationDisplayNameId) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.LanguageId) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.Value) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationId) + ", " + ToSQLParameter(data, FieldConfigurationDisplayNameDataModel.DataColumns.IsDefault); var oDT = new DBDataTable("FieldConfigurationDisplayName.Search", sql, DataStoreKey); return(oDT.DBTable); }
public static void Delete(FieldConfigurationDisplayNameDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.FieldConfigurationDisplayNameDelete "; var parameters = new { AuditId = requestProfile.AuditId , FieldConfigurationDisplayNameId = data.FieldConfigurationDisplayNameId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public static void Sync(int newApplicationId, int oldApplicationId, RequestProfile requestProfile, int languageId) { // get all records for old Application Id var sql = "EXEC dbo.FieldConfigurationSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + //", @" + FieldConfigurationDataModel.DataColumns.SystemEntityTypeId + "=10400" + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, oldApplicationId); var oDT = new DBDataTable("FieldConfiguration.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 fcModeData = new FieldConfigurationModeDataModel(); var fcModeList = FieldConfigurationModeDataManager.GetEntityDetails(fcModeData, newRequestProfile, 0); foreach (DataRow dr in oDT.DBTable.Rows) { var fcModeName = dr[FieldConfigurationDataModel.DataColumns.FieldConfigurationMode].ToString(); var fcRecord = fcModeList.Find(x => x.Name == fcModeName && x.ApplicationId == newApplicationId); if (fcRecord != null) { //get new fc mode id based on fc mode name var newFCModeId = fcRecord.FieldConfigurationModeId; var data = new FieldConfigurationDataModel(); data.ApplicationId = newApplicationId; data.Name = dr[FieldConfigurationDataModel.DataColumns.Name].ToString(); data.SystemEntityTypeId = Convert.ToInt32(dr[FieldConfigurationDataModel.DataColumns.SystemEntityTypeId]); data.FieldConfigurationModeId = newFCModeId; // check for existing record in new Application Id if (!DoesExist(data, newRequestProfile)) { data.Value = dr[FieldConfigurationDataModel.DataColumns.Value].ToString(); data.Width = Convert.ToDecimal(dr[FieldConfigurationDataModel.DataColumns.Width]); data.Formatting = dr[FieldConfigurationDataModel.DataColumns.Formatting].ToString(); data.ControlType = dr[FieldConfigurationDataModel.DataColumns.ControlType].ToString(); data.HorizontalAlignment = dr[FieldConfigurationDataModel.DataColumns.HorizontalAlignment].ToString(); data.GridViewPriority = Convert.ToInt32(dr[FieldConfigurationDataModel.DataColumns.GridViewPriority]); data.DetailsViewPriority = Convert.ToInt32(dr[FieldConfigurationDataModel.DataColumns.DetailsViewPriority]); data.DisplayColumn = Convert.ToInt32(dr[FieldConfigurationDataModel.DataColumns.DisplayColumn]); data.CellCount = Convert.ToInt32(dr[FieldConfigurationDataModel.DataColumns.CellCount]); if (data.Formatting == "'") { data.Formatting = " "; } //create in new application id var newfcId = Create(data, newRequestProfile); var dataDisplayName = new FieldConfigurationDisplayNameDataModel(); dataDisplayName.FieldConfigurationId = newfcId; dataDisplayName.Value = dr[FieldConfigurationDataModel.DataColumns.FieldConfigurationDisplayName].ToString(); dataDisplayName.LanguageId = languageId; dataDisplayName.IsDefault = 1; // create display name entry according to the default display name FieldConfigurationDisplayNameDataManager.Create(dataDisplayName, newRequestProfile); } } } }
public static string ToSQLParameter(FieldConfigurationDisplayNameDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationDisplayNameId: if (data.FieldConfigurationDisplayNameId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationDisplayNameId, data.FieldConfigurationDisplayNameId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationDisplayNameId); } break; case FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationId: if (data.FieldConfigurationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationId, data.FieldConfigurationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationId); } break; case FieldConfigurationDisplayNameDataModel.DataColumns.IsDefault: if (data.IsDefault != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationDisplayNameDataModel.DataColumns.IsDefault, data.IsDefault); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationDisplayNameDataModel.DataColumns.IsDefault); } break; case FieldConfigurationDisplayNameDataModel.DataColumns.Value: if (!string.IsNullOrEmpty(data.Value)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationDisplayNameDataModel.DataColumns.Value, data.Value.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationDisplayNameDataModel.DataColumns.Value); } break; case FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfiguration: if (!string.IsNullOrEmpty(data.FieldConfiguration)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfiguration, data.FieldConfiguration.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfiguration); } break; case FieldConfigurationDisplayNameDataModel.DataColumns.Language: if (!string.IsNullOrEmpty(data.Language)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationDisplayNameDataModel.DataColumns.Language, data.Language.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationDisplayNameDataModel.DataColumns.Language); } break; case FieldConfigurationDisplayNameDataModel.DataColumns.LanguageId: if (data.LanguageId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationDisplayNameDataModel.DataColumns.LanguageId, data.LanguageId); } else { returnValue = returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationDisplayNameDataModel.DataColumns.LanguageId); } break; } return(returnValue); }
public static void Update(FieldConfigurationDisplayNameDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("FieldConfigurationDisplayName.Update", sql, DataStoreKey); }
public static FieldConfigurationDisplayNameDataModel GetDetails(FieldConfigurationDisplayNameDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }