public List <addUserVM> GetPendingUsers()
{
MECProjectDBEntities t = new MECProjectDBEntities();
List <addUserVM> og = new List <addUserVM>();
var s = t.Users.Where(x => x.userStatus == "pending");
foreach (var item in s)
{
addUserVM a = new addUserVM();
a.accountnumber = item.shopkeeper_bank_account;
a.bankbranch = item.shopkeeper_bank_branch;
a.bankname = item.shopkeeper_bank_name;
a.commission = Convert.ToInt32(item.shopkeeper_commission);
a.email = item.user_email;
a.password = item.user_password;
a.phone = item.user_phone;
a.shopaddress = item.shopkeeper_shopaddress;
a.shopname = item.shopkeeper_shopname;
a.username = item.user_name;
a.status = item.userStatus;
a.userId = item.user_ID;
og.Add(a);
}
return(og);
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
//context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" });
using (var db = new MECProjectDBEntities())
{
if (db != null)
{
User user = db.Users.Where(u => u.user_email == context.UserName && u.user_password == context.Password && u.userStatus != "pending").FirstOrDefault();
if (user != null)
{
Role userRole = db.Roles.Where(r => r.role_ID == user.role_ID).FirstOrDefault();
{
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim("Userid", user.user_ID.ToString()));
identity.AddClaim(new Claim("Username", user.user_name));
identity.AddClaim(new Claim("Email", user.user_email));
identity.AddClaim(new Claim("Phone", user.user_phone));
identity.AddClaim(new Claim("Roleid", user.role_ID.ToString()));
identity.AddClaim(new Claim("RoleName", userRole.role_name));
context.Validated(identity);
}
}
else
{
context.SetError("invalid_grant", "Provided username and password is incorrect.");
context.Rejected();
}
return;
}
}
}
public void updateOrdeComplaintStatus(complaintsGridVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
var dd = t.Complaints.First(x => x.complaint_ID == p.complaintId);
dd.complaint_status = p.status;
t.SaveChanges();
}
public Boolean deleteUser(User user)
{
MECProjectDBEntities t = new MECProjectDBEntities();
User userToDelete = t.Users.First(x => x.user_ID == user.user_ID);
t.Users.Remove(userToDelete);
t.SaveChanges();
return(true);
}
public void Delete(OrderGridVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
Order order = new Order();
order.dateOfOrder = p.dateOfOrder;
order.order_amount = p.order_amount;
order.order_status = p.order_status;
order.trackingId = p.trackingId;
order.order_ID = p.order_ID;
t.Orders.Attach(order);
t.Orders.Remove(order);
t.SaveChanges();
}
public void updateOrder(OrderVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
Order d = new Order();
var dd = t.Orders.First(x => x.order_ID == p.order_ID);
dd.clint_address = p.clint_address;
dd.clint_name = p.clint_name;
dd.clint_phone = p.clint_phone;
dd.order_amount = Convert.ToInt32(p.order_amount);
dd.order_ID = p.order_ID;
dd.service_ID = p.service_ID;
t.SaveChanges();
}
public List <User> getAllUsers(int roleId)
{
List <User> users = new List <User>();
if (roleId == 1)
{
MECProjectDBEntities t = new MECProjectDBEntities();
users = (from u in t.Users where u.userStatus != "pending" && u.role_ID == 3 select u).ToList();
return(users);
}
else
{
return(users);
}
}
public bool HasEmailRegistered(EmailModel email)
{
using (MECProjectDBEntities dal = new MECProjectDBEntities())
{
User user = (from u in dal.Users where u.user_email == email.emailid select u).FirstOrDefault();
if (user == null)
{
return(false);
}
else
{
return(true);
}
}
}
public bool updateUserDetails(User userNewDetails)
{
MECProjectDBEntities t = new MECProjectDBEntities();
User userToUpdate = t.Users.First(x => x.user_ID == userNewDetails.user_ID);
userToUpdate.shopkeeper_bank_account = userNewDetails.shopkeeper_bank_account.TrimEnd();
userToUpdate.shopkeeper_bank_branch = userNewDetails.shopkeeper_bank_branch.TrimEnd();
userToUpdate.shopkeeper_bank_name = userNewDetails.shopkeeper_bank_name.TrimEnd();
userToUpdate.shopkeeper_commission = userNewDetails.shopkeeper_commission.TrimEnd();
userToUpdate.user_phone = userNewDetails.user_phone.TrimEnd();
userToUpdate.shopkeeper_shopaddress = userNewDetails.shopkeeper_shopaddress.TrimEnd();
userToUpdate.shopkeeper_shopname = userNewDetails.shopkeeper_shopname.TrimEnd();
userToUpdate.user_name = userNewDetails.user_name.TrimEnd();
t.SaveChanges();
return(true);
}
public void updateOrderStatus(OrderGridVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
Order d = new Order();
var dd = t.Orders.First(x => x.order_ID == p.order_ID);
var id = Convert.ToInt32(dd.user_ID);
var user = t.Users.Where(x => x.user_ID == id).FirstOrDefault();
int commision = Convert.ToInt32(user.shopkeeper_commission);
int totalAmount = Convert.ToInt32(dd.order_amount);
int shopkeeperAmount = (totalAmount * commision) / 100;
int adminAmout = totalAmount - shopkeeperAmount;
dd.shopkeeper_amount = shopkeeperAmount;
dd.Admin_amount = adminAmout;
dd.order_status = p.order_status;
t.SaveChanges();
}
public List <complaintsGridVM> GetOrderComplaints(string status, int userId)
{
MECProjectDBEntities t = new MECProjectDBEntities();
List <complaintsGridVM> og = new List <complaintsGridVM>();
var objlist = t.sp_getOrdersComplaint(status, userId);
foreach (var item in objlist)
{
complaintsGridVM ogv = new complaintsGridVM();
ogv.complaintId = item.complaint_ID;
ogv.reason = item.order_resson;
ogv.status = item.complaint_status;
ogv.trackingId = item.complaint_field1;
og.Add(ogv);
}
return(og);
}
public bool updateProfileDetails(addUserVM updatedUserProfile)
{
MECProjectDBEntities t = new MECProjectDBEntities();
addUserVM profileModel = new addUserVM();
User userProfileToUpdate = t.Users.First(x => x.user_ID == updatedUserProfile.userId);
userProfileToUpdate.user_name = updatedUserProfile.username;
userProfileToUpdate.user_name = updatedUserProfile.username;
userProfileToUpdate.user_phone = updatedUserProfile.phone;
userProfileToUpdate.user_password = updatedUserProfile.password;
userProfileToUpdate.shopkeeper_shopname = updatedUserProfile.shopname;
userProfileToUpdate.shopkeeper_shopaddress = updatedUserProfile.shopaddress;
userProfileToUpdate.shopkeeper_bank_name = updatedUserProfile.bankname;
userProfileToUpdate.shopkeeper_bank_branch = updatedUserProfile.bankbranch;
userProfileToUpdate.shopkeeper_bank_account = updatedUserProfile.accountnumber;
t.SaveChanges();
return(true);
}
public addUserVM getProfileDetails(int id)
{
MECProjectDBEntities t = new MECProjectDBEntities();
addUserVM profileModel = new addUserVM();
var approvedShopkeeper = t.Users.First(x => x.user_ID == id);
profileModel.userId = approvedShopkeeper.user_ID;
profileModel.username = approvedShopkeeper.user_name;
profileModel.email = approvedShopkeeper.user_email;
profileModel.phone = approvedShopkeeper.user_phone;
profileModel.password = approvedShopkeeper.user_password;
profileModel.shopname = approvedShopkeeper.shopkeeper_shopname;
profileModel.shopaddress = approvedShopkeeper.shopkeeper_shopaddress;
profileModel.bankname = approvedShopkeeper.shopkeeper_bank_name;
profileModel.bankbranch = approvedShopkeeper.shopkeeper_bank_branch;
profileModel.accountnumber = approvedShopkeeper.shopkeeper_bank_account;
profileModel.commission = Convert.ToInt32(approvedShopkeeper.shopkeeper_commission);
return(profileModel);
}
public void updateUserStatus(addUserVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
User d = new User();
var dd = t.Users.First(x => x.user_ID == p.userId);
dd.userStatus = p.status;
t.SaveChanges();
//string url = "http://electricianpk.com";
//For to send an email at Gmail Starts: gmail ID: setting link: https://myaccount.google.com/lesssecureapps?pli=1
//var fromAddress = new MailAddress("*****@*****.**", "ElectricianPK");
//var toAddress = new MailAddress(dd.user_email, "ElectricianPK");
//const string fromPassword = "******";
//const string subject = "Your account has been Approved!";
//string body = "Dear " + dd.user_name + ", \r\n \r\n" +
// "This is to inform you that your account has been approved! " +
// "\r\n\r\nYour provided credentials are mentioned below:" +
// "\r\nEmail: " + dd.user_email +
// "\r\nPassword: "******"\r\n\r\nPlease signin with your given credentials at: " + url +
// "\r\n \r\n \r\n \r\nBest Regards,\r\n ElectricianPK Team";
//var smtp = new SmtpClient
//{
// Host = "smtp.gmail.com",
// Port = 587,
// EnableSsl = true,
// DeliveryMethod = SmtpDeliveryMethod.Network,
// Credentials = new NetworkCredential(fromAddress.Address, fromPassword),
// Timeout = 20000
//};
//using (var message = new MailMessage(fromAddress, toAddress)
//{
// Subject = subject,
// Body = body
//})
//{
// smtp.Send(message);
//}
//For to send an email at Gmail Ends
}
public string addOrderCompaint(addcomplaintsVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
var order = t.Orders.Where(x => x.trackingId == p.ordernumber).FirstOrDefault();
if (order != null)
{
Complaint d = new Complaint();
d.order_resson = p.reason;
d.complaint_field1 = p.ordernumber;// complaint_field1 IS THE tracking id of Order
d.order_ID = order.order_ID;
d.complaint_status = "pending";
d.complaint_field2 = p.userId.ToString();// complaint_field2 is the userId
t.Complaints.Add(d);
t.SaveChanges();
return("found");
}
else
{
return("notfound");
}
}
public void registerUser(addUserVM user)
{
MECProjectDBEntities t = new MECProjectDBEntities();
User u = new User();
u.shopkeeper_bank_account = user.accountnumber;
u.shopkeeper_bank_branch = user.bankbranch;
u.shopkeeper_bank_name = user.bankname;
u.shopkeeper_commission = user.commission.ToString();
u.shopkeeper_fname = user.username;
u.shopkeeper_shopaddress = user.shopaddress;
u.shopkeeper_shopname = user.shopname;
u.user_email = user.email;
u.user_name = user.username;
u.user_password = user.password;
u.user_phone = user.phone;
u.cnic = user.cnic;
u.city = user.city;
u.role_ID = 3;
u.userStatus = "pending";
t.Users.Add(u);
t.SaveChanges();
}
public List <OrderGridVM> GetOrders(string status, int userId)
{
MECProjectDBEntities t = new MECProjectDBEntities();
List <OrderGridVM> og = new List <OrderGridVM>();
var s = t.sp_GetOrdersGrid(status, userId);
foreach (var item in s)
{
OrderGridVM ogv = new OrderGridVM();
ogv.order_ID = item.order_ID;
ogv.dateOfOrder = Convert.ToDateTime(item.dateOfOrder);
ogv.order_amount = Convert.ToInt32(item.order_amount);
ogv.order_status = item.order_status;
ogv.trackingId = item.trackingId;
ogv.user_name = item.clint_name;
ogv.phone = item.clint_phone;
ogv.address = item.clint_address;
ogv.serviceId = Convert.ToInt32(item.service_ID);
ogv.shopkeeperName = item.user_name;
ogv.shopkeeperId = item.user_ID;
og.Add(ogv);
}
return(og);
}
public PaymentVML GetOrdersPaymentsByUser(UserPaymentModel upm)
{
MECProjectDBEntities t = new MECProjectDBEntities();
List <PaymentVM> og = new List <PaymentVM>();
PaymentVML pml = new PaymentVML();
string userId = upm.emailId;
string status = upm.status;
int adminTotal = 0;
int shopkeeperTotal = 0;
//string connectionString = "Data Source=(local);Initial Catalog=MECProjectDB;Integrated Security=true";
string connectionString = "data source=184.154.206.133; initial catalog=MECProjectDB;user id=MECProjectUser; password=$Default123";
using (SqlConnection connection =
new SqlConnection(connectionString))
{
// Create the Command and Parameter objects.
SqlCommand command = new SqlCommand("sp_OrdersPaymentByUsers", connection);
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.AddWithValue("@date", DateTime.Now);
command.Parameters.Add(new SqlParameter("@userId", SqlDbType.VarChar));
command.Parameters["@userId"].Value = userId;
if (status == "received")
{
command.Parameters.Add(new SqlParameter("@status", SqlDbType.VarChar));
command.Parameters["@status"].Value = "Completed";
}
else
{
command.Parameters.Add(new SqlParameter("@status", SqlDbType.VarChar));
command.Parameters["@status"].Value = status;
}
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
PaymentVM ogv = new PaymentVM();
if (reader != null)
{
ogv.order_ID = Convert.ToInt32(reader["order_ID"]);
ogv.dateOfOrder = Convert.ToDateTime(reader["dateOfOrder"]);
ogv.order_amount = Convert.ToInt32(reader["order_amount"]);
ogv.order_status = reader["order_status"].ToString();
ogv.trackingId = reader["trackingId"].ToString();
ogv.user_name = reader["clint_name"].ToString();
ogv.phone = reader["clint_phone"].ToString();
ogv.address = reader["clint_address"].ToString();
ogv.serviceId = Convert.ToInt32(reader["service_ID"]);
shopkeeperTotal = Convert.ToInt32(reader["totalShopkeerAmount"]);
try
{
if (reader["Admin_amount"] != null)
{
if (reader["Admin_amount"] != DBNull.Value)
{
ogv.Admin_amount = Convert.ToInt32(reader["Admin_amount"]);
}
}
}
catch (Exception)
{
}
try
{
if (reader["shopkeeper_amount"] != null)
{
if (reader["shopkeeper_amount"] != DBNull.Value)
{
ogv.shopkeeper_amount = Convert.ToInt32(reader["shopkeeper_amount"]);
}
}
}
catch (Exception)
{
}
ogv.adminTotal = adminTotal;
ogv.shopkeeperTotal = shopkeeperTotal;
og.Add(ogv);
}
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
pml.paymentList = og;
pml.adminTotal = adminTotal;
pml.shopkeeperTotal = shopkeeperTotal;
return(pml);
}
public void addOrder(OrderVM user)
{
string trackingid = "";
string trackingNumber = "";
var ss = DateTime.Now;
string year = ss.Year.ToString();
string month = ss.Month.ToString();
string day = ss.Day.ToString();
//string connectionString = "Data Source=(local);Initial Catalog=MECProjectDB;Integrated Security=true";
string connectionString = "data source=184.154.206.133; initial catalog=MECProjectDB;user id=MECProjectUser; password=$Default123";
using (SqlConnection connection =
new SqlConnection(connectionString))
{
// Create the Command and Parameter objects.
SqlCommand command = new SqlCommand("OrdertrackingNumber", connection);
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.AddWithValue("@date", DateTime.Now);
command.Parameters.Add(new SqlParameter("@date", SqlDbType.Date));
command.Parameters["@date"].Value = DateTime.Now;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
var comlumExist = HasColumn(reader, "order_ID");
if (comlumExist == true)
{
while (reader.Read())
{
if (reader != null)
{
var sss = reader["order_ID"];
var trackingNumbers = Convert.ToInt32(reader["order_number"]);
trackingNumbers = trackingNumbers + 1;
trackingNumber = trackingNumbers.ToString();
}
}
var length = trackingNumber.Length;
if (length == 1)
{
trackingNumber.Insert(0, "000");
trackingNumber = "000" + trackingNumber;
}
else if (length == 2)
{
trackingNumber.Insert(0, "00");
trackingNumber = "00" + trackingNumber;
}
else if (length == 3)
{
trackingNumber.Insert(0, "0");
trackingNumber = "0" + trackingNumber;
}
trackingid = year + "-" + month + "-" + day + "-" + trackingNumber;
}
else
{
trackingid = year + "-" + month + "-" + day + "-" + "0001";
trackingNumber = "0001";
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
MECProjectDBEntities tt = new MECProjectDBEntities();
Order o = new Order();
o.clint_name = user.clint_name;
o.clint_phone = user.clint_phone;
o.clint_address = user.clint_address;
o.order_amount = Convert.ToInt32(user.order_amount);
o.service_ID = user.service_ID;
o.dateOfOrder = DateTime.Now;
o.order_number = trackingNumber;
o.trackingId = trackingid;
o.user_ID = user.userId;
o.order_status = "pending";
tt.Orders.Add(o);
tt.SaveChanges();
}
