public void MakeOtherfalse(int userId)
{
using (EcommGroceryDataContext db = new EcommGroceryDataContext())
{
var some = db.AddressDetails.Where(r => r.UserId == userId).ToList();
some.ForEach(a => a.IsDefault = false);
db.SaveChanges();
}
}
public override bool IsUserInRole(string username, string roleName)
{
using (EcommGroceryDataContext dataContext = new EcommGroceryDataContext())
{
return((from u in dataContext.Users
join
r in dataContext.Roles on u.RoleId equals r.RoleId
where u.UserName == username && r.RoleName == roleName
select u).Any());
}
}
public override string[] GetRolesForUser(string username)
{
using (EcommGroceryDataContext dataContext = new EcommGroceryDataContext())
{
string[] roles = null;
roles = (from c in dataContext.Users
join
r in dataContext.Roles on c.RoleId equals r.RoleId
where c.UserName == username
select r.RoleName).ToArray();
return(roles);
}
}
public override string[] GetUsersInRole(string roleName)
{
string[] userId = { "0" };
using (EcommGroceryDataContext dataContext = new EcommGroceryDataContext())
{
int userRoleId = (from c in dataContext.Roles
where c.RoleName == roleName
select c.RoleId).FirstOrDefault();
int siteUserId = (from c in dataContext.Users
where c.RoleId == userRoleId
select c.UserId).FirstOrDefault();
userId[0] = siteUserId.ToString();
}
return(userId);
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
try
{
Button btn = (Button)sender;
if (btn != null)
{
int transactionId = Convert.ToInt32(btn.CommandArgument);
using (EcommGroceryDataContext dbContext = new EcommGroceryDataContext())
{
TransactionDetails transactionDetails = dbContext.TransactionDetails.Where(r => r.TransactionId == transactionId).FirstOrDefault();
if (btn.CommandName.Equals("Confirm"))
{
transactionDetails.ConfirmationDate = DateTime.Now;
transactionDetails.IsConfirm = true;
}
else
{
transactionDetails.ConfirmationDate = DateTime.Now;
transactionDetails.IsConfirm = false;
}
dbContext.SaveChanges();
}
lblMsg.Visible = true;
if (btn.CommandName.Equals("Confirm"))
{
lblMsg.ForeColor = Color.Green;
lblMsg.Text = "Order of customer is confirmed.";
}
else
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = "Order of customer is rejected.";
}
}
BindTransacionList(0, Convert.ToInt32(ddlStatus.SelectedValue.Trim()), gvTransactionDetails);
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.ForeColor = Color.Red;
lblMsg.Text = ex.Message.ToString();
}
}
public override bool ValidateUser(string username, string password)
{
bool isFound = false;
using (EcommGroceryDataContext dataContext = new EcommGroceryDataContext())
{
var users = dataContext.Users.Where(r => r.UserName == username && r.Password == password && r.Status == true && r.IsDeleted == false).FirstOrDefault();
if (users != null)
{
isFound = true;
users.LastLoginDate = System.DateTime.Now;
users.IPAddres = Utilities.GetIPAddress;
}
dataContext.SaveChanges();
}
return(isFound);
}
public static int GetUserId(string userName)
{
int siteUserId = 0;
if (HttpContext.Current.User.Identity.Name == userName)
{
return(GetUserId());
}
else
{
using (EcommGroceryDataContext dataContext = new EcommGroceryDataContext())
{
siteUserId = (from s in dataContext.Users
where s.UserName == userName
select s.UserId).FirstOrDefault();
}
return(siteUserId);
}
}
public static int GetUserId()
{
int userId = 0;
int.TryParse(GetSessionValue(SessionManager.UserId), out userId);
if (userId > 0)
{
return(userId);
}
else
{
string userName = HttpContext.Current.User.Identity.Name;
using (EcommGroceryDataContext dataContext = new EcommGroceryDataContext())
{
userId = (from s in dataContext.Users
where s.UserName == userName
select s.UserId).FirstOrDefault();
HttpContext.Current.Session[SessionManager.UserId] = userId;
}
return(userId);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string activationCode = !string.IsNullOrEmpty(Request.QueryString["ActivationCode"]) ? Request.QueryString["ActivationCode"] : Guid.Empty.ToString();
using (EcommGroceryDataContext dataContext = new EcommGroceryDataContext())
{
var users = (from c in dataContext.Users
where c.ActivationCode == activationCode
select c).FirstOrDefault();
if (users != null)
{
users.Status = true;
dataContext.SaveChanges();
Response.Redirect("Login.aspx?st=1");
}
else
{
Response.Redirect("Login.aspx?st=0");
}
}
}
}
public AreaRepository()
{
dataContext = new EcommGroceryDataContext();
}
public CountryRepository()
{
dataContext = new EcommGroceryDataContext();
}
public MasterCategoryRepository()
{
dataContext = new EcommGroceryDataContext();
}
public AddressRepository()
{
dataContext = new EcommGroceryDataContext();
}
public SubCategoryMasterRepository()
{
dataContext = new EcommGroceryDataContext();
}
public UserRepository(string userName)
{
dataContext = new EcommGroceryDataContext();
_User = new UserModel();
_User.SetUserProperties(userName);
}
public UserRepository(int userId)
{
dataContext = new EcommGroceryDataContext();
_User = new UserModel();
_User.SetUserProperties(userId);
}
