public void AddEmployeeAccount(UserProfileView user)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
//User Table
User U = new User();
U.Username = user.Username;
U.Password = user.Password;
db.Users.Add(U);
db.SaveChanges();
//UserProfile Table
UserProfile UP = new UserProfile();
UP.UserID = U.UserID;
UP.FirstName = user.FirstName;
UP.LastName = user.LastName;
UP.Gender = user.Gender;
UP.BirthDate = Convert.ToDateTime(user.BirthDate);
UP.Mobile = user.Mobile;
UP.Email = user.Email;
UP.RoleID = 2;
db.UserProfiles.Add(UP);
db.SaveChanges();
}
}
public void AddUserAccount(UserSignUpView user)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
//User Table
User U = new User();
U.Username = user.Username;
U.Password = user.Password;
db.Users.Add(U);
db.SaveChanges();
//UserProfile Table
UserProfile UP = new UserProfile();
UP.UserID = U.UserID;
UP.FirstName = user.FirstName;
UP.LastName = user.LastName;
UP.Gender = user.Gender;
UP.BirthDate = user.BirthDate;
UP.Mobile = user.Mobile;
UP.Email = user.Email;
UP.RoleID = 3;
db.UserProfiles.Add(UP);
db.SaveChanges();
CustomerUser CU = new CustomerUser();
CU.UserID = U.UserID;
CU.Active = true;
db.CustomerUsers.Add(CU);
db.SaveChanges();
}
}
public ProfileView ViewProfile()
{
var username = HttpContext.Current.User.Identity.Name;
var userid = GetUserID(username);
using (CMSProjectEntities db = new CMSProjectEntities())
{
ProfileView PV = new ProfileView();
var user = db.Users.Where(o => o.UserID.Equals(userid)).FirstOrDefault();
var userprofile = db.UserProfiles.Where(o => o.UserID.Equals(userid)).FirstOrDefault();
//User
PV.UserID = user.UserID;
PV.Username = user.Username;
PV.Password = user.Password;
//UserProfile
PV.UserProfileID = userprofile.UserProfileID;
PV.UserID = userprofile.UserID;
PV.FirstName = userprofile.FirstName;
PV.LastName = userprofile.LastName;
PV.Gender = userprofile.Gender;
PV.BirthDate = userprofile.BirthDate;
PV.Email = userprofile.Email;
PV.Mobile = userprofile.Mobile;
PV.RoleID = userprofile.RoleID;
return(PV);
}
}
public void UpdateUserAccount(UserProfileView user)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
//User Table
User U = new User();
U.UserID = user.UserID;
U.Username = user.Username;
U.Password = user.Password;
db.Entry(U).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//UserProfile Table
UserProfile UP = new UserProfile();
UP.UserProfileID = user.UserProfileID;
UP.UserID = U.UserID;
UP.FirstName = user.FirstName;
UP.LastName = user.LastName;
UP.Gender = user.Gender;
UP.BirthDate = Convert.ToDateTime(user.BirthDate);
UP.Mobile = user.Mobile;
UP.Email = user.Email;
UP.RoleID = user.RoleID;
db.Entry(UP).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public List <ComplaintView> GetMyComplaintViews(int id)
{
List <ComplaintView> complaints = new List <ComplaintView>();
using (CMSProjectEntities db = new CMSProjectEntities())
{
var comp = db.Complaints.ToList();
foreach (Complaint c in comp)
{
ComplaintView CV = new ComplaintView();
CV.ComplaintID = c.ComplaintID;
CV.CustomerID = c.CustomerID;
CV.EmployeeID = c.EmployeeID.GetValueOrDefault();
CV.Description = c.Description;
CV.ComplaintStatusID = c.ComplaintStatusID;
var compstat = db.ComplaintStatusLookups.Where(o => o.ComplaintStatusID.Equals(CV.ComplaintStatusID)).FirstOrDefault();
CV.ComplaintStatus = compstat.Status;
if (CV.CustomerID.Equals(id))
{
complaints.Add(CV);
}
}
}
return(complaints);
}
public void UpdateProfile(ProfileView PV)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
User user = new User();
user.UserID = PV.UserID;
user.Username = PV.Username;
user.Password = PV.Password;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
UserProfile UP = new UserProfile();
UP.UserProfileID = PV.UserProfileID;
UP.UserID = PV.UserID;
UP.RoleID = PV.RoleID;
UP.FirstName = PV.FirstName;
UP.LastName = PV.LastName;
UP.Gender = PV.Gender;
UP.BirthDate = Convert.ToDateTime(PV.BirthDate);
UP.Email = PV.Email;
UP.Mobile = PV.Mobile;
db.Entry(UP).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
FormsAuthentication.SetAuthCookie(PV.Username, false);
}
}
public bool IsUserNameExist(string userName)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
return(db.Users.Where(o => o.Username.Equals(userName)).Any());
}
}
public bool IsEmailExist(string eMail)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
return(db.UserProfiles.Where(i => i.Email.Equals(eMail)).Any());
}
}
public ActionResult CheckBranchExists(string pin, string id)
{
int bid = Convert.ToInt32(id);
using (CMSProjectEntities db = new CMSProjectEntities())
{
List <BranchList> blist = new List <BranchList>();
blist = db.BranchLists.ToList();
if (blist.Where(o => o.Pincode.Equals(pin)).Any())
{
var branch = blist.Where(o => o.Pincode.Equals(pin)).FirstOrDefault();
if (branch.BranchID.Equals(bid))
{
return(Json(true));
}
else
{
return(Json(false));
}
}
else
{
return(Json(true));
}
}
}
public ActionResult Delete(int id)
{
UserManager UM = new UserManager();
UserProfileView UPV = new UserProfileView();
UPV = UM.GetAllUserProfiles().Where(o => o.UserProfileID.Equals(id)).FirstOrDefault();
using (CMSProjectEntities db = new CMSProjectEntities())
{
UserProfile userProfile = new UserProfile();
userProfile.UserProfileID = UPV.UserProfileID;
userProfile.UserID = UPV.UserID;
userProfile.FirstName = UPV.FirstName;
userProfile.LastName = UPV.LastName;
userProfile.Gender = UPV.Gender;
userProfile.BirthDate = Convert.ToDateTime(UPV.BirthDate);
userProfile.Email = UPV.Email;
userProfile.Mobile = UPV.Mobile;
userProfile.RoleID = UPV.RoleID;
db.Entry(userProfile).State = EntityState.Deleted;
db.SaveChanges();
CMSProject.Models.DB.User user = new User();
user.UserID = userProfile.UserID;
user.Username = UPV.Username;
user.Password = UPV.Password;
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult doesUserNameExist(string UserName)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
bool isValid = !db.Users.ToList().Exists(p => p.Username.Equals(UserName, StringComparison.CurrentCultureIgnoreCase));
return(Json(isValid));
}
}
public JsonResult doesEmailExist(string Email)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
bool isValid = !db.UserProfiles.ToList().Exists(p => p.Email.Equals(Email, StringComparison.CurrentCultureIgnoreCase));
return(Json(isValid));
}
}
public JsonResult CheckUsername(string username, string email, string id)
{
int userid = Convert.ToInt32(id);
int isValid;
using (CMSProjectEntities db = new CMSProjectEntities())
{
List <User> userlist = db.Users.ToList();
List <UserProfile> profilelist = db.UserProfiles.ToList();
var check = userlist.Where(o => o.Username.Equals(username, StringComparison.CurrentCultureIgnoreCase));
var checke = profilelist.Where(o => o.Email.Equals(email, StringComparison.CurrentCultureIgnoreCase));
if (check.Any())
{
if (check.FirstOrDefault().UserID == userid)
{
if (checke.Any())
{
if (checke.FirstOrDefault().UserID == userid)
{
isValid = 1;
}
else
{
isValid = 3;
}
}
else
{
isValid = 1;
}
}
else
{
isValid = 2;
}
}
else
{
if (checke.Any())
{
if (checke.FirstOrDefault().UserID == userid)
{
isValid = 1;
}
else
{
isValid = 3;
}
}
else
{
isValid = 1;
}
}
}
return(Json(isValid));
}
public List <Branches> GetAllBranches()
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
var branches = db.BranchLists.Select(o => new Branches
{
BranchID = o.BranchID
}).ToList();
return(branches);
}
}
public OrderUpdateView CreateOUView(int id)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
var OrderList = db.CustomerOrders.ToList();
CustomerOrder order = db.CustomerOrders.Where(o => o.OrderID.Equals(id)).FirstOrDefault();
OrderUpdateView orders = new OrderUpdateView();
//Orders
orders.OrderID = order.OrderID;
orders.CustomerID = order.CustomerID;
orders.OrderDate = order.OrderDate;
if (order.ShippedDate.HasValue)
{
orders.ShippedDate = order.ShippedDate.GetValueOrDefault();
}
else
{
orders.ShippedDate = null;
}
orders.PickupAddressID = order.PickupAddressID;
orders.ShippingAddressID = order.ShippingAddressID;
orders.Weight = order.Weight;
orders.OrderValue = order.OrderValue;
//Tracking
orders.TrackingID = db.TrackingTBLs.Where(o => o.OrderID.Equals(orders.OrderID)).FirstOrDefault().TrackingID;
orders.PickupBranchID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(orders.TrackingID)).FirstOrDefault().PickupBranchID.GetValueOrDefault();
orders.ShippingBranchID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(orders.TrackingID)).FirstOrDefault().ShippingBranchID.GetValueOrDefault();
orders.OrderStatusID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(orders.TrackingID)).FirstOrDefault().OrderStatusID;
//Payment
orders.PaymentID = db.PaymentTBLs.Where(o => o.OrderID.Equals(orders.OrderID)).FirstOrDefault().PaymentID;
if (db.PaymentTBLs.Where(o => o.PaymentID.Equals(orders.PaymentID)).FirstOrDefault().PaymentDate.HasValue)
{
orders.PaymentDate = db.PaymentTBLs.Where(o => o.PaymentID.Equals(orders.PaymentID)).FirstOrDefault().PaymentDate.GetValueOrDefault();
}
else
{
orders.PaymentDate = null;
}
orders.PaymentStatusID = db.PaymentTBLs.Where(o => o.PaymentID.Equals(orders.PaymentID)).FirstOrDefault().PaymentStatusID;
//Extras
var paddr = db.Addresses.Where(o => o.AddressID.Equals(orders.PickupAddressID)).FirstOrDefault();
orders.PickupAddress = paddr.StreetAddress + ", " + paddr.City + ", " + paddr.State + " - " + paddr.Pincode;
var saddr = db.Addresses.Where(o => o.AddressID.Equals(orders.ShippingAddressID)).FirstOrDefault();
orders.ShippingAddress = saddr.StreetAddress + ", " + saddr.City + ", " + saddr.State + " - " + saddr.Pincode;
orders.Branches = GetActiveBranchesViews();
return(orders);
}
}
public int GetUserID(string userName)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
var user = db.Users.Where(o => o.Username.Equals(userName));
if (user.Any())
{
return(user.FirstOrDefault().UserID);
}
}
return(0);
}
public void AddBranch(BranchesView BV)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
BranchList branch = new BranchList();
branch.StreetAddress = BV.StreetAddress;
branch.City = BV.City;
branch.State = BV.State;
branch.Pincode = BV.Pincode;
branch.Active = true;
db.BranchLists.Add(branch);
db.SaveChanges();
}
}
public void UpdateOrder(OrderUpdateView OUV)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
CustomerOrder CO = new CustomerOrder();
CO.OrderID = OUV.OrderID;
CO.CustomerID = OUV.CustomerID;
CO.OrderDate = OUV.OrderDate;
if (OUV.ShippedDate.HasValue)
{
CO.ShippedDate = OUV.ShippedDate;
}
else
{
CO.ShippedDate = null;
}
CO.PickupAddressID = OUV.PickupAddressID;
CO.ShippingAddressID = OUV.ShippingAddressID;
CO.Weight = OUV.Weight;
CO.OrderValue = OUV.OrderValue;
db.Entry(CO).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
PaymentTBL pay = new PaymentTBL();
pay.PaymentID = OUV.PaymentID;
pay.Value = CO.OrderValue;
if (OUV.PaymentDate.HasValue)
{
pay.PaymentDate = OUV.PaymentDate;
}
else
{
pay.PaymentDate = null;
}
pay.PaymentStatusID = OUV.PaymentStatusID;
pay.OrderID = CO.OrderID;
db.Entry(pay).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
TrackingTBL tracking = new TrackingTBL();
tracking.TrackingID = OUV.TrackingID;
tracking.PickupBranchID = OUV.PickupBranchID;
tracking.ShippingBranchID = OUV.ShippingBranchID;
tracking.OrderStatusID = OUV.OrderStatusID;
tracking.OrderID = CO.OrderID;
db.Entry(tracking).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void UpdateBranch(BranchesView BV)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
BranchList branch = new BranchList();
branch.BranchID = BV.BranchID;
branch.StreetAddress = BV.StreetAddress;
branch.City = BV.City;
branch.State = BV.State;
branch.Pincode = BV.Pincode;
branch.Active = (bool)BV.Active;
db.Entry(branch).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public string GetUserPassword(string userName)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
var user = db.Users.Where(o => o.Username.ToLower().Equals(userName));
if (user.Any())
{
return(user.FirstOrDefault().Password);
}
else
{
return(string.Empty);
}
}
}
public void UpdateComplaint(ComplaintView CV)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
var emp = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault();
Complaint currComplaint = new Complaint();
currComplaint.ComplaintID = CV.ComplaintID;
currComplaint.CustomerID = CV.CustomerID;
currComplaint.Description = CV.Description;
currComplaint.ComplaintStatusID = CV.ComplaintStatusID;
currComplaint.EmployeeID = emp.UserID;
db.Entry(currComplaint).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void PlaceOrder(PlaceOrderView POV)
{
Address paddr = new Address();
Address saddr = new Address();
using (CMSProjectEntities db = new CMSProjectEntities())
{
paddr.StreetAddress = POV.PickupAddressSA;
paddr.City = POV.PickupAddressCity;
paddr.State = POV.PickupAddressState;
paddr.Pincode = POV.PickupAddressPincode;
saddr.StreetAddress = POV.ShippingAddressSA;
saddr.City = POV.ShippingAddressCity;
saddr.State = POV.ShippingAddressState;
saddr.Pincode = POV.ShippingAddressPincode;
db.Addresses.Add(paddr);
db.SaveChanges();
db.Addresses.Add(saddr);
db.SaveChanges();
User user = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault();
CustomerUser CU = db.CustomerUsers.Where(o => o.UserID.Equals(user.UserID)).FirstOrDefault();
CustomerOrder CO = new CustomerOrder();
CO.CustomerID = CU.CustomerID;
CO.OrderDate = DateTime.Now;
CO.ShippedDate = null;
CO.PickupAddressID = db.Addresses.Where(o => o.StreetAddress.Equals(paddr.StreetAddress)).FirstOrDefault().AddressID;
CO.ShippingAddressID = db.Addresses.Where(o => o.StreetAddress.Equals(saddr.StreetAddress)).FirstOrDefault().AddressID;
CO.Weight = POV.Weight;
CO.OrderValue = POV.OrderValue;
db.CustomerOrders.Add(CO);
db.SaveChanges();
TrackingTBL tracking = new TrackingTBL();
tracking.OrderStatusID = 0;
tracking.OrderID = CO.OrderID;
db.TrackingTBLs.Add(tracking);
db.SaveChanges();
PaymentTBL pay = new PaymentTBL();
pay.Value = CO.OrderValue;
pay.PaymentDate = null;
pay.PaymentStatusID = 1;
pay.OrderID = CO.OrderID;
db.PaymentTBLs.Add(pay);
db.SaveChanges();
}
}
public Complaint AddOrUpdateComplaint(ComplaintView CV, int i)
{
Complaint comp = new Complaint();
using (CMSProjectEntities db = new CMSProjectEntities())
{
if (i == 1)
{
comp.Description = CV.Description;
var user = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault();
int cid = db.CustomerUsers.Where(o => o.UserID.Equals(user.UserID)).FirstOrDefault().CustomerID;
comp.CustomerID = cid;
comp.ComplaintStatusID = 1;
}
return(comp);
}
}
public List <OrdersView> GetMyOrders(int id)
{
List <OrdersView> orders = GetOrdersViews();
List <OrdersView> myOrders = new List <OrdersView>();
using (CMSProjectEntities db = new CMSProjectEntities())
{
var user = db.CustomerUsers.Where(o => o.UserID.Equals(id)).FirstOrDefault();
foreach (OrdersView order in orders)
{
if (order.CustomerID.Equals(user.CustomerID))
{
myOrders.Add(order);
}
}
return(myOrders);
}
}
public List <OrdersView> GetOrdersViews()
{
List <OrdersView> OV = new List <OrdersView>();
using (CMSProjectEntities db = new CMSProjectEntities())
{
var OrderList = db.CustomerOrders.ToList();
foreach (CustomerOrder order in OrderList)
{
OrdersView ordersView = new OrdersView();
ordersView.OrderID = order.OrderID;
ordersView.CustomerID = order.CustomerID;
ordersView.OrderDate = order.OrderDate.ToString("yyyy-MM-dd");
if (order.ShippedDate.HasValue)
{
ordersView.ShippedDate = order.ShippedDate.GetValueOrDefault().ToString("yyyy-MM-dd");
}
else
{
ordersView.ShippedDate = null;
}
ordersView.PickupAddressID = order.PickupAddressID;
ordersView.ShippingAddressID = order.ShippingAddressID;
ordersView.Weight = (float)order.Weight;
ordersView.OrderValue = (float)order.OrderValue;
var cust = db.CustomerUsers.Where(o => o.CustomerID.Equals(ordersView.CustomerID)).FirstOrDefault();
var userp = db.UserProfiles.Where(o => o.UserID.Equals(cust.UserID)).FirstOrDefault();
ordersView.CustomerName = userp.FirstName + " " + userp.LastName;
var paddr = db.Addresses.Where(o => o.AddressID.Equals(ordersView.PickupAddressID)).FirstOrDefault();
ordersView.PickupAddress = paddr.StreetAddress + ", " + paddr.City + ", " + paddr.State + " - " + paddr.Pincode;
var saddr = db.Addresses.Where(o => o.AddressID.Equals(ordersView.ShippingAddressID)).FirstOrDefault();
ordersView.ShippingAddress = saddr.StreetAddress + ", " + saddr.City + ", " + saddr.State + " - " + saddr.Pincode;
ordersView.TrackingID = db.TrackingTBLs.Where(o => o.OrderID.Equals(ordersView.OrderID)).FirstOrDefault().TrackingID;
ordersView.OrderStatusID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(ordersView.TrackingID)).FirstOrDefault().OrderStatusID;
ordersView.OrderStatus = db.OrderStatusLookups.Where(o => o.OrderStatusID.Equals(ordersView.OrderStatusID)).FirstOrDefault().Status;
ordersView.PaymentID = db.PaymentTBLs.Where(o => o.OrderID.Equals(ordersView.OrderID)).FirstOrDefault().PaymentID;
ordersView.PaymentStatusID = db.PaymentTBLs.Where(o => o.PaymentID.Equals(ordersView.PaymentID)).FirstOrDefault().PaymentStatusID;
ordersView.PaymentStatus = db.PaymentStatusLookups.Where(o => o.PaymentStatusID.Equals(ordersView.PaymentStatusID)).FirstOrDefault().Status;
OV.Add(ordersView);
}
return(OV);
}
}
