public static List <Woreda> ToList(BLL.Woreda v) { List <Woreda> list = new List <Woreda>(); while (!v.EOF) { Woreda t = new Woreda(); if (!v.IsColumnNull("ID")) { t.ID = v.ID; } if (!v.IsColumnNull("WoredaName")) { t.WoredaName = v.WoredaName; } if (!v.IsColumnNull("ZoneID")) { t.ZoneID = v.ZoneID; } if (!v.IsColumnNull("WoredaCode")) { t.WoredaCode = v.WoredaCode; } //if(!v.IsColumnNull("IsDeleted")) // t.IsDeleted = v.IsDeleted; //if(!v.IsColumnNull("UpdateTime")) // t.UpdateTime = v.UpdateTime; list.Add(t); v.MoveNext(); } return(list); }
public static List <int> GetDeletedIDsAfter(long LastVersion) { BLL.Woreda v = new BLL.Woreda(); //v.LoadDeletedIDs(LastVersion); List <int> list = new List <int>(); while (!v.EOF) { list.Add((int)v.GetColumn("ID")); v.MoveNext(); } return(list); }
public static void DeleteList(List <int> list) { BLL.Woreda bv = new BLL.Woreda(); 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 <Woreda> GetUpdatesAfter(long?lastVersion, DateTime?lastUpdateTime) { BLL.Woreda v = new BLL.Woreda(); 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 SaveList(List <HCMIS.Desktop.GeneralLookups.Woreda> list) { BLL.Woreda bv = new BLL.Woreda(); foreach (HCMIS.Desktop.GeneralLookups.Woreda 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.WoredaName != "" && v.WoredaName != null) { bv.WoredaName = v.WoredaName; } if (v.ZoneID.HasValue) { bv.ZoneID = v.ZoneID.Value; } if (v.WoredaCode != "" && v.WoredaCode != null) { bv.WoredaCode = v.WoredaCode; } //if( v.IsDeleted.HasValue ) // bv.IsDeleted = v.IsDeleted.Value; //if( v.UpdateTime.HasValue ) // bv.UpdateTime = v.UpdateTime.Value; bv.Save(); } }
public static void SaveList(List<HCMIS.Desktop.GeneralLookups.Woreda> list) { BLL.Woreda bv = new BLL.Woreda(); foreach (HCMIS.Desktop.GeneralLookups.Woreda 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.WoredaName != "" && v.WoredaName != null) bv.WoredaName = v.WoredaName; if (v.ZoneID.HasValue) bv.ZoneID = v.ZoneID.Value; if (v.WoredaCode != "" && v.WoredaCode != null) bv.WoredaCode = v.WoredaCode; //if( v.IsDeleted.HasValue ) // bv.IsDeleted = v.IsDeleted.Value; //if( v.UpdateTime.HasValue ) // bv.UpdateTime = v.UpdateTime.Value; bv.Save(); } }
public static List<Woreda> GetUpdatesAfter(long? lastVersion, DateTime? lastUpdateTime) { BLL.Woreda v = new BLL.Woreda(); 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.Woreda v = new BLL.Woreda(); //v.LoadDeletedIDs(LastVersion); List<int> list = new List<int>(); while (!v.EOF) { list.Add((int)v.GetColumn("ID")); v.MoveNext(); } return list; }
public static List<Woreda> GetAll() { BLL.Woreda v = new BLL.Woreda(); v.LoadAll(); return ToList(v); }
public static void DeleteList(List<int> list) { BLL.Woreda bv = new BLL.Woreda(); 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 <Woreda> GetAll() { BLL.Woreda v = new BLL.Woreda(); v.LoadAll(); return(ToList(v)); }