public void ProcessRequest(HttpContext context)
{
try
{
var frmdata = context.Request.Form["vls"];
string[] d = frmdata.Split('½');
int benID = Convert.ToInt32(Convert.ToString(Convert.ToString(((HttpCookie)HttpContext.Current.Request.Cookies["Emp_Id"]).Value)));
using (DBDataContext db = new DBDataContext())
{
//if (db.TblHResources.Where(v => v.Email == d[5]).Count() == 0)
//{
// TblHResource obj = new TblHResource();
var obj = db.TblHResources.Where(v => v.User_ID == benID).FirstOrDefault();
if (obj != null)
{
}
obj.ContactNos = d[0];
obj.Email = d[1];
obj.U_Pass = Encryptor.Encrypt(d[2].Replace("'", ""));
db.SubmitChanges();
Fn.ExenID(@"UPDATE Login
SET Password='******' WHERE Emp_Id=" + benID);
//}
//else
//{
// context.Response.ContentType = "text/plain";
// context.Response.Write("Record Already Exists");
//}
}
if (context.Request.Files.Count > 0 && benID > 0)
{
HttpFileCollection SelectedFiles = context.Request.Files;
for (int i = 0; i < SelectedFiles.Count; i++)
{
HttpPostedFile PostedFile = SelectedFiles[i];
string FileName = context.Server.MapPath("~/Uploads/EmployeePhoto/" + PostedFile.FileName);
string Path = context.Server.MapPath("~/Uploads/UserPhoto/");
FileInfo fi = new FileInfo(FileName);
int fileID = benID;
using (DBDataContext db = new DBDataContext())
{
var o = db.TblHResources.Where(v => v.User_ID == fileID).FirstOrDefault();
if (o != null)
{
o.PhotoExtension = fi.Extension;
//o.DisplayName = fi.Extension;
db.SubmitChanges();
}
}
PostedFile.SaveAs(Path + Convert.ToString(fileID) + 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(fileID) + fi.Extension, 32, 32);
string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/UserPhoto/", Convert.ToString(fileID) + "A" + 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(fileID) + fi.Extension, 75, 75);
string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/UserPhoto/", Convert.ToString(fileID) + "B" + fi.Extension);
Thumbnail.Save(SaveAsThumbnail);
}
//using (DBDataContext db = new DBDataContext())
//{
// db.sp_RegisterEmpWithLogin(d[0], d[1], "", "", "", d[2], d[5], "", d[3], 1, 1, DateTime.Now, Encryptor.Encrypt(d[6].Replace("'", "")), Convert.ToInt32(d[4]), Convert.ToString(benID)+"."+ fi.Extension);
//}
context.Response.ContentType = "text/plain";
context.Response.Write("Record Saved");
}
}
else if (benID > 0)
{
//using (DBDataContext db = new DBDataContext())
//{
// db.sp_RegisterEmpWithLogin(d[0], d[1], "", "", "", d[2], d[5], "", d[3], 1, 1, DateTime.Now, Encryptor.Encrypt(d[6].Replace("'", "")), Convert.ToInt32(d[4]), null);
//}
context.Response.ContentType = "text/plain";
context.Response.Write("Record Saved");
}
//context.Response.ContentType = "text/plain";
//context.Response.Write("Files Uploaded Successfully!!");
}
catch (Exception ex)
{
context.Response.ContentType = "text/plain";
context.Response.Write(ex.Message);
}
}
public static string SaveBasicData(string vals, string loc)
{
string[] d = vals.Split('½');
string[] l = loc.Split('½');
if (d[17] == "0")
{
DataSet ds = Fn.FillDSet(@"SELECT
'FRDP-EMP-' +RIGHT('0000' + CAST(MAX(EmpNo) + 1 AS VARCHAR(50)) ,3)
AS EmpNo
, CAST(MAX(EmpNo) + 1 AS VARCHAR(50)) EC
FROM (
SELECT CAST(EmpNo AS INT) EmpNo FROM [dbo].[TblHResources] WHERE EmpNo IS NOT NULL
) AS X");
DataTable dttt = ds.Tables[0];
string eno = Convert.ToString(dttt.Rows[0][0]);
string en = Convert.ToString(dttt.Rows[0][1]);
string UserID = Fn.ExenID("INSERT INTO TblHResources (EmpNo, CNIC, Full_Name, FatherName, DOB, Is_Male, CompanyID, DeptID, DesignationID, UserGroupID, ContactNos, U_Status, Qualification, Email, AppointmentDate, ResignationDate, Address, EnteryDate) VALUES ('" + en + "','" + d[1] + "','" + d[2] + "','" + d[3] + "','" + d[4] + "','" + d[5] + "','" + d[6] + "','" + d[7] + "','" + d[8] + "','" + d[9] + "','" + d[10] + "','" + d[11] + "','" + d[12] + "','" + d[13] + "','" + d[14] + "','" + d[15] + "','" + d[16] + "', Getdate()); Select Scope_Identity();");
Fn.Exec("DELETE FROM TblHResourcesLocations WHERE UserID=" + UserID);
foreach (var item in l)
{
Fn.Exec(@"INSERT INTO TblHResourcesLocations
(User_ID, LocID)
VALUES (" + UserID + "," + item + ")");
}
Fn.Exec(@"UPDATE TblHResources
SET U_Pass ='******' where User_ID=" + UserID);
Fn.Exec(@"INSERT INTO Login
(UserName, Password, Created_Date, User_Group_Id, Emp_Id, Login_Status, IP_Check)
VALUES ('" + eno + "' ,'" + Encryptor.Encrypt(eno) + "', GETDATE(),'" + d[9] + "','" + UserID + "', 1, 0)");
return(UserID);
}
else
{
Fn.Exec("UPDATE TblHResources SET CNIC = '" + d[1] + "', Full_Name = '" + d[2] + "', FatherName = '" + d[3] + "', DOB = '" + d[4] + "', Is_Male = '" + d[5] + "', CompanyID = '" + d[6] + "', DeptID = '" + d[7] + "', DesignationID = '" + d[8] + "', UserGroupID = '" + d[9] + "', ContactNos = '" + d[10] + "', U_Status = '" + d[11] + "', Qualification = '" + d[12] + "', Email = '" + d[13] + "', AppointmentDate = '" + d[14] + "', ResignationDate = '" + d[15] + "', Address = '" + d[16] + "' where User_ID = '" + d[17] + "'; Select Scope_Identity();");
Fn.Exec(@"UPDATE Login
SET User_Group_Id='" + d[9] + "' WHERE Emp_Id =" + d[17]);
Fn.Exec("DELETE FROM TblHResourcesLocations WHERE User_ID=" + d[17]);
List <TblHResourcesLocation> el = new List <TblHResourcesLocation>();
foreach (var item in l)
{
// Fn.Exec(@"INSERT INTO TblHResourcesLocations (User_ID, LocID) VALUES (" + d[17] + "," + item + ")");
if (item != "")
{
el.Add(new TblHResourcesLocation()
{
LocID = Convert.ToInt32(item), User_ID = Convert.ToInt32(d[17])
});
}
}
if (l.Length > 0)
{
using (DBDataContext db = new DBDataContext())
{
db.TblHResourcesLocations.InsertAllOnSubmit(el);
db.SubmitChanges();
}
}
return(d[17]);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
var frmdata = context.Request.Form["vls"];
var Province = context.Request.Form["Province"];
string[] d = frmdata.Split('½');
int benID = 0;
using (DBDataContext db = new DBDataContext())
{
if (db.TblHResources.Where(v => v.ContactNos == d[2]).Count() == 0)
{
TblHResource obj = new TblHResource();
obj.Full_Name = d[1];
obj.ContactNos = d[2];
obj.UserGroupID = Convert.ToInt32(d[4]);
obj.Email = d[5];
obj.U_Pass = Encryptor.Encrypt(d[6].Replace("'", ""));
obj.EnteryDate = DateTime.Now;
obj.U_Status = true;
obj.U_ThemeID = 1;
obj.Designation = d[3];
db.TblHResources.InsertOnSubmit(obj);
db.SubmitChanges();
benID = obj.User_ID;
//new Thread(() =>
//{
QR objQR = new QR();
objQR.QrGenerate(Convert.ToString(benID), "TblHResources", Convert.ToString(benID));
//string result = LongRunningMethod("World");
//Dispatcher.BeginInvoke((Action)();
//}).Start();
string[] l = Province.Split('½');
Fn.ExenID(@"INSERT INTO Login
(UserName, Password, Created_Date, User_Group_Id, Emp_Id, Login_Status, IP_Check)
VALUES ('" + d[2] + "' ,'" + Encryptor.Encrypt(d[6]) + "', GETDATE(),'" + d[4] + "','" + benID + "', 1, 0)");
foreach (var item in l)
{
Fn.Exec(@"INSERT INTO TblHResourcesLocations
(User_ID, LocID)
VALUES (" + benID + "," + item + ")");
}
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Record Already Exists");
}
}
if (context.Request.Files.Count > 0 && benID > 0)
{
HttpFileCollection SelectedFiles = context.Request.Files;
for (int i = 0; i < SelectedFiles.Count; i++)
{
HttpPostedFile PostedFile = SelectedFiles[i];
string FileName = context.Server.MapPath("~/Uploads/EmployeePhoto/" + PostedFile.FileName);
string Path = context.Server.MapPath("~/Uploads/EmployeePhoto/");
FileInfo fi = new FileInfo(FileName);
int fileID = benID;
using (DBDataContext db = new DBDataContext())
{
var o = db.TblHResources.Where(v => v.User_ID == fileID).FirstOrDefault();
if (o != null)
{
o.PhotoExtension = fi.Extension;
o.DisplayName = fi.Extension;
db.SubmitChanges();
}
}
PostedFile.SaveAs(Path + Convert.ToString(fileID) + 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(fileID) + fi.Extension, 32, 32);
string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(fileID) + "A" + 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(fileID) + fi.Extension, 75, 75);
string SaveAsThumbnail = System.IO.Path.Combine(context.Server.MapPath("~") + "/Uploads/EmployeePhoto/", Convert.ToString(fileID) + "B" + fi.Extension);
Thumbnail.Save(SaveAsThumbnail);
}
//using (DBDataContext db = new DBDataContext())
//{
// db.sp_RegisterEmpWithLogin(d[0], d[1], "", "", "", d[2], d[5], "", d[3], 1, 1, DateTime.Now, Encryptor.Encrypt(d[6].Replace("'", "")), Convert.ToInt32(d[4]), Convert.ToString(benID)+"."+ fi.Extension);
//}
context.Response.ContentType = "text/plain";
context.Response.Write("Record Saved");
}
}
else if (benID > 0)
{
//using (DBDataContext db = new DBDataContext())
//{
// db.sp_RegisterEmpWithLogin(d[0], d[1], "", "", "", d[2], d[5], "", d[3], 1, 1, DateTime.Now, Encryptor.Encrypt(d[6].Replace("'", "")), Convert.ToInt32(d[4]), null);
//}
context.Response.ContentType = "text/plain";
context.Response.Write("Record Saved");
}
//context.Response.ContentType = "text/plain";
//context.Response.Write("Files Uploaded Successfully!!");
}
catch (Exception ex)
{
context.Response.ContentType = "text/plain";
context.Response.Write(ex.Message);
}
}
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;
}
}
}
