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 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 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 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 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 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 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();
}
