private static void Main()
{
// LinkedList<string> -sasto moje zaradi polimorfizma
IEnumerable<string> list = new LinkedList<string>(
"1st element",
new LinkedList<string>("2nd element", new LinkedList<string>("3rd element")));
foreach (var item in list)
{
Console.WriteLine(item);
}
// ot metoda v LinkedList
var enumerator = list.GetEnumerator();
// pak se vliza v sastiat method, v koito i otogore vlizahme, defakto dolnite redove zamestvat foreacha
while (enumerator.MoveNext())
{
Console.WriteLine(enumerator.Current);
}
// enumerator.Reset();
var nums = new CustomList<int>();
nums.Add(5);
nums.Add(2);
nums.Add(4);
nums.Add(2);
nums.Add(1);
foreach (var num in nums)
{
Console.WriteLine(num);
}
}
static void Main()
{
var list = new CustomList<int>();
list.Add(-2);
list.Add(12);
list.Add(21);
list.Add(33);
Console.WriteLine(list.IndexOf(-2));
Console.WriteLine(list.IndexOf(12));
Console.WriteLine(list.IndexOf(21));
Console.WriteLine(list.IndexOf(-22));
Console.WriteLine(list);
list.Remove(12);
Console.WriteLine(list);
list.Add(5);
Console.WriteLine(list);
Console.WriteLine(list.Min());
Console.WriteLine(list.Max());
list[0] = 120;
Console.WriteLine(list);
Console.WriteLine(list[3]);
}
static void Main()
{
var doubleList = new CustomList<double>();
doubleList.Add(5.5);
doubleList.Add(6.9);
doubleList.Add(6.4);
doubleList.Add(6.7);
doubleList.Add(5.6);
int count = doubleList.Count;
double max = doubleList.Max();
double min = doubleList.Min();
Console.WriteLine(doubleList);
Console.WriteLine("Max: {0}; Min: {1}; Count: {2}", max, min, count);
doubleList.Remove(6.4);
doubleList.Remove(5.5);
doubleList.RemoveAt(1);
count = doubleList.Count;
max = doubleList.Max();
min = doubleList.Min();
Console.WriteLine(doubleList);
Console.WriteLine("Max: {0}; Min: {1} Count: {2}", max, min, count);
doubleList.Clear();
bool isEmpty = doubleList.isEmpty;
Console.WriteLine(isEmpty);
Console.WriteLine(doubleList);
var stringList = new CustomList<string>();
stringList.Add("Kircho");
stringList.Add("Jecho");
stringList.Add("Mecho");
stringList.Add("Vulcho");
bool jecho = stringList.Contais("Jecho");
bool nencho = stringList.Contais("Nencho");
string who = stringList.ElementOf(0);
int index = stringList.IndexOf("Vulcho");
string maxString = stringList.Max();
Console.WriteLine(stringList);
Console.WriteLine("jecho: {0} \nnencho: {1} \nElement of 0 index: {2} \nIndex of Vulcho: {3} \nMax: {4}"
, jecho, nencho,who, index, maxString);
string indexer = stringList[3];
Console.WriteLine(indexer);
}
static void Main()
{
//Displaying program version
var versionAttribute = typeof (CustomList<>).GetCustomAttributes(typeof (VersionAttribute), true);
Console.WriteLine("Program version: {0}v\n", versionAttribute[0]);
ComputerParts cpu = new ComputerParts("AMD Athlon II X3 3.20 Ghz", 90m);
ComputerParts ram = new ComputerParts("Kingston HyperX 4x2 GB", 130m);
ComputerParts motherboard = new ComputerParts("Asrock PRO X3", 50m);
ComputerParts dvd = new ComputerParts("DVD-ROM LG DH18NS60", 21m);
ComputerParts hdd = new ComputerParts("Samsung SSD 256 GB", 110m);
CustomList<ComputerParts> parts = new CustomList<ComputerParts>();
//Adding elements
parts.Add(cpu);
parts.Add(ram);
parts.Add(motherboard);
parts.Add(dvd);
Console.WriteLine(parts);
Console.WriteLine();
//Accessing element by index
Console.WriteLine(parts[2]);
Console.WriteLine();
//Removing element
parts.Remove(3);
Console.WriteLine(parts);
Console.WriteLine();
//Insert element
parts.Insert(hdd, 2);
Console.WriteLine(parts);
Console.WriteLine();
//Find element index by value
Console.WriteLine("Motherboard index is {0}", parts.IndexOf(motherboard));
Console.WriteLine();
//Check if the list contains a value
Console.WriteLine("Does the list contains HDD ? - {0}", parts.Contains(hdd));
Console.WriteLine();
//Cheking the minimum and maximum part by price
Console.WriteLine("The cheapest part is: {0}", parts.Min());
Console.WriteLine("The most expensive part is: {0}", parts.Max());
Console.WriteLine();
//Now we delete all the elements in the list
parts.Clear();
Console.WriteLine("We have a brand new list now :) {0}", parts);
}
public static CustomList<ParameterFilterValue> GetReportValue(string parent)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ParameterFilterValue> ParameterFilterValueCollection = new CustomList<ParameterFilterValue>();
IDataReader reader = null;
String sql = "select OrgKey As ActualValues, OrgName As DisplayMember, OrgName As [Values] from Gen_Org Where OrgParentKey in(" + parent + ")";//'" + userCode + "'";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ParameterFilterValue newParameterFilterValue = new ParameterFilterValue();
newParameterFilterValue.SetData(reader);
ParameterFilterValueCollection.Add(newParameterFilterValue);
}
return ParameterFilterValueCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (conManager != null)
{
conManager.CloseConnection();
conManager.Dispose();
}
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<CmnBankAccountType> GetAllCmnBankAccountType()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<CmnBankAccountType> CmnBankAccountTypeCollection = new CustomList<CmnBankAccountType>();
IDataReader reader = null;
const String sql = "select * from CmnBankAccountType";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
CmnBankAccountType newCmnBankAccountType = new CmnBankAccountType();
newCmnBankAccountType.SetData(reader);
CmnBankAccountTypeCollection.Add(newCmnBankAccountType);
}
return CmnBankAccountTypeCollection;
}
catch(Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<SegmentNames> GetAllSegmentNames()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<SegmentNames> SegmentNamesCollection = new CustomList<SegmentNames>();
IDataReader reader = null;
const String sql = "select *from SegmentNames";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
SegmentNames newSegmentNames = new SegmentNames();
newSegmentNames.SetData(reader);
SegmentNamesCollection.Add(newSegmentNames);
}
return SegmentNamesCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<HousekeepingHierarchy> GetAllHousekeepingHierarchy(Int32 hKID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<HousekeepingHierarchy> HousekeepingHierarchyCollection = new CustomList<HousekeepingHierarchy>();
IDataReader reader = null;
String sql = "select *from HousekeepingHierarchy where HKID=" + hKID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
HousekeepingHierarchy newHousekeepingHierarchy = new HousekeepingHierarchy();
newHousekeepingHierarchy.SetData(reader);
HousekeepingHierarchyCollection.Add(newHousekeepingHierarchy);
}
return HousekeepingHierarchyCollection;
}
catch(Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<Configuration> GetAllConfiguration()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan);
CustomList<Configuration> ConfigurationCollection = new CustomList<Configuration>();
const String sql = "Select *from tblConfiguration";
IDataReader reader = null; ;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
Configuration newConfiguration = new Configuration();
newConfiguration.SetData(reader);
ConfigurationCollection.Add(newConfiguration);
}
reader.Close();
ConfigurationCollection.SelectSpName = "spSelectConfiguration";
ConfigurationCollection.InsertSpName = "spInsertConfiguration";
ConfigurationCollection.UpdateSpName = "spUpdateConfiguration";
ConfigurationCollection.SelectSpName = "spDeleteConfiguration";
return ConfigurationCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<UserGroupList> GetAllUserGroupWithUserCode(string userCode)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan);
CustomList<UserGroupList> UserGroupListCollection = new CustomList<UserGroupList>();
String sql = "Exec spUserGroupList'" + userCode + "'";
IDataReader reader = null;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
UserGroupList newUserGroup = new UserGroupList();
newUserGroup.SetData(reader);
UserGroupListCollection.Add(newUserGroup);
}
reader.Close();
return UserGroupListCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static void Main()
{
var list = new CustomList<int>();
list.Add(0);
list.Add(5);
list.Add(-1);
list.Add(101);
Console.WriteLine(list.Max());
Console.WriteLine(list.Min());
Console.WriteLine(list[0]);
Console.WriteLine(list[1]);
Console.WriteLine(string.Join(", ", list));
}
static void Main(string[] args)
{
CustomList<int> list = new CustomList<int>(3);
list.Add(1);
list.Add(2);
list.Add(3);
list.Add(4);
list.Insert(1, 40);
Console.WriteLine(list.Count);
Console.WriteLine(list);
System.Reflection.MemberInfo info = typeof(CustomList<>);
foreach (object attribute in info.GetCustomAttributes(false))
{
Console.WriteLine(attribute);
}
}
private static void Main(string[] args)
{
var list = new CustomList<string>();
for (int i = 0; i < 100; i++)
{
var item = new CustomListItem<string>();
item.Value = String.Concat("Item #", i);
list.Add(item);
}
list.Reverse();
}
static void Main(string[] args)
{
CustomList<int> list = new CustomList<int>(4);
list.Add(1);
list.Add(2);
list.Add(3);
list.Add(4);
list.Add(5);
list.Add(6);
list.Add(7);
list.Add(8);
Console.WriteLine(list.Max());
Console.WriteLine(list.Min());
}
public static void PublicListPermissionTest()
{
var expected = new CustomList(dataStorage, userInfo, ListPermission.PUBLIC, TestListName);
expected.Add(TestListItem);
Manage(new[] { "-cp", TestListName });
var differentUserInfo = new UserInfo(userInfo.Id + 1, userInfo.RoleIds);
Assert.DoesNotThrow(
() => listManager.Manage(differentUserInfo, new[] { "-a", TestListItem, TestListName })
);
var actual = listManager.GetList(TestListName);
Assert.AreEqual(expected, actual);
}
public void GrowArray_ExceedLaterCapacity_CapacityDoubles()
{
// arrange
CustomList <int> testList = new CustomList <int>()
{
1, 2, 3, 4, 5, 6, 7, 8
};
int expected = 16;
int actual;
// act
testList.Add(9);
actual = testList.Capacity;
// assert
Assert.AreEqual(expected, actual);
}
public void Combine_combineTwoList_Addiition()
{
// arrange
CustomList <int> testList = new CustomList <int>();
CustomList <int> testList2 = new CustomList <int>();
int expected = 237;
int actual;
// act
testList.Add(234);
testList2.Add(237);
CustomList <int> NewList = testList + testList2;
actual = NewList[1];
// assert
Assert.AreEqual(expected, actual);
}
public void AdditionOverload_OneItemAndEmptyList_ShouldEqualOneItemList()
{
// Arrange
CustomList <int> left = new CustomList <int>();
left.Add(1);
CustomList <int> right = new CustomList <int>();
// Act
CustomList <int> temp = new CustomList <int>();
temp.Add(1);
string expected = temp.ToString();
string actual = (left + right).ToString();
// Assert
Assert.AreEqual(expected, actual);
}
public void Remove_RemoveFromList_VerifyRemoveAtIndex()
{
//Arrange
CustomList <int> expectedlList = new CustomList <int>();
CustomList <int> actualList = new CustomList <int>();
int expected;
int actual;
//Act
expectedlList.Add(1);
actualList.Add(1);
actualList.Add(1);
actualList.Remove(1);
expected = expectedlList.Count;
actual = actualList.Count;
//Assert
Assert.AreEqual(expected, actual);
}
public void AddMethod_Add1ThroughyIs500_CapacityIs512() // FIX- Capacity should double
{
// Arrange
CustomList <int> customList = new CustomList <int>();
int expected = 512;
int actual;
// Act
for (int i = 1; i <= 500; i++)
{
customList.Add(i);
}
actual = customList.Capacity;
// Assert
Assert.AreEqual(expected, actual);
}
public void SubtractionOperator_AllInstanceRemovedFromList()
{
CustomList <int> customList = new CustomList <int>();
CustomList <int> customList1 = new CustomList <int>();
customList.Add(1);
customList.Add(2);
customList.Add(3);
customList.Add(2);
customList1.Add(2);
int actual;
int expected = 3;
customList = customList - customList1;
actual = customList[1];
Assert.AreEqual(expected, actual);
}
private static void ImplementCommand(CustomList <string> customList, string[] tokens, string command)
{
switch (command)
{
case "Add":
customList.Add(tokens[1]);
break;
case "Remove":
customList.Remove(int.Parse(tokens[1]));
break;
case "Contains":
Console.WriteLine(customList.Contains(tokens[1]));
break;
case "Swap":
customList.Swap(int.Parse(tokens[1]), int.Parse(tokens[2]));
break;
case "Greater":
Console.WriteLine(customList.CountGreaterThan(tokens[1]));
break;
case "Max":
Console.WriteLine(customList.Max());
break;
case "Min":
Console.WriteLine(customList.Min());
break;
case "Sort":
customList.Sort();
break;
case "Print":
foreach (var item in customList)
{
Console.WriteLine(item);
}
break;
}
}
static void Main(string[] args)
{
CustomList<int> sample = new CustomList<int>();
sample.Add(1);
sample.Add(0);
sample.Add(-3);
sample.Add(-12);
sample.Add(-2);
sample.Add(100);
sample.Add(-1);
sample.Add(1);
sample.Add(-1);
Console.WriteLine("Befoure we remove negative elements:");
for (int index = 0; index < sample.Count; index++)
{
Console.Write(sample[index]);
if (index != sample.Count - 1)
{
Console.Write(',');
}
}
Console.WriteLine();
sample.RemoveNegativeElements();
Console.WriteLine("After we removed negative elements:");
for (int index = 0; index < sample.Count; index++)
{
Console.Write(sample[index]);
if (index != sample.Count - 1)
{
Console.Write(',');
}
}
Console.WriteLine();
}
static void Main(string[] args)
{
CustomList<int> list = new CustomList<int>();
list.Add(5);
list.Add(-55555);
list.Add(1000);
list.Add(55481000);
list.Add(5);
list.Add(1000);
Console.WriteLine(list.Min);
list.Remove(1000);
list[1] = 50;
Console.WriteLine(list);
}
public static CustomList<LatestNews> GetAllLatestNewsForDisplay()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<LatestNews> LatestNewsCollection = new CustomList<LatestNews>();
IDataReader reader = null;
String sql = "Exec GetLatestNews";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
LatestNews newLatestNews = new LatestNews();
newLatestNews.NewsDetails = reader.GetString("NewsDetails");
LatestNewsCollection.Add(newLatestNews);
}
return LatestNewsCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<StockView> StockView1()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<StockView> StockViewCollection = new CustomList<StockView>();
IDataReader reader = null;
String sql = "EXEC spGetStockView";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
StockView newStockView = new StockView();
newStockView.SetData(reader);
StockViewCollection.Add(newStockView);
}
return StockViewCollection;
}
catch(Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ContactTypeChild> GetAllContactTypeChild()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ContactTypeChild> ContactTypeChildCollection = new CustomList<ContactTypeChild>();
IDataReader reader = null;
const String sql = "select *from ContactTypeChild";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ContactTypeChild newContactTypeChild = new ContactTypeChild();
newContactTypeChild.SetData(reader);
ContactTypeChildCollection.Add(newContactTypeChild);
}
ContactTypeChildCollection.InsertSpName = "spInsertContactTypeChild";
ContactTypeChildCollection.UpdateSpName = "spUpdateContactTypeChild";
ContactTypeChildCollection.DeleteSpName = "spDeleteContactTypeChild";
return ContactTypeChildCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<AccReportConfigurationHead> GetAllAccReportConfigurationHead(Int32 ReportTypeID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<AccReportConfigurationHead> AccReportConfigurationHeadCollection = new CustomList<AccReportConfigurationHead>();
IDataReader reader = null;
String sql = "Exec spGetHeadCategoryMap "+ReportTypeID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
AccReportConfigurationHead newAccReportConfigurationHead = new AccReportConfigurationHead();
newAccReportConfigurationHead.SetData(reader);
AccReportConfigurationHeadCollection.Add(newAccReportConfigurationHead);
}
return AccReportConfigurationHeadCollection;
}
catch(Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ItemMaster> GetAllItemMasterByItemCode(String itemCode)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ItemMaster> ItemMasterCollection = new CustomList<ItemMaster>();
IDataReader reader = null;
String sql = "select *from ItemMaster Where ItemCode='"+itemCode+"'";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemMaster newItemMaster = new ItemMaster();
newItemMaster.SetData(reader);
ItemMasterCollection.Add(newItemMaster);
}
return ItemMasterCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ItemMaster> FindAllItemMasterGroupWise()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ItemMaster> ItemMasterCollection = new CustomList<ItemMaster>();
IDataReader reader = null;
String sql = "select ItemCode,ItemDescription,ItemGroupID,ItemSubGroupID from ItemMaster";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemMaster newItemMaster = new ItemMaster();
newItemMaster.SetDataItem(reader);
ItemMasterCollection.Add(newItemMaster);
}
return ItemMasterCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ItemStructure> GetAllItemStructure(Int32 itemGroupID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ItemStructure> ItemStructureCollection = new CustomList<ItemStructure>();
IDataReader reader = null;
String sql = "select *from ItemStructure Where GroupItemID=" + itemGroupID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemStructure newItemStructure = new ItemStructure();
newItemStructure.SetData(reader);
ItemStructureCollection.Add(newItemStructure);
}
return ItemStructureCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ReportSuiteMenu> GetReportSuiteMenu()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ReportSuiteMenu> ReportSuiteMenuCollection = new CustomList<ReportSuiteMenu>();
IDataReader reader = null;
String sql = "EXEC spGetUserWiseProfileReport";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ReportSuiteMenu newReportSuiteMenu = new ReportSuiteMenu();
newReportSuiteMenu.SetData(reader);
ReportSuiteMenuCollection.Add(newReportSuiteMenu);
}
return ReportSuiteMenuCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (conManager != null)
{
conManager.CloseConnection();
conManager.Dispose();
}
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ReportSuiteMenu> GetReportList()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ReportSuiteMenu> ReportSuiteMenuCollection = new CustomList<ReportSuiteMenu>();
IDataReader reader = null;
String sql = "EXEC spGetReportList";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ReportSuiteMenu newReportSuiteMenu = new ReportSuiteMenu();
newReportSuiteMenu.REPORTID = reader.GetInt32("REPORTID");
newReportSuiteMenu.NODE_TEXT = reader.GetString("NODE_TEXT");
ReportSuiteMenuCollection.Add(newReportSuiteMenu);
}
return ReportSuiteMenuCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (conManager != null)
{
conManager.CloseConnection();
conManager.Dispose();
}
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<GroupRule> GetAllGroupSecurityRule(string groupCode)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan);
CustomList<GroupRule> GroupSecurityRuleCollection = new CustomList<GroupRule>();
String sql = "Select *from GroupRule where GroupCode='" + groupCode + "'";
IDataReader reader = null;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
GroupRule newGroupSecurityRule = new GroupRule();
newGroupSecurityRule.SetData(reader);
GroupSecurityRuleCollection.Add(newGroupSecurityRule);
}
reader.Close();
GroupSecurityRuleCollection.InsertSpName = "spInsertGroupRule";
GroupSecurityRuleCollection.SelectSpName = "spDeleteGroupRule";
return GroupSecurityRuleCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<CmnBankAccount> GetAllCmnBankAccount()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<CmnBankAccount> CmnBankAccountCollection = new CustomList<CmnBankAccount>();
IDataReader reader = null;
String sql = "spFindBankAccount";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
CmnBankAccount newCmnBankAccount = new CmnBankAccount();
newCmnBankAccount.SetData(reader);
CmnBankAccountCollection.Add(newCmnBankAccount);
}
return CmnBankAccountCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<LatestNews> GetAllLatestNews()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<LatestNews> LatestNewsCollection = new CustomList<LatestNews>();
IDataReader reader = null;
const String sql = "select *from LatestNews";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
LatestNews newLatestNews = new LatestNews();
newLatestNews.SetData(reader);
LatestNewsCollection.Add(newLatestNews);
}
LatestNewsCollection.InsertSpName = "spInsertLatestNews";
LatestNewsCollection.UpdateSpName = "spUpdateLatestNews";
LatestNewsCollection.DeleteSpName = "spDeleteLatestNews";
return LatestNewsCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<CmnDocListTableMapping> GetAllCmnTransactionReferenceFind()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<CmnDocListTableMapping> CmnTransRefCollection = new CustomList<CmnDocListTableMapping>();
IDataReader reader = null;
String sql = "EXEC spFindDocListTableMaping";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
CmnDocListTableMapping newCmnTransactionReference = new CmnDocListTableMapping();
newCmnTransactionReference.SetData(reader);
CmnTransRefCollection.Add(newCmnTransactionReference);
}
return CmnTransRefCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ItemMaster> FindAllItemMaster()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ItemMaster> ItemMasterCollection = new CustomList<ItemMaster>();
IDataReader reader = null;
const String sql = "spFindItem";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemMaster newItemMaster = new ItemMaster();
newItemMaster.SetDataFindItem(reader);
ItemMasterCollection.Add(newItemMaster);
}
return ItemMasterCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
