//retreive the username and password
private static VendorLoginViewModel GetUsernamePassword(decimal _VendorID)
{
VendorLoginViewModel details = new VendorLoginViewModel();
try
{
using (var context = new Entities())
{
var query = context.SOURCING_VENDOR_LOGIN_DETAILS.Where(m => m.VENDOR_ID == _VendorID).FirstOrDefault();
if (query != null)
{
details.USERNAME = query.USERNAME;
details.PASSWORD = query.PASSWORD;
return(details);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Logger.Log("Unable to retrieve vendor username and passowrd from SOURCING_VENDOR_LOGIN_DETAILS table. Error: " + ex.Message +
"------------------------------------------------" + ex.StackTrace,
"error");
return(null);
}
}
//if vendorId is null
public static string ProcessVendorEmail(decimal _VendorID, decimal _TempNo, string CompanyName, string UpdateVendor = null)
{
string contentPath = string.Empty;
if (UpdateVendor == null)
{
contentPath = AppDomain.CurrentDomain.BaseDirectory + @"\Template\content.txt";
}
else
{
contentPath = AppDomain.CurrentDomain.BaseDirectory + @"\Template\updatecontent.txt";
}
string content = System.IO.File.ReadAllText(contentPath);
VendorLoginViewModel vendor = new VendorLoginViewModel();
string query = "";
bool CheckLoginDetails = CheckVendorLoginDetails(_VendorID);
if (CheckLoginDetails == true)
{
vendor = GetUsernamePassword(_VendorID);
}
else
{
vendor = GenerateUsernamePassword(_VendorID);
}
using (var context = new Entities())
{
try
{
query = (from a in context.SOURCING_REF_TEMP_LINK
join b in context.SOURCING_REQUEST_TYPE
on a.REQ_TYPE equals b.REQUEST_ID
where a.TEMP_NO == _TempNo
select b.REQUEST_NAME).First().ToString();
}
catch (Exception ex)
{
Logger.Log("Error: " + ex.Message +
"------------------------------------------------" + ex.StackTrace,
"error");
return(null);
}
}
content = content.Replace("{RequestType}", query);
content = content.Replace("{username}", vendor.USERNAME);
content = content.Replace("{password}", vendor.PASSWORD);
content = content.Replace("{CompanyName}", CompanyName);
return(content);
}
private static VendorLoginViewModel GenerateUsernamePassword(decimal _VendorID)
{
SOURCING_VENDOR_LOGIN_DETAILS _vendor = new SOURCING_VENDOR_LOGIN_DETAILS();
VendorLoginViewModel vendor = new VendorLoginViewModel();
var context = new Entities();
vendor.USERNAME = "******" + _VendorID;
vendor.PASSWORD = Common.RandomChar(8) + _VendorID;
_vendor.USERNAME = vendor.USERNAME;
_vendor.PASSWORD = vendor.PASSWORD;
_vendor.VENDOR_ID = _VendorID;
context.SOURCING_VENDOR_LOGIN_DETAILS.Add(_vendor);
context.SaveChanges();
return(vendor);
}
public ActionResult VendorLogin(VendorLoginViewModel model)
{
try
{
if (ModelState.IsValid)
{
if (string.Compare(model.CRPUserName, "", false) == 0 && string.Compare(model.CRPPassWord, "", false) == 0)
{
ModelState.AddModelError("", "Enter User Name and Password");
}
else if (string.Compare(model.CRPUserName, "", false) == 0 && string.Compare(model.CRPPassWord, "", false) != 0)
{
ModelState.AddModelError("", "Enter User Name");
}
else if (!(string.Compare(model.CRPUserName, "", false) != 0 && string.Compare(model.CRPPassWord, "", false) == 0))
{
DateTime today = DateTime.Today;
string str = model.CRPUserName.Trim().ToLower();
string str1 = model.CRPPassWord.Trim().ToLower();
string[] strArrays1 = str.Split(' ');
string[] strArrays2 = str1.Split(' ');
string str2 = strArrays1[0];
string str3 = strArrays2[0];
if (!(string.Compare(str2, "select", false) == 0 || string.Compare(str2, "exec", false) == 0 || string.Compare(str2, "execute", false) == 0 || string.Compare(str2, "drop", false) == 0 || string.Compare(str2, "truncate", false) == 0 || string.Compare(str2, "insert", false) == 0 || string.Compare(str2, "update", false) == 0 || string.Compare(str2, "delete", false) == 0 || string.Compare(str2, "union", false) == 0 || string.Compare(str2, "create", false) == 0)
)
{
if (!(string.Compare(str3, "select", false) == 0 || string.Compare(str3, "exec", false) == 0 || string.Compare(str3, "execute", false) == 0 || string.Compare(str3, "drop", false) == 0 || string.Compare(str3, "truncate", false) == 0 || string.Compare(str3, "insert", false) == 0 || string.Compare(str3, "update", false) == 0 || string.Compare(str3, "delete", false) == 0 || string.Compare(str2, "union", false) == 0 || string.Compare(str2, "create", false) == 0)
)
{
string UserName = model.CRPUserName.Trim();
string UserPassword = model.CRPPassWord.Trim();
string encPassword = clsCommonMethods.PasswordEncrypt(model.CRPPassWord.Trim());
VendorUserLoggedViewModel loggedUser = new VendorUserLoggedViewModel();
try
{
loggedUser = repoAccount.GetVendorUserLoggedDetails(UserName, encPassword);
}
catch (Exception exception1)
{
ViewBag.ErrorMsg = exception1.Message;
clsCommonMethods.ErrorLog(Server.MapPath("~\\ErrorLogs\\Logfiles"), exception1.Message, exception1.StackTrace);
}
if (loggedUser == null)
{
var activWebUsers = repoAccount.GetAllActiveVendorUsers();
foreach (var webUser in activWebUsers)
{
if (!(webUser.CRPUserName.Trim() == UserName) || !(webUser.CRPPassWord.Trim() != encPassword))
{
continue;
}
Session["Counter"] = Convert.ToInt32(Session["Counter"]) + 1;
break;
}
if (!(Convert.ToInt32(Session["Counter"]) >= 3))
{
ViewBag.ErrorMsg = "Login Failed.Try Again!";
clsCommonMethods.UserLog(Server.MapPath("~\\ErrorLogs\\Unauthorized_UserLog"), UserName, UserPassword, "Vendor");
return(View());
}
else
{
Session["Counter"] = 0;
UpdateVendorUserBlockStatusViewModel userBlocked = new UpdateVendorUserBlockStatusViewModel();
userBlocked.UserID = UserName;
userBlocked.BlockedDate = DateTime.Now;
userBlocked.Status = 3;
repoAccount.BlockedVendorUser(userBlocked);
repoAccount.SaveChanges();
ViewBag.ErrorMsg = "User has been Blocked, Please contact to Administrator!";
Session.Abandon();
return(View());
}
}
else
{
Session["UserName"] = UserName;
Session["VendorLoginRowID"] = loggedUser.VendorLoginRowID;
Session["VendorRowID"] = loggedUser.VendorRowID;
Session["VendorName"] = loggedUser.VendorName;
Session["VendorEmaiID"] = loggedUser.VendorEmaiID;
Session["ContactPerson"] = loggedUser.ContactPerson;
Session["MobileNo"] = loggedUser.MobileNo;
Session["UserType"] = loggedUser.UserType;
Session["CreatedBy"] = loggedUser.CreatedBy;
Session["Valid"] = 1;
if (Convert.ToInt32(Session["Valid"]) == 1)
{
DateTime dateTime = DateTime.Today;
TimeSpan TimeSinceCreation = new TimeSpan();
if (loggedUser.ModifiedTime != null)
{
TimeSinceCreation = dateTime.Subtract(loggedUser.ModifiedTime.Value);
}
else
{
TimeSinceCreation = dateTime.Subtract(loggedUser.CreatedTime.Value);
}
if (TimeSinceCreation.Days > 179)
{
ViewBag.ErrorMsg = "Your password has expired. Please contact your Administrator!";
Session.Abandon();
return(View());
}
else if (TimeSinceCreation.Days < 0)
{
clsCommonMethods.UserLog(Server.MapPath("~\\ErrorLogs\\Unauthorized_UserLog"), UserName, UserPassword, "Vendor");
ViewBag.ErrorMsg = "Invalid login. Please Try again!";
Session.Abandon();
return(View());
}
}
AddUserLoggedInDetailViewModel loggedInDetails = new AddUserLoggedInDetailViewModel();
loggedInDetails.LoginName = loggedUser.VendorName;
if (loggedUser.UserType == 0)
{
loggedInDetails.LoginType = "Vendor";
}
else
{
loggedInDetails.LoginType = "Vendor's User";
}
loggedInDetails.LoginId = UserName;
loggedInDetails.LoginBy = "Vendor";
loggedInDetails.IPDetails = Request.UserHostAddress;
loggedInDetails.LoginDate = DateTime.Now;
loggedInDetails.LoginStatus = 1;
Session["LoginDetailRowID"] = repoAccount.AddUserLoggedInDetails(loggedInDetails);
}
FormsAuthentication.SetAuthCookie(UserName, false);
return(RedirectToAction("Index", "Home", new { area = "Partner" }));
}
}
}
else
{
ModelState.AddModelError("", "Enter Password");
}
}
else
{
var query = from state in ModelState.Values
from error in state.Errors
select error.ErrorMessage;
var errorList = query.ToList();
string strError = string.Empty;
foreach (string str in errorList)
{
strError += str + "\n";
}
ModelState.AddModelError("", strError);
}
}
catch (Exception Ex)
{
ViewBag.ErrorMsg = Ex.Message;
clsCommonMethods.ErrorLog(Server.MapPath("~\\ErrorLogs\\Logfiles"), Ex.Message, Ex.StackTrace);
}
return(View());
}
