public DataTable checkUser_authenticate(string useremailID, string userareaCode)
{
try
{
sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBCONN"].ConnectionString);
sqlConn.Open();
sqlCmd = new SqlCommand("[uservalidate_authentication]", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@useremailID", useremailID);
sqlCmd.Parameters.AddWithValue("@userareaCode", userareaCode);
sqlAdp = new SqlDataAdapter(sqlCmd);
sqlDS = new DataSet();
sqlAdp.Fill(sqlDS);
return(sqlDS.Tables[0]);
}
finally
{
sqlDS.Dispose();
sqlAdp.Dispose();
sqlCmd.Dispose();
sqlConn.Dispose();
objAuthentication = null;
}
}
public bool check_Authenticate_login(string useremailID, string userareaCode, string userareatype)
{
try
{
sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBCONN"].ConnectionString);
sqlConn.Open();
sqlCmd = new SqlCommand("[uservalidate_Login]", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@useremailID", useremailID);
sqlCmd.Parameters.AddWithValue("@userareaCode", userareaCode);
sqlCmd.Parameters.AddWithValue("@userareatype", userareatype);
sqlAdp = new SqlDataAdapter(sqlCmd);
sqlDS = new DataSet();
sqlAdp.Fill(sqlDS);
if (sqlDS.Tables[0].Rows.Count > 0)
{
HttpContext.Current.Session["usercode"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["usercode"]);
HttpContext.Current.Session["userfullname"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["username"]);
HttpContext.Current.Session["usermobile"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["usermobile"]);
HttpContext.Current.Session["useremailid"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["useremailid"]);
HttpContext.Current.Session["userid"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["userid"]);
HttpContext.Current.Session["userareacode"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["userareacode"]);
HttpContext.Current.Session["usertype"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["usertype"]);
HttpContext.Current.Session["userareatype"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["userareatype"]);
HttpContext.Current.Session["dpassword"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["userpassword"]);
//if (Convert.ToString(sqlDS.Tables[0].Rows[0]["userareatype"]).ToLower() != "dist" && Convert.ToString(sqlDS.Tables[0].Rows[0]["userareatype"]).ToLower() != "isr")
//{
// objAuthentication = new clsAuthentication();
// return objAuthentication.IsAuthenticated(System.Configuration.ConfigurationManager.AppSettings["DomainName"], username, password);
// //return true;
//}
//else
//{
// return true;
//}
return(true);
}
else
{
return(false);
}
}
finally
{
sqlDS.Dispose();
sqlAdp.Dispose();
sqlCmd.Dispose();
sqlConn.Dispose();
objAuthentication = null;
}
}
public bool checkUser(string username, string password, bool needADAuth = true)
{
try
{
sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DB_MFG"].ConnectionString);
sqlConn.Open();
sqlCmd = new SqlCommand("DM_SP_uservalidate", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@username", username);
sqlAdp = new SqlDataAdapter(sqlCmd);
sqlDS = new DataSet();
sqlAdp.Fill(sqlDS);
if (sqlDS.Tables[0].Rows.Count > 0)
{
HttpContext.Current.Session["USERID"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["USERID"]);
HttpContext.Current.Session["username"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["Username"]);
HttpContext.Current.Session["FullName"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["Full_Name"]);
HttpContext.Current.Session["Useremailid"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["Email_Address"]);
HttpContext.Current.Session["country"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["CountryName"]);
HttpContext.Current.Session["countryId"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["CountryId"]);
HttpContext.Current.Session["Role"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["Role"]);
HttpContext.Current.Session["RoleId"] = Convert.ToString(sqlDS.Tables[0].Rows[0]["RoleId"]);
objAuthentication = new clsAuthentication();
if (!needADAuth)
{
return(true);
}
else
{
//return objAuthentication.IsAuthenticated("", username, password);
return(true);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
finally
{
sqlDS.Dispose();
sqlAdp.Dispose();
sqlCmd.Dispose();
sqlConn.Dispose();
objAuthentication = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//redirect to the main page
if (clsSmallItemsHandler.SessionIdIsSet == false)
{
Response.Redirect("/");
}
//end
clsAuthentication authclass = new clsAuthentication();
clsProjects projects = new clsProjects();
var id = Request.QueryString["id"] == null?"" : Request.QueryString["id"];
var decoded_id = authclass.DecryptString(id);
//var session = HttpContext.Current.Session["user_id"];
//clsPrivateChat privateChat = new clsPrivateChat(session);
if (Request.Params["user_id"] != null)
{
var name = Request.Params["user_name"];
var user_id = Request.Params["user_id"];
var project_id = Request.Params["course_id"];
var time = Request.Params["time"].ToString().Replace("_", " ");
var message = Request.Params["message"];
projects.InsertMessage(name, user_id, project_id, time, message);
}
// undone there is an error on the line below
course_list = projects.current_project_chats(decoded_id);
user_id = HttpContext.Current.Session["user_id"];
user_name = HttpContext.Current.Session["user_name"];
}
public HttpResponseMessage Post([FromBody] LoginRequest request)
{
Login login = new Login();
clsAuthentication obj = new clsAuthentication();
try
{
bool b = obj.IsValidAdsUser("10.100.50.20", @"administrator", "Accer#Gril@30th");
//bool b = obj.IsValidAdsUser("1.6.102.130", @"192.168.60.1\Administrator", "Accer#Gril@20th");
// bool b = obj.IsValidAdsUser("1.6.102.130", @"" + request.Loginid + "", "" + request.Password + "");
//if (b)
// {
// var k = GInfraEntities.sp_login(request.Loginid, request.Password, request.MobileUniqueID).ToList();
// LoginResponse LoginResponse = new LoginResponse();
// foreach (var kp in k)
// {
// if (kp.Status == "true")
// {
// // var item = GInfraEntities.EmployeeMasters.Single(e => e.EmployeeId == request.Loginid);
// var item = (from p in GInfraEntities.EmployeeMasters
// join emp in GInfraEntities.MasterPasswords on p.EmployeeId equals emp.UserID
// where emp.UserID == request.Loginid
// select new
// {
// PayCode = p.PayCode,
// DateOfJoining = p.DateOfJoining,
// EmployeeId = p.EmployeeId,
// EmpName = p.EmpName,
// GuardianName = p.GuardianName,
// EmpEmailId = p.EmpEmailId,
// EmpMobile = p.EmpMobile,
// ReportingManger = p.ReportingManger,
// ReportingMangerEmail = p.ReportingMangerEmail,
// ReportingManagerMobile = p.ReportingManagerMobile,
// HRManager = p.HRManager,
// HRManagerEmail = p.HRManagerEmail,
// HRManagerMobile = p.HRManagerMobile,
// DateOfBirth = p.DateOfBirth,
// Company = p.Company,
// Department = p.Department,
// CAT = p.CAT,
// Section = p.Section,
// GradeCode = p.GradeCode,
// Branch = p.Branch,
// Designation = p.Designation,
// Sex = p.Sex,
// MobileCode = emp.Authtokenid
// }).FirstOrDefault();
// LoginResponse.PayCode =item.ToString();
// LoginResponse.DateOfJoining = item.DateOfJoining.ToString();
// LoginResponse.EmployeeId = item.EmployeeId.ToString();
// LoginResponse.EmpName = item.EmpName.ToString();
// LoginResponse.GuardianName = item.GuardianName.ToString();
// LoginResponse.EmpEmailId = item.EmpEmailId.ToString();
// LoginResponse.EmpMobile = item.EmpMobile.ToString();
// LoginResponse.ReportingManger = item.ReportingManger.ToString();
// LoginResponse.ReportingMangerEmail = item.ReportingMangerEmail.ToString();
// LoginResponse.ReportingManagerMobile = item.ReportingManagerMobile.ToString();
// LoginResponse.HRManager = item.HRManager.ToString();
// LoginResponse.HRManagerEmail = item.HRManagerEmail.ToString();
// LoginResponse.HRManagerMobile = item.HRManagerMobile.ToString();
// LoginResponse.DateOfBirth = item.DateOfBirth.ToString();
// LoginResponse.Company = item.Company.ToString();
// LoginResponse.Department = item.Department.ToString();
// LoginResponse.CAT = item.CAT.ToString();
// LoginResponse.Section = item.Section.ToString();
// LoginResponse.GradeCode = item.GradeCode.ToString();
// LoginResponse.Branch = item.Branch.ToString();
// LoginResponse.Designation = item.Designation.ToString();
// LoginResponse.Sex = item.Sex.ToString();
// LoginResponse.MobileCode = item.MobileCode.ToString();
// }
// else
// {
// login.Status = false;
// login.Message = "" + kp.Message + "";
// return Request.CreateResponse(HttpStatusCode.OK, login);
// }
// };
// }
if (request.MobileUniqueID != "" && request.Password != "" && request.Loginid != null && request.Password != null && request.MobileUniqueID != null)
{
var k = GInfraEntities.sp_login(request.Loginid, request.Password, request.MobileUniqueID, request.DeviceToken).ToList();
LoginResponse LoginResponse = new LoginResponse();
foreach (var kp in k)
{
if (kp.Status == "true")
{
//var item = GInfraEntities.EmployeeMasters.Single(e => e.EmployeeId == request.Loginid);
var item = (from p in GInfraEntities.EmployeeMasters
join emp in GInfraEntities.MasterPasswords on p.EmployeeId equals emp.UserID
where emp.UserID == request.Loginid
select new
{
DateOfJoining = p.DateOfJoining,
EmployeeId = p.EmployeeId,
EmpName = p.EmpName,
EmpEmailId = p.EmpEmailId,
EmpMobile = p.EmpMobile,
HRManagerEmail = p.HRManagerEmail,
HRManagerMobile = p.HRManagerMobile,
DateOfBirth = p.DateOfBirth,
Company = p.Company,
Department = p.Department,
GradeCode = p.GradeCode,
Branch = p.BUCode,
Designation = p.Designation,
Sex = p.Sex,
MobileCode = emp.Authtokenid,
managerid = p.MangerID,
MangerName = p.MangerName,
MangerEmail = p.MangerEmail,
ManagerMobile = p.ManagerMobile,
HRID = p.HRID,
HRName = p.HRName
}).FirstOrDefault();
LoginResponse.DateOfJoining = item.DateOfJoining.ToString();
LoginResponse.EmployeeId = item.EmployeeId.ToString();
LoginResponse.EmpName = item.EmpName.ToString();
LoginResponse.EmpEmailId = item.EmpEmailId.ToString();
LoginResponse.EmpMobile = item.EmpMobile.ToString();
LoginResponse.HRManagerEmail = item.HRManagerEmail.ToString();
LoginResponse.HRManagerMobile = item.HRManagerMobile.ToString();
LoginResponse.DateOfBirth = item.DateOfBirth.ToString();
LoginResponse.Company = item.Company.ToString();
LoginResponse.Department = item.Department.ToString();
LoginResponse.GradeCode = item.GradeCode.ToString();
LoginResponse.Branch = item.Branch.ToString();
LoginResponse.Designation = item.Designation.ToString();
LoginResponse.Sex = item.Sex.ToString();
LoginResponse.MobileCode = item.MobileCode.ToString();
LoginResponse.MangerName = item.MangerName.ToString();
LoginResponse.MangerEmail = item.MangerEmail.ToString();
LoginResponse.ManagerMobile = item.ManagerMobile.ToString();
LoginResponse.HRID = item.HRID.ToString();
LoginResponse.HRManagerEmail = item.HRManagerEmail.ToString();
LoginResponse.HRManagerMobile = item.HRManagerMobile.ToString();
LoginResponse.HRName = item.HRName.ToString();
if (item.managerid != null)
{
LoginResponse.MangerID = item.managerid.ToString();
}
else
{
LoginResponse.MangerID = "-";
}
string checkhead = "";
try
{
checkhead = (from n in GInfraEntities.EmployeeMasters
where n.MangerID.Equals(request.Loginid)
select n.EmployeeId).First();
}
catch
{
checkhead = null;
}
if (checkhead != null)
{
LoginResponse.ishead = "1";
}
else
{
LoginResponse.ishead = "0";
}
}
else
{
login.Status = false;
login.Message = "" + kp.Message + "";
return(Request.CreateResponse(HttpStatusCode.OK, login));
}
}
;
login.Data.Add(LoginResponse);
login.Status = true;
login.Message = "Login Successfully";
return(Request.CreateResponse(HttpStatusCode.OK, login));
}
else
{
login.Status = false;
login.Message = "" + HttpStatusCode.BadRequest + "";
return(Request.CreateResponse(HttpStatusCode.BadRequest, login));
}
}
catch (Exception ex)
{
login.Status = false;
login.Message = "" + ex + "";
return(Request.CreateResponse(HttpStatusCode.InternalServerError, login));
}
}
