//-------------------------- Invoice Details------------------------------------------------------
private void UpdateInvoiceData()
{
dt = new DataTable();
dt = MiddleTyre.GetCompanyNames();
List <string> s8 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.CompanyName = s8;
}
public ActionResult Signin(AdminModel aa)
{
FormsAuthentication.SetAuthCookie(aa.Loginid, aa.Rememberme);
Session["Loginid"] = aa.Loginid;
Session["Password"] = aa.Password;
if (aa.Rememberme)
{
HttpCookie cookie = new HttpCookie("Login");
cookie.Values.Add("Loginid", aa.Loginid);
cookie.Values.Add("Password", aa.Password);
cookie.Expires = DateTime.Now.AddDays(15);
Response.Cookies.Add(cookie);
}
ViewBag.Error = null;
if (aa.Loginid == "admin" && aa.Password == "1234")
{
Login.HasLogin = true;
return(RedirectToAction("Homepage", "Role1"));
}
else
{
string ErrorMessage = "";
string EmployeeId = "";
MiddleTyre.CheckUser(aa.Loginid, aa.Password, ref ErrorMessage, ref EmployeeId);
if (ErrorMessage == "Valid User")
{
Login.HasLogin = true;
Session["UserId"] = EmployeeId;
string EmployeeName = "";
MiddleTyre.GetEmployeeName(EmployeeId, ref EmployeeName, ref ErrorMessage);
if (ErrorMessage == "")
{
ViewBag.Error = ErrorMessage;
}
Session["EmployeeName"] = EmployeeName;
return(RedirectToAction("Homepage", "Role2"));
}
else
{
Login.HasLogin = false;
ViewBag.Error = ErrorMessage;
return(View());
}
}
}
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 UpdateDCData()
{
dt = new DataTable();
dt = MiddleTyre.GetCompanyNames();
List <string> s8 = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
ViewBag.CompanyName = s8;
var dt2 = new DataTable
{
Columns = { { "Returnable", typeof(string) } }
};
dt2.Rows.Add("Returnable");
dt2.Rows.Add("Non-Returnable");
List <string> ss = dt2.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList EmailType = new SelectList(ss);
ViewData["Returnable"] = EmailType;
}
public ActionResult SelectChallan()
{
try
{
if (Login.HasLogin == false)
{
return(RedirectToAction("Signin", "Admin"));
}
else
{
ModelState.Clear();
string EmployeeId = Session["UserId"].ToString();
dt = MiddleTyre.GetDCNumber(EmployeeId);
List <string> s = dt.AsEnumerable().Select(x => x[0].ToString()).ToList();
SelectList Countries = new SelectList(s);
ViewData["DCNumber"] = Countries;
return(View());
}
}
catch (Exception ex)
{
}
return(View());
}
public ActionResult SendEmailView(sendemail snd)
{
MiddleTyre.SendEmailView(snd);
return(View("Adminloggedin"));
}
private IEnumerable <ChallanModel> NewMethod(string DCId)
{
List <ChallanModel> DescList = new List <ChallanModel>();
DataTable sdr = new DataTable();
DataTable sdr1 = new DataTable();
DataTable dt = new DataTable();
MiddleTyre.GetDCInfo(DCId, ref sdr, ref sdr1, ref dt);
try
{
string address = "";
foreach (DataRow dr in sdr.Rows)
{
ViewBag.CompanyName = Convert.ToString(dr["Company"]);
ViewBag.Website = Convert.ToString(dr["Website"]);
ViewBag.Logo = Convert.ToString(dr["Logo"]);
ViewBag.Mail = Convert.ToString(dr["EmailId"]);
ViewBag.Phone = Convert.ToString(dr["PhoneNumber"]);
ViewBag.Fax = Convert.ToString(dr["FaxNumber"]);
address = Convert.ToString(dr["Plot"]);
address += "," + Convert.ToString(dr["Street"]);
address += "," + Convert.ToString(dr["City"]) + "-" + Convert.ToString(dr["PinCode"]);
}
string[] AddSplit = address.Replace("\r\n", "").ToString().Split(',');
for (int k = 0; k < AddSplit.Length; k = k + 2)
{
try
{
switch (k)
{
case 0:
if (k == AddSplit.Length - 1)
{
ViewBag.FromAddress1 = AddSplit[k];
}
else
{
ViewBag.FromAddress1 = AddSplit[k] + "," + AddSplit[k + 1] + ",";
}
break;
case 2:
if (k == AddSplit.Length - 1)
{
ViewBag.FromAddress2 = AddSplit[k];
}
else
{
ViewBag.FromAddress2 = AddSplit[k] + "," + AddSplit[k + 1] + ",";
}
break;
case 4:
if (k == AddSplit.Length - 1)
{
ViewBag.FromAddress3 = AddSplit[k];
}
else
{
ViewBag.FromAddress3 = AddSplit[k] + "," + AddSplit[k + 1] + ",";
}
break;
case 6:
if (k == AddSplit.Length - 1)
{
ViewBag.FromAddress4 = AddSplit[k];
}
else
{
ViewBag.FromAddress4 = AddSplit[k] + "," + AddSplit[k + 1];
}
break;
default:
int kk = 0;
break;
}
}
catch (Exception)
{
}
}
}
catch (Exception ex)
{
}
finally
{
}
try
{
string ToAddress = "";
foreach (DataRow dr in sdr1.Rows)
{
ViewBag.Dc_Number = Convert.ToString(dr["DC_Number"]);
try
{
firstdate = DateTime.Parse(Convert.ToString(dr["Date"]),
CultureInfo.CreateSpecificCulture("fr-FR"));
}
catch (Exception)
{
}
try
{
var firstDateString = firstdate.ToString("dd/MM/yyyy");
ViewBag.Date = firstDateString;
}
catch (Exception)
{
}
//DateTime firstdate = DateTime.ParseExact(Convert.ToString(dr["Date"]),
// "dd/MM/yyyy hh:mm:ss tt",
// CultureInfo.InvariantCulture);
//var firstDateString = firstdate.ToString("dd-MM-yyyy");
//ViewBag.Date = firstDateString;
ViewBag.Subject = Convert.ToString(dr["Subject"]);
ViewBag.Matter = Convert.ToString(dr["Descreption"]);
ToAddress = Convert.ToString(dr["ToAddress"]);
}
string[] AddSplit2 = ToAddress.Replace("\r\n", "").ToString().Split(',');
for (int k = 0; k < AddSplit2.Length; k = k + 2)
{
try
{
switch (k)
{
case 0:
if (k == AddSplit2.Length - 1)
{
ViewBag.ToAddress1 = AddSplit2[k];
}
else
{
ViewBag.ToAddress1 = AddSplit2[k] + "," + AddSplit2[k + 1] + ",";
}
break;
case 2:
if (k == AddSplit2.Length - 1)
{
ViewBag.ToAddress2 = AddSplit2[k];
}
else
{
ViewBag.ToAddress2 = AddSplit2[k] + "," + AddSplit2[k + 1] + ",";
}
break;
case 4:
if (k == AddSplit2.Length - 1)
{
ViewBag.ToAddress3 = AddSplit2[k];
}
else
{
ViewBag.ToAddress3 = AddSplit2[k] + "," + AddSplit2[k + 1] + ",";
}
break;
case 6:
if (k == AddSplit2.Length - 1)
{
ViewBag.ToAddress4 = AddSplit2[k];
}
else
{
ViewBag.ToAddress4 = AddSplit2[k] + "," + AddSplit2[k + 1];
}
break;
default:
int kk = 0;
break;
}
}
catch (Exception)
{
}
}
}
catch (Exception)
{
}
finally
{
}
try
{
DescList = (from DataRow dr in dt.Rows
select new ChallanModel()
{
ID = Convert.ToInt32(dr["S_No"].ToString()),
Description = Convert.ToString(dr["Description"].ToString()),
Quantity = Convert.ToString(dr["Quantity"].ToString()),
Returnable = Convert.ToString(dr["Retunable"].ToString()),
}).ToList();
}
catch (Exception)
{
}
return(DescList);
}
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;
}
