/// <summary> /// Hàm lưu một đối tượng cần phải thiết lập một cách hiện thị mới /// </summary> public static ConfigDisplayInfo SaveConfigDisplayInfoData(ConfigDisplayInfoModel model, out string sMessage) { sMessage = ""; var returnData = new ConfigDisplayInfo(); try { using (var db = new Ajuma_devEntities()) { var dataTable = db.ConfigDisplayInfoes.ToList(); returnData = dataTable.Where(c => c.Entity == model.Entity && c.ScreenCode == model.ScreenCode && c.UserType == model.UserType).FirstOrDefault(); if (returnData == null) { returnData = db.ConfigDisplayInfoes.Add(new ConfigDisplayInfo() { Entity = model.Entity, ScreenCode = model.ScreenCode, UserType = model.UserType }); db.SaveChanges(); } } } catch (Exception ex) { sMessage = ex.Message; } return(returnData); }
public static ConfigDisplayInfoDetail InsertOrUpdateDisplayInfoDetail(ConfigDisplayInfoDetailModel data, out string sMessage) { sMessage = ""; ConfigDisplayInfoDetail returnData = new ConfigDisplayInfoDetail(); try { using (var db = new Ajuma_devEntities()) { var ConfigDisplayInfoId = Convert.ToInt64(data.ConfigDisplayInfoId); returnData = UpdateConfigDisplayInfoDetail(db, data); if (returnData == null) { returnData = new ConfigDisplayInfoDetail() { ConfigDisplayInfoId = ConfigDisplayInfoId, fConvert = data.fConvert, Fields = data.Fields }; returnData = InsertConfigDisplayInfoDetail(db, returnData); } } } catch (Exception ex) { sMessage = ex.Message; } return(returnData); }
public static ConfigDisplayInfoDetail InsertConfigDisplayInfoDetail(Ajuma_devEntities db, ConfigDisplayInfoDetail data) { var newData = db.ConfigDisplayInfoDetails.Add(data); db.SaveChanges(); return(newData); }
public static Dictionary <string, string> GetDisplayName(ConfigDisplayInfoModel model, out string sMessage) { sMessage = ""; var result = new Dictionary <string, string>(); try { var data = GetConfigDisplayInfoData(model, out sMessage); string[] fields = { }; if (data == null) { fields = FieldDefaults; } else { var dataDetail = GetConfigDisplayInfoDetailData(data.Id, out sMessage); if (dataDetail == null) { fields = FieldDefaults; } else { fields = JsonConvert.DeserializeObject <FieldsModel>(dataDetail.Fields).fields; } } Console.OutputEncoding = Encoding.UTF8; using (var db = new Ajuma_devEntities()) { var dbSet = GetDbSetByName(db, data.Entity, out sMessage); foreach (var sItem in dbSet) { string displayName = string.Empty; foreach (var field in fields) { var propertyInfo = sItem.GetType().GetProperty(field); if (propertyInfo != null) { displayName += propertyInfo.GetValue(sItem) + " - "; } } var Id = sItem.GetType().GetProperty("Id").GetValue(sItem).ToString(); result.Add(Id, displayName); Console.WriteLine(displayName); } } } catch (Exception ex) { if (sMessage == "") { sMessage = ex.Message; } } return(result); }
public static ConfigDisplayInfoDetail UpdateConfigDisplayInfoDetail(Ajuma_devEntities db, ConfigDisplayInfoDetailModel data) { var ConfigDisplayInfoId = Convert.ToInt64(data.ConfigDisplayInfoId); var dataOld = db.ConfigDisplayInfoDetails.Where(c => c.ConfigDisplayInfoId == ConfigDisplayInfoId).FirstOrDefault(); if (dataOld != null) { dataOld.fConvert = data.fConvert; dataOld.Fields = data.Fields; } db.SaveChanges(); return(dataOld); }
public static ConfigDisplayInfoDetail GetConfigDisplayInfoDetailData(long ConfigDisplayInfoId, out string sMessage) { sMessage = ""; var returnData = new ConfigDisplayInfoDetail(); try { using (var db = new Ajuma_devEntities()) { var dataTable = db.ConfigDisplayInfoDetails.ToList(); returnData = dataTable.Where(c => c.ConfigDisplayInfoId == ConfigDisplayInfoId).FirstOrDefault(); } } catch (Exception ex) { sMessage = ex.Message; } return(returnData); }
public static DbSet GetDbSetByName(Ajuma_devEntities db, string DbSetName, out string sMessage) { sMessage = string.Empty; var type = Assembly.GetExecutingAssembly() .GetTypes() .FirstOrDefault(t => t.Name == DbSetName); var temp = Assembly.GetExecutingAssembly().GetTypes(); var test = new DisplayInfoHelper(); Type tt = test.GetType(); if (type != null) { DbSet dbSet = db.Set(type); return(dbSet); } else { sMessage = "Không có DbSet nào có tên là " + DbSetName + " trong Entities"; return(null); } }
public AjumaDataConnect(string connectionString) { sConnect = DataConnectionManager.GetDataConnectionString_With_ConnectionString(connectionString, stringMetadata); db = new Ajuma_devEntities(sConnect); }