private void UpdateViewCompany()
{
dt = new DataTable();
dt = MiddleTyre.GetCountry();
List <string> s = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList Countries = new SelectList(s);
ViewData["Countries"] = Countries;
dt = new DataTable();
dt = MiddleTyre.GetCompanyNames();
List <string> s2 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.CompanyName = s2;
dt = new DataTable();
dt = MiddleTyre.GetBankNames();
List <string> s3 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList BankNames = new SelectList(s3);
ViewData["BankNames"] = BankNames;
}
private void UpdateEmployeeData()
{
dt = new DataTable();
dt = MiddleTyre.GetGenderNames();
List <string> s1 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.Gender = s1;
dt = new DataTable();
dt = MiddleTyre.GetMaratualStatus();
List <string> s2 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.MaritalStatus = s2;
dt = new DataTable();
dt = MiddleTyre.GetDepartmentName();
List <string> s3 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.Department = s3;
dt = new DataTable();
dt = MiddleTyre.GetDesignationName();
List <string> s4 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.Designation = s4;
dt = new DataTable();
dt = MiddleTyre.GetEmploymentType();
List <string> s5 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.Employment_Type = s5;
dt = new DataTable();
dt = MiddleTyre.GetEmploymentRole();
List <string> s6 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.EmployeeRole = s6;
dt = new DataTable();
dt = MiddleTyre.GetBloodGropu();
List <string> s7 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.BloodType = s7;
dt = new DataTable();
dt = MiddleTyre.GetCountry();
List <string> s = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList Countries = new SelectList(s);
ViewData["Countries"] = Countries;
var dt2 = new DataTable
{
Columns = { { "EmailType", typeof(string) } }
};
dt2.Rows.Add("Personal");
dt2.Rows.Add("Work");
List <string> ss = dt2.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList EmailType = new SelectList(ss);
ViewData["EmailType"] = EmailType;
var dt3 = new DataTable
{
Columns = { { "ContactType", typeof(string) } }
};
dt3.Rows.Add("Mobile");
dt3.Rows.Add("Landilne");
List <string> ss3 = dt3.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList ContactType = new SelectList(ss3);
ViewData["ContactType"] = ContactType;
var dt33 = new DataTable
{
Columns = { { "AddressType", typeof(string) } }
};
dt33.Rows.Add("Temporary");
dt33.Rows.Add("permanent");
List <string> ss33 = dt33.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList AddressType = new SelectList(ss33);
ViewData["AddressType"] = AddressType;
dt = new DataTable();
dt = MiddleTyre.GetCompanyNames();
List <string> s8 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.CompanyName = s8;
dt = new DataTable();
dt = MiddleTyre.GetEmployeeId();
List <string> s9 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
// SelectList CompanyNames = new SelectList(s2);
ViewBag.EmployeeID = s9;
dt = new DataTable();
dt = MiddleTyre.GetBankNames();
List <string> s33 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList BankNames = new SelectList(s33);
ViewData["BankNames"] = BankNames;
}