//-------------------------- 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; }