public static void SaveList(List <UserType> list) { BLL.UserType bv = new BLL.UserType(); foreach (UserType v in list) { // try to load by primary key bv.LoadByPrimaryKey(v.ID.Value); // if the entry doesn't exist, create it if (bv.RowCount == 0) { bv.AddNew(); } // populate the contents of v on the to the database list if (v.ID.HasValue) { bv.ID = v.ID.Value; } if (v.Type != "" && v.Type != null) { bv.Type = v.Type; } //if( v.IsDeleted.HasValue ) // bv.IsDeleted = v.IsDeleted.Value; //if( v.UpdateTime.HasValue ) // bv.UpdateTime = v.UpdateTime.Value; bv.Save(); } }
public static List <UserType> ToList(BLL.UserType v) { List <UserType> list = new List <UserType>(); while (!v.EOF) { UserType t = new UserType(); if (!v.IsColumnNull("ID")) { t.ID = v.ID; } if (!v.IsColumnNull("Type")) { t.Type = v.Type; } //if(!v.IsColumnNull("IsDeleted")) // t.IsDeleted = v.IsDeleted; //if(!v.IsColumnNull("UpdateTime")) // t.UpdateTime = v.UpdateTime; list.Add(t); v.MoveNext(); } return(list); }
private BLL.UserType UserTypeDAL_BLL(DAL.UserType d) { BLL.UserType b = d.toCopy <BLL.UserType>(new BLL.UserType()); if (d != null) { b.UserTypeDetails = new ObservableCollection <BLL.UserTypeDetail>(d.UserTypeDetails.Select(x => UserTypeDetailDAL_BLL(x)).ToList()); b.Company = d.CompanyDetail.toCopy <BLL.CompanyDetail>(new BLL.CompanyDetail()); } return(b); }
private BLL.UserType UserTypeDAL_BLL(DAL.UserType d) { BLL.UserType b = d.toCopy <BLL.UserType>(new BLL.UserType()); if (d != null) { b.UserTypeDetails = new ObservableCollection <BLL.UserTypeDetail>(d.UserTypeDetails.Select(x => UserTypeDetailDAL_BLL(x)).ToList()); b.Fund = d.FundMaster.toCopy <BLL.FundMaster>(new BLL.FundMaster()); } return(b); }
public static List <int> GetDeletedIDsAfter(long LastVersion) { BLL.UserType v = new BLL.UserType(); //v.LoadDeletedIDs(LastVersion); List <int> list = new List <int>(); while (!v.EOF) { list.Add((int)v.GetColumn("ID")); v.MoveNext(); } return(list); }
public int userType_Save(BLL.UserType ut) { try { DAL.UserType d = DB.UserTypes.Where(x => x.Id == ut.Id).FirstOrDefault(); if (d == null) { var c = DB.CompanyDetails.Where(x => x.Id == ut.CompanyId).FirstOrDefault(); d = new DAL.UserType(); c.UserTypes.Add(d); ut.toCopy <DAL.UserType>(d); foreach (var utd in ut.UserTypeDetails) { d.UserTypeDetails.Add(utd.toCopy <DAL.UserTypeDetail>(new DAL.UserTypeDetail())); } DB.SaveChanges(); ut.Id = d.Id; ut.Company = c.toCopy <BLL.CompanyDetail>(new BLL.CompanyDetail()); LogDetailStore(ut, LogDetailType.INSERT); } else { ut.toCopy <DAL.UserType>(d); foreach (var utd in ut.UserTypeDetails) { DAL.UserTypeDetail dd = d.UserTypeDetails.Where(x => x.Id == utd.Id).FirstOrDefault(); if (dd == null) { dd = new DAL.UserTypeDetail(); d.UserTypeDetails.Add(dd); } utd.toCopy <DAL.UserTypeDetail>(dd); } DB.SaveChanges(); LogDetailStore(ut, LogDetailType.UPDATE); } Clients.Clients(OtherLoginClientsOnGroup).userType_Save(ut); return(ut.Id); } catch (Exception ex) { } return(0); }
public static void DeleteList(List <int> list) { BLL.UserType bv = new BLL.UserType(); foreach (int v in list) { // try to load by primary key bv.LoadByPrimaryKey(v); // if the entry doesn't exist, create it if (bv.RowCount > 0) { bv.MarkAsDeleted(); bv.Save(); } // populate the contents of v on the to the database list } }
private void onClientEvents() { BLL.NubeAccountClient.NubeAccountHub.On <BLL.UserType>("userType_Save", (rv) => { this.Dispatcher.Invoke(() => { rv.Save(true); }); }); BLL.NubeAccountClient.NubeAccountHub.On("userType_Delete", (Action <int>)((pk) => { this.Dispatcher.Invoke((Action)(() => { BLL.UserType d = new BLL.UserType(); d.Find((int)pk); d.Delete((bool)true); })); })); }
public static List <UserType> GetUpdatesAfter(long?lastVersion, DateTime?lastUpdateTime) { BLL.UserType v = new BLL.UserType(); if (lastVersion.HasValue && lastVersion.Value != 0) { v.LoadUpdatesAfter(Convert.ToInt32(lastVersion.Value)); } else if (lastUpdateTime.HasValue) { // v.LoadUpdatesAfterByTime(lastUpdateTime.Value); } else { v.LoadAll(); } return(ToList(v)); }
public static void DeleteList(List<int> list) { BLL.UserType bv = new BLL.UserType(); foreach (int v in list) { // try to load by primary key bv.LoadByPrimaryKey(v); // if the entry doesn't exist, create it if (bv.RowCount > 0) { bv.MarkAsDeleted(); bv.Save(); } // populate the contents of v on the to the database list } }
public static List <UserType> GetAll() { BLL.UserType v = new BLL.UserType(); v.LoadAll(); return(ToList(v)); }
public static List<UserType> GetAll() { BLL.UserType v = new BLL.UserType(); v.LoadAll(); return ToList(v); }
public static void SaveList(List<UserType> list) { BLL.UserType bv = new BLL.UserType(); foreach (UserType v in list) { // try to load by primary key bv.LoadByPrimaryKey(v.ID.Value); // if the entry doesn't exist, create it if (bv.RowCount == 0) { bv.AddNew(); } // populate the contents of v on the to the database list if( v.ID.HasValue ) bv.ID = v.ID.Value; if( v.Type != "" && v.Type != null ) bv.Type = v.Type; //if( v.IsDeleted.HasValue ) // bv.IsDeleted = v.IsDeleted.Value; //if( v.UpdateTime.HasValue ) // bv.UpdateTime = v.UpdateTime.Value; bv.Save(); } }
public static List<UserType> GetUpdatesAfter(long? lastVersion,DateTime? lastUpdateTime) { BLL.UserType v = new BLL.UserType(); if(lastVersion.HasValue && lastVersion.Value != 0) { v.LoadUpdatesAfter( Convert.ToInt32(lastVersion.Value) ); }else if(lastUpdateTime.HasValue) { // v.LoadUpdatesAfterByTime(lastUpdateTime.Value); }else { v.LoadAll(); } return ToList(v); }
public static List<int> GetDeletedIDsAfter(long LastVersion) { BLL.UserType v = new BLL.UserType(); //v.LoadDeletedIDs(LastVersion); List<int> list = new List<int>(); while (!v.EOF) { list.Add((int)v.GetColumn("ID")); v.MoveNext(); } return list; }
private void OnUserTypeBindingSourceCurrentItemChanged(object sender, System.EventArgs e) { _currentUserType = uxUserTypeBindingSource.Current as BLL.UserType; if (_currentUserType != null) { _currentUserType.Validate(); } //_UserType.Validate(); OnCurrentEntityChanged(); }