public UserLogin ChangePassword(UserLoginRequest ul)
{
try
{
if (ul.UserPin.Trim() == "")
{
res.Message = "User cannot be blank";
res.Status = "Failure";
res.UserLoginResponse = ListView;
Ulr.UserId = "";
Ulr.UserPin = "";
ListView.Add(Ulr);
return(res);
}
else
{
if (ul.Password.Trim() != "")
{
string pass = string.Empty;
string passkey = string.Empty;
pass = DBsecurity.Encrypt(ul.Password.Trim(), ref passkey);
query = "SP_Login";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "APIUpdatePassword");
dbcommand.Parameters.AddWithValue("@UserPin", ul.UserPin);
dbcommand.Parameters.AddWithValue("@Password", pass);
dbcommand.Parameters.AddWithValue("@PasswordKey", passkey);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
res.Message = "Password has been changed";
res.Status = "success";
res.UserLoginResponse = ListView;
Ulr.UserId = "";
Ulr.UserPin = "";
ListView.Add(Ulr);
}
}
else
{
res.Message = "Password cannot be blank";
res.Status = "Failure";
res.UserLoginResponse = ListView;
Ulr.UserId = "";
Ulr.UserPin = "";
ListView.Add(Ulr);
}
}
}
catch (Exception ex)
{
res.Status = "Failure";
res.Message = ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(res);
}
public UserLogin Login(UserLoginRequest ul)
{
if (ul.UserPin.Trim() != "" && Validation.ValidateUserPin(ul.UserPin.Trim()) != true)
{
res.Message = "UserPin Must be 4 digit";
res.Status = "Failure";
res.UserLoginResponse = ListView;
Ulr.UserId = "";
Ulr.UserPin = "";
ListView.Add(Ulr);
return(res);
}
else
{
//bool Flag = true;
try
{
query = "SP_LoginWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UserAccess");
dbcommand.Parameters.AddWithValue("@UserPin", ul.UserPin);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
if (ul.UserPin.Trim() != "" && ul.Password != "")
{
//if (Convert.ToString(ds.Tables[0].Rows[0]["UserPin"]) == "0")
//{
// res.Message = "User has been disabled, please contact administrator!";
// res.Status = "Failure";
// res.UserLoginResponse = ListView;
// Ulr.UserId = "";
// Ulr.UserPin = "";
// ListView.Add(Ulr);
// return res;
//}
//else if (Convert.ToString(ds.Tables[0].Rows[0]["UserPin"]) == "-1")
//{
// res.Message = "Invalid User Pin!";
// res.Status = "Failure";
// res.UserLoginResponse = ListView;
// Ulr.UserId = "";
// Ulr.UserPin = "";
// ListView.Add(Ulr);
// return res;
//}
//else
//{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//bool IsLoginfirsttime = Convert.ToBoolean(ds.Tables[0].Rows[0]["LoginFlag"]);
string UserType = Convert.ToString(ds.Tables[0].Rows[0]["UserRoleID"]);
if (UserType == "1")
{
#region For Admin
string strDbPassword = DBsecurity.Decrypt(Convert.ToString(ds.Tables[0].Rows[0]["Password"]), Convert.ToString(ds.Tables[0].Rows[0]["PasswordKey"]));
if (strDbPassword.Trim() != ul.Password.Trim())
{
res.Message = "Wrong Password.";
res.Status = "Failure";
res.UserLoginResponse = ListView;
Ulr.UserPin = "";
Ulr.UserId = "";
ListView.Add(Ulr);
return(res);
}
//
else
{
res.Message = "Valid User.";
res.Status = "success";
res.UserLoginResponse = ListView;
Ulr.UserId = Convert.ToString(ds.Tables[0].Rows[0]["UserID"]);
Ulr.UserPin = "";
ListView.Add(Ulr);
return(res);
}
#endregion
}
else
{
//if (IsLoginfirsttime == true)
//{
// #region For First Time User Login
// string strDbPassword = DBsecurity.Decrypt(Convert.ToString(ds.Tables[0].Rows[0]["Password"]), Convert.ToString(ds.Tables[0].Rows[0]["PasswordKey"]));
// if (strDbPassword.Trim() != ul.Password.Trim())
// {
// res.Message = "Wrong Password.";
// res.Status = "Failure";
// res.UserLoginResponse = ListView;
// Ulr.UserId ="";
// Ulr.UserPin = "";
// ListView.Add(Ulr);
// return res;
// }
// else
// {
// res.Message = "Valid User.";
// res.Status = "success";
// res.UserLoginResponse = ListView;
// Ulr.UserId = Convert.ToString(ds.Tables[0].Rows[0]["UserID"]);
// Ulr.UserPin = "";
// ListView.Add(Ulr);
// return res;
// }
// #endregion
//}
//else
//{
#region For Current user
//if (Convert.ToString(ConfigurationManager.AppSettings["DefaultPassword"]) == ul.Password.Trim())
//{
res.Message = "Valid User.";
res.Status = "Success";
res.UserSiteInfo = UserMultipleSiteInfo;
foreach (DataRow row in ds.Tables[0].Rows)
{
UserMultipleSiteInfo UserMultipleSite = new UserMultipleSiteInfo();
UserMultipleSite.Site = row["AXSiteId"].ToString();
UserMultipleSite.WareHouse = row["WareHouseAX"].ToString();
UserMultipleSiteInfo.Add(UserMultipleSite);
}
res.UserLoginResponse = ListView;
Ulr.UserId = Convert.ToString(ds.Tables[0].Rows[0]["UserID"]);
Ulr.UserPin = ul.UserPin;
Ulr.IsMove = Convert.ToByte(ds.Tables[0].Rows[0]["IsMove"]);
Ulr.IsReportAsFinished = Convert.ToByte(ds.Tables[0].Rows[0]["IsReportAsFinished"]);
Ulr.IsQualityCheck = Convert.ToByte(ds.Tables[0].Rows[0]["IsQualityCheck"]);
Ulr.IsAssignedPlannedAndUnplanned = Convert.ToByte(ds.Tables[0].Rows[0]["IsAssignedPlannedAndUnplanned"]);
Ulr.IsPickAndCount = Convert.ToByte(ds.Tables[0].Rows[0]["IsPickAndCount"]);
Ulr.IsMergeStillage = Convert.ToByte(ds.Tables[0].Rows[0]["IsMergeStillage"]);
Ulr.IsReturnStillage = Convert.ToByte(ds.Tables[0].Rows[0]["IsReturnStillage"]);
Ulr.IsRecieveReturnStillage = Convert.ToByte(ds.Tables[0].Rows[0]["IsRecieveReturnStillage"]);
Ulr.IsLookUp = Convert.ToByte(ds.Tables[0].Rows[0]["IsLookUp"]);
Ulr.IsUpdateQty = Convert.ToByte(ds.Tables[0].Rows[0]["IsUpdateQty"]);
Ulr.IsProductionJournal = Convert.ToByte(ds.Tables[0].Rows[0]["IsProductionJournal"]);
Ulr.IsWorkOrderStartEnd = Convert.ToByte(ds.Tables[0].Rows[0]["IsWorkOrderStartEnd"]);
Ulr.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]);
Ulr.EmailId = Convert.ToString(ds.Tables[0].Rows[0]["EmailId"]);
ListView.Add(Ulr);
return(res);
//}
//else
//{
// res.Message = "Wrong Password.";
// res.Status = "Failure";
// res.UserLoginResponse = ListView;
// Ulr.UserId = "";
// Ulr.UserPin = "";
// ListView.Add(Ulr);
// return res;
//}
#endregion
//}
}
}
else
{
res.Message = "Invalid User.";
res.Status = "Failure";
res.UserLoginResponse = ListView;
Ulr.UserId = "";
Ulr.UserPin = "";
ListView.Add(Ulr);
return(res);
}
// }
}
else
{
res.Message = "Wrong User Pin or Password.";
res.Status = "Failure";
res.UserLoginResponse = ListView;
Ulr.UserId = "";
Ulr.UserPin = "";
ListView.Add(Ulr);
return(res);
}
}
catch (Exception ex)
{
res.Status = "Failure";
res.Message = ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(res);
}
}