protected void btnLogin_Click(object sender, EventArgs e) { if (ValidateControls()) { try { string ssssssssssss = Encryptor.Encrypt(txtPass.Text); DataTable DT = Fn.FillDSet("sp_Login '" + txtUser.Text + "','" + Encryptor.Encrypt(txtPass.Text) + "'").Tables[0]; if (txtPass.Text == Encryptor.Decrypt(DT.Rows[0]["Password"].ToString())) { //string EN = ""; //int? EID = 0, UGID = 0; //bool? IsAllowed = false; //using (DBDataContext db = new DBDataContext()) //{ // db.User_Login(txtUser.Text, ssssssssssss, ref EN, ref EID, ref UGID, "", ref IsAllowed); //} //if (Convert.ToBoolean(IsAllowed) && Convert.ToInt32(EID) > 0) //{ Session.Add("EmpName", Convert.ToString(DT.Rows[0]["EmpName"])); Response.Cookies["EmpName"].Value = Convert.ToString(DT.Rows[0]["EmpName"]); Response.Cookies["EmpName"].Expires = DateTime.Now.AddDays(1); Session.Add("bIsEmployee", Convert.ToString(DT.Rows[0]["bIsEmployee"])); Response.Cookies["bIsEmployee"].Value = Convert.ToString(DT.Rows[0]["bIsEmployee"]); Response.Cookies["bIsEmployee"].Expires = DateTime.Now.AddDays(1); Session.Add("Emp_Id", Convert.ToString(DT.Rows[0]["Emp_Id"])); Response.Cookies["Emp_Id"].Value = Convert.ToString(DT.Rows[0]["Emp_Id"]); Response.Cookies["Emp_Id"].Expires = DateTime.Now.AddDays(1); //READ Cookie in c# //Convert.ToString(HttpContext.Current.Session["Emp_Id"]); Session.Add("User_Group_ID", Convert.ToString(DT.Rows[0]["User_Group_ID"])); Response.Cookies["User_Group_ID"].Value = Convert.ToString(DT.Rows[0]["User_Group_ID"]); Response.Cookies["User_Group_ID"].Expires = DateTime.Now.AddDays(1); Session.Add("UserID", Convert.ToString(DT.Rows[0]["UserID"])); Response.Cookies["UserID"].Value = Convert.ToString(DT.Rows[0]["UserID"]); Response.Cookies["UserID"].Expires = DateTime.Now.AddDays(1); Session.Add("username", Convert.ToString(DT.Rows[0]["UserName"])); Response.Cookies["username"].Value = Convert.ToString(DT.Rows[0]["UserName"]); Response.Cookies["username"].Expires = DateTime.Now.AddDays(1); Session.Add("onlyname", Convert.ToString(DT.Rows[0]["onlyname"])); Response.Cookies["onlyname"].Value = Convert.ToString(DT.Rows[0]["onlyname"]); Response.Cookies["onlyname"].Expires = DateTime.Now.AddDays(1); Session.Add("GroupID", Convert.ToString(DT.Rows[0]["GroupID"])); Response.Cookies["GroupID"].Value = Convert.ToString(DT.Rows[0]["GroupID"]); Response.Cookies["GroupID"].Expires = DateTime.Now.AddDays(1); //Session.Add("PRD", DT.Rows[0][5]); Session.Add("ContactNo", Convert.ToString(DT.Rows[0]["ContactNo"])); Response.Cookies["ContactNo"].Value = Convert.ToString(DT.Rows[0]["ContactNo"]); Response.Cookies["ContactNo"].Expires = DateTime.Now.AddDays(1); Session.Add("email", Convert.ToString(DT.Rows[0]["Email"])); Response.Cookies["email"].Value = Convert.ToString(DT.Rows[0]["Email"]); Response.Cookies["email"].Expires = DateTime.Now.AddDays(1); Session.Add("designation", Convert.ToString(DT.Rows[0]["designation"])); Response.Cookies["designation"].Value = Convert.ToString(DT.Rows[0]["designation"]); Response.Cookies["designation"].Expires = DateTime.Now.AddDays(1); Session.Add("picExt", Convert.ToString(DT.Rows[0]["picExt"])); Response.Cookies["picExt"].Value = Convert.ToString(DT.Rows[0]["picExt"]); Response.Cookies["picExt"].Expires = DateTime.Now.AddDays(1); Session.Add("CompanyID", Convert.ToString(DT.Rows[0]["CompanyID"])); Response.Cookies["CompanyID"].Value = Convert.ToString(DT.Rows[0]["CompanyID"]); Response.Cookies["CompanyID"].Expires = DateTime.Now.AddDays(1); //Response.Cookies["theme"].Value = DT.Rows[0][3].ToString(); //Response.Cookies["theme"].Expires = DateTime.Now.AddDays(1); //Response.Cookies["PRD"].Value = HttpUtility.UrlEncode(DT.Rows[0][5].ToString()); //Response.Cookies["PRD"].Expires = DateTime.Now.AddDays(1); Response.Cookies["FirstRun"].Value = "1"; Response.Cookies["FirstRun"].Expires = DateTime.Now.AddDays(1); string S = Fn.ExenID("select TOP(1) Format(AMonth, 'MM')+Format(AMonth, 'yyy') AMonth from tblMonthCloseing"); Session.Add("Amonth", S); Session.Add("OfficeId", 16); Response.Cookies["OfficeId"].Value = "16"; Response.Cookies["OfficeId"].Expires = DateTime.Now.AddDays(1); // string[] info = Fn.GetRecords("SELECT AccYear, AccYear2, CodeSt, AMonth, AcYrID FROM tblSetup WHERE (CompID = 16)"); Session.Add("ActYr", Fn.FirstDayOfMonthFromDateTime(Convert.ToDateTime(info[0]))); Response.Cookies["ActYr"].Value = Convert.ToString(Fn.FirstDayOfMonthFromDateTime(Convert.ToDateTime(info[0]))); Response.Cookies["ActYr"].Expires = DateTime.Now.AddDays(1); Session.Add("ActYr2", Fn.LastDayOfMonthFromDateTime(Convert.ToDateTime(info[1]))); Response.Cookies["ActYr2"].Value = Convert.ToString(Fn.LastDayOfMonthFromDateTime(Convert.ToDateTime(info[1]))); Response.Cookies["ActYr2"].Expires = DateTime.Now.AddDays(1); Session.Add("ActMth", Convert.ToDateTime(info[3]).ToString("MMMM yyyy")); Response.Cookies["ActMth"].Value = Convert.ToString(Convert.ToDateTime(info[3]).ToString("MMMM yyyy")); Response.Cookies["ActMth"].Expires = DateTime.Now.AddDays(1); Session.Add("CodeSt", info[2]); Response.Cookies["CodeSt"].Value = Convert.ToString(info[2]); Response.Cookies["CodeSt"].Expires = DateTime.Now.AddDays(1); Session.Add("br", "16"); Response.Cookies["br"].Value = "16"; Response.Cookies["br"].Expires = DateTime.Now.AddDays(1); Session.Add("fy", Convert.ToString(info[4])); Response.Cookies["fy"].Value = Convert.ToString(info[4]); Response.Cookies["fy"].Expires = DateTime.Now.AddDays(1); //$.cookie('fy', $('#ddYear').val()); //$.cookie('ey', $('#ddey').val()); string S1 = Fn.ExenID("select TOP(1) Format(AMonth, 'MM')+Format(AMonth, 'yyy') AMonth from tblMonthCloseing"); //Session.Add("ActMth", S1); Session.Add("OfficeId", 16); Fn.Exec("INSERT INTO tblUserLog(UserID) VALUES (" + Convert.ToString(DT.Rows[0]["UserID"]) + ")"); Response.Cookies["xx"].Value = S; Response.Cookies["xx"].Expires = DateTime.Now.AddDays(1); Response.Cookies["yy"].Value = "16"; Response.Cookies["yy"].Expires = DateTime.Now.AddDays(1); Response.Redirect(DT.Rows[0]["MP"].ToString()); //} } else { lblMsg.Text = "The username or password you entered is incorrect."; lblMsg.Visible = true; } } catch (Exception ex) { lblMsg.Text = "The username or password you entered is incorrect..."; lblMsg.Visible = true; } } }
public void ProcessRequest(HttpContext context) { MyClass Fn = new MyClass(); try { var areaid = context.Request.Form["areas"]; int Newcode = 0; try { using (DBDataContext db = new DBDataContext()) { Newcode = db.tbl_Companies.Where(vv => vv.ParentId == Convert.ToDecimal(areaid)).Max(ss => ss.Code ?? 0); Newcode += 1; } } catch (Exception) { Newcode = 1; } var frmdata = context.Request.Form["vls"]; string[] d = frmdata.Split('½'); int CompanyID = 0; if (d[9] == "0") { CompanyID = Convert.ToInt32(Fn.ExenID("INSERT INTO tbl_Company (CompanyName, CompanyAbbrivation, CompanyPhoneNo, CompanyEmail, CompanyEstablishmentYear, CompanyWebsite, TblVillageCity, GPS, CompanyAddress, code, ParentId, Type,lvl) VALUES ('" + d[0] + "', '" + d[1] + "', '" + d[2] + "', '" + d[3] + "', '" + d[4] + "', '" + d[5] + "', '" + d[6] + "', '" + d[7] + "', '" + d[8] + "','" + Convert.ToString(Newcode) + "','" + areaid + "','BHU','3'); select SCOPE_IDENTITY();")); using (DBDataContext db = new DBDataContext()) { List <TblHResourcesLocation> oblist = new List <TblHResourcesLocation>(); var emps = db.Logins.Where(v => v.User_Group_Id == 2).Select(s => s.Emp_Id).ToList <int>(); foreach (var emp in emps) { oblist.Add(new TblHResourcesLocation() { LocID = Convert.ToInt32(CompanyID), User_ID = emp }); } db.TblHResourcesLocations.InsertAllOnSubmit(oblist); db.SubmitChanges(); } } else { CompanyID = Convert.ToInt32(d[9]); Fn.Exec(@"UPDATE tbl_Company set CompanyName= '" + d[0] + @"', CompanyAbbrivation= '" + d[1] + @"', CompanyPhoneNo= '" + d[2] + @"', CompanyEmail= '" + d[3] + @"', CompanyEstablishmentYear= '" + d[4] + @"', CompanyWebsite= '" + d[5] + @"', TblVillageCity = '" + d[6] + @"', GPS= '" + d[7] + @"', CompanyAddress= '" + d[8] + @"', ParentId= '" + areaid + @"', Type= 'BHU', lvl= '3' WHERE CompanyID='" + d[9] + "'"); } if (context.Request.Files.Count > 0 && CompanyID > 0) { HttpFileCollection SelectedFiles = context.Request.Files; for (int i = 0; i < SelectedFiles.Count; i++) { HttpPostedFile PostedFile = SelectedFiles[i]; string FileName = context.Server.MapPath("~/Uploads/CompanyProfile/" + PostedFile.FileName); string Path = context.Server.MapPath("~/Uploads/CompanyProfile/"); FileInfo fi = new FileInfo(FileName); //int fileID = 0; Fn.Exec("update tbl_Company set CompanyLogo = '" + fi.Extension + "' where CompanyID = " + Convert.ToString(CompanyID)); //PostedFile.SaveAs(Path + Convert.ToString(CompanyID) + fi.Extension); PostedFile.SaveAs(Path + Convert.ToString(CompanyID) + fi.Extension); if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF") { Bitmap Thumbnail = CreateThumbnail(Path + Convert.ToString(CompanyID) + fi.Extension, 32, 32); string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/CompanyProfile/", "A" + Convert.ToString(CompanyID) + fi.Extension); Thumbnail.Save(SaveAsThumbnail); } if (fi.Extension.ToUpper() == ".JPEG" || fi.Extension.ToUpper() == ".JPG" || fi.Extension.ToUpper() == ".BMP" || fi.Extension.ToUpper() == ".PNG" || fi.Extension.ToUpper() == ".GIF") { Bitmap Thumbnail = CreateThumbnail(Path + Convert.ToString(CompanyID) + fi.Extension, 75, 75); string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/CompanyProfile/", "B" + Convert.ToString(CompanyID) + fi.Extension); Thumbnail.Save(SaveAsThumbnail); } } } if (CompanyID > 0) { context.Response.ContentType = "text/plain"; context.Response.Write("DSU Registered Successfully!"); } } catch (Exception ex) { context.Response.ContentType = "text/plain"; context.Response.Write(ex.Message); } }