public static void Delete(String Name)
{
using (Leave.DataClients.SqlTableTracker Databasetest = new Leave.DataClients.SqlTableTracker(Leave.Modules.Holiday_Database_Connector.connection_string2, "LeaveTypes"))
{
Databasetest.Delete("LeaveType='" + Name + "'");
}
}
public static string getTable()
{
//try
//{
using (Leave.DataClients.SqlTableTracker test = new Leave.DataClients.SqlTableTracker(Leave.Modules.Holiday_Database_Connector.connection_string2, "Employees" + ", LeaveList"))
{
DataTable table = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID");
DataManager dm = new DataManager(table);
String columns = dm.ExtractColumns("\t") + "\n" + dm.ExtractData("\t");
return(columns);
}
}
