public static Customers UpdateUser(int userID, string fname, string lname, int dob, int ssn, string address)
{
CustomersDAL dal = new CustomersDAL();
var account = dal.UpdateUser(userID, fname, lname, dob, ssn, address);
return(account);
}
public static List <Customers> GetAll()
{
CustomersDAL dal = new CustomersDAL();
var customers = dal.GetAll();
return(customers);
}
public static Customers Get(int Issn, string Iflname, string Ilname)
{
CustomersDAL dal = new CustomersDAL();
var customer = dal.Get(Issn, Iflname, Ilname);
return(customer);
}
public static Customers Get(int userID)
{
CustomersDAL dal = new CustomersDAL();
var customer = dal.Get(userID);
return(customer);
}
public JsonResult SubmitReservation(string ho_ten = "", string sdt = "", string service = "")
{
CustomersDAL cus = new CustomersDAL("Customers");
var stt = false;
var msg = "";
try
{
var CreatedAt = Clibs.DatetimeToTimestamp(DateTime.Now);
cus.InsertCustomer(ho_ten, sdt, service, CreatedAt);
//https://www.google.com/recaptcha/api/siteverify
/* {
* "success": true|false,
* "challenge_ts": timestamp, // timestamp of the challenge load (ISO format yyyy-MM-dd'T'HH:mm:ssZZ)
* "hostname": string, // the hostname of the site where the reCAPTCHA was solved
* "error-codes": [...] // optional
* }
*/
stt = true;
msg = "Đăng ký thành công!";
}
catch (Exception ex)
{
stt = false;
msg = ex.Message;
// var e = ex.Message;
}
return(Json(new
{
status = stt,
message = msg
}));
}
/// <summary>
/// Configuring the customer.
/// </summary>
private void GetInfoAboutCustomer()
{
WriteLineWithSpecColor("What is your name?");
string name = Console.ReadLine();
while (!ValidateName(name))
{
WriteLineWithSpecColor("What is your name?");
name = Console.ReadLine();
}
_customer.FirstName = name;
WriteLineWithSpecColor("What is your surname?");
string surname = Console.ReadLine();
while (!ValidateName(surname))
{
WriteLineWithSpecColor("What is your surname?");
surname = Console.ReadLine();
}
_customer.Surname = surname;
CustomersDAL cDAL = new CustomersDAL();
int id = new int();
cDAL.TryGetID(_customer.FirstName, _customer.Surname, out id);
_customer.ID = id;
GetInfoAboutEmail();
}
public async Task <Customer> GetCustomer(int id)
{
using (CustomersDAL dal = new CustomersDAL())
{
return(await dal.GetCustomer(id));
}
}
public List <CustomerEntity> GetCustomerList()
{
ICustomersDAL customerDAL = new CustomersDAL();
List <CustomerEntity> result = customerDAL.GetCustomerList();
return(result);
}
public void Create(Customers newCustomer)
{
// Call the DAL to create a new record.
CustomersDAL customerDAL = new CustomersDAL();
customerDAL.Create(newCustomer);
}
public List <CatagoryType> GetCustomerType()
{
ICustomersDAL customerDAL = new CustomersDAL();
List <CatagoryType> result = customerDAL.GetCustomerType();
return(result);
}
public IQueryable <Customer> GetCustomers()
{
using (CustomersDAL dal = new CustomersDAL())
{
return(dal.GetCustomers());
}
}
public List <CatagoryType> GetCategoryType(string filter)
{
ICustomersDAL customerDAL = new CustomersDAL();
List <CatagoryType> result = customerDAL.GetCategoryType(filter);
return(result);
}
/// <summary>
/// Gets all customer.
/// </summary>
/// <returns>Get All Customer</returns>
public List <Customer> GetAllCustomer()
{
ICustomersDAL customerDAL = new CustomersDAL();
List <Customer> result = customerDAL.GetAllCustomer();
return(result);
}
public bool CustomerExists(int id)
{
using (CustomersDAL dal = new CustomersDAL())
{
return(dal.CustomerExists(id));
}
}
public List <CatagoryType> GetCategoryType(string filter)
{
ICustomersDAL customerDAL = new CustomersDAL();
List <CatagoryType> result = customerDAL.GetCategoryType(filter);
//foreach(var item in result)
//{
// item.Cat_Contents_Display = Convert.ToDecimal(item.Cat_Contents).ToString("N", new CultureInfo(SharedValues.CurrencyName));
//}
return(result);
}
public int UpdateCustomer(Customers cus)
{
if (Session["user"] == null)
{
return(-1000);
}
if (!PowerDAL.HasPower((Session["user"] as Users).RoleID.Value, 8))
{
return(-1001);
}
return(CustomersDAL.Update(cus));
}
public V_Customers LoadCustomerByID(int cusID)
{
if (Session["user"] == null)
{
return(null);
}
if (!PowerDAL.HasPower((Session["user"] as Users).RoleID.Value, 8))
{
return(null);
}
return(CustomersDAL.LoadCustomerByID(cusID));
}
public PagingList <V_Customers> LoadCustomerPage(int pageSize, int pageIndex, string cusID, string cusName)
{
if (Session["user"] == null)
{
return(null);
}
if (!PowerDAL.HasPower((Session["user"] as Users).RoleID.Value, 8))
{
return(null);
}
return(CustomersDAL.LoadPaging(pageSize, pageIndex, cusID, cusName));
}
public bool Register(string Name, string Username, string Password)
{
Boolean isRegistered = false;
CustomersDAL objdal = new CustomersDAL();
if (!objdal.checkExistCust(Username))
{
if (objdal.Register(Name, Username, Password) > 0)
{
isRegistered = true;
}
}
return(isRegistered);
}
public async Task <int> DeleteCustomer(int id)
{
if (CustomerExists(id))
{
using (CustomersDAL dal = new CustomersDAL())
{
return(await dal.DeleteCustomer(id));
}
}
else
{
return(0);
}
}
public async Task <int> PostCustomer(Customer customer)
{
if (CustomerExists(customer.Id))
{
using (CustomersDAL dal = new CustomersDAL())
{
return(await dal.PostCustomer(customer));
}
}
else
{
return(0);
}
}
public Customer Verify_Login(string Username, string Password)
{
CustomersDAL objdal = new CustomersDAL();
DataTable dt = objdal.Login(Username, Password);
Customer customer;
if (dt.Rows.Count > 0)
{
customer = new Customer(dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(),
dt.Rows[0][3].ToString(), Convert.ToChar(dt.Rows[0][4].ToString()) /*[0]*/, (int)dt.Rows[0][5]);
return(customer);
}
return(null);
}
public async Task <int> PutCustomer(int id, Customer customer)
{
if (!CustomerExists(id))
{
using (CustomersDAL dal = new CustomersDAL())
{
return(await dal.PutCustomer(id, customer));
}
}
else
{
return(0);
}
}
public int AddAdmin(string Username)
{
CustomersDAL objdal = new CustomersDAL();
if (!objdal.checkExistCust(Username))
{
return(1); //not exist
}
else
{
if (objdal.AddAdmin(Username))
{
return(0);
}
else
{
return(2);
}
}
}
public List <UI.Entities.Country> AutoFillCountry()
{
int autoId = 1;
List <UI.Entities.Country> countryList;
ICustomersDAL customerDAL = new CustomersDAL();
List <string> strlist = customerDAL.GetAutoFillData("country");
countryList = new List <UI.Entities.Country>();
if (strlist != null)
{
foreach (string name in strlist)
{
UI.Entities.Country lst = new UI.Entities.Country();
lst.CountryID = autoId;
lst.Name = name;
countryList.Add(lst);
autoId++;
}
}
return(countryList);
}
public List <City> AutoFillCity()
{
int autoId = 1;
List <City> cityList;
ICustomersDAL customerDAL = new CustomersDAL();
List <string> strlist = customerDAL.GetAutoFillData("city");
cityList = new List <City>();
if (strlist != null)
{
foreach (string name in strlist)
{
City lst = new City();
lst.CityID = autoId;
lst.Name = name;
cityList.Add(lst);
autoId++;
}
}
return(cityList);
}
public List <PostalCode> AutoFillPostalCode()
{
int autoId = 1;
List <PostalCode> postalcodeList;
ICustomersDAL customerDAL = new CustomersDAL();
List <string> strlist = customerDAL.GetAutoFillData("postalcode");
postalcodeList = new List <PostalCode>();
if (strlist != null)
{
foreach (string name in strlist)
{
PostalCode lst = new PostalCode();
lst.PostalCodeID = autoId;
lst.Name = name;
postalcodeList.Add(lst);
autoId++;
}
}
return(postalcodeList);
}
public List <UI.Entities.State> AutoFillState()
{
int autoId = 1;
List <UI.Entities.State> stateList;
ICustomersDAL customerDAL = new CustomersDAL();
List <string> strlist = customerDAL.GetAutoFillData("state");
stateList = new List <UI.Entities.State>();
if (strlist != null)
{
foreach (string name in strlist)
{
UI.Entities.State lst = new UI.Entities.State();
lst.StateID = autoId;
lst.Name = name;
stateList.Add(lst);
autoId++;
}
}
return(stateList);
}
/// <summary>
/// Cofiguring info about e-Mail.
/// </summary>
private void GetInfoAboutEmail()
{
string eMail = string.Empty;
CustomersDAL cDAL = new CustomersDAL();
WriteLineWithSpecColor("Do you have e-Mail?");
if (GetSimpleUserAnswer())
{
WriteLineWithSpecColor(@"You may subscribe on our notifications such as:
pick order, successfully pay for the order and deliver order,
but we need your email address.
What your email address?");
eMail = Console.ReadLine();
while (!IsValidEmail(eMail))
{
_botMoodState++;
WriteLineWithSpecColor("Wrong e-Mail format");
eMail = Console.ReadLine();
}
_customer.Email = eMail;
cDAL.ReWriteEmail(_customer.FirstName, _customer.Surname, _customer.Email);
_notificator = SendEmail;
}
else
{
if (cDAL.IsMailFilled(_customer.FirstName, _customer.Surname, out eMail) && eMail != string.Empty)
{
WriteLineWithSpecColor($"Oh we found your email in DB. That means you were here before. We will use this e-Mail: {eMail}");
_notificator = SendEmail;
}
else
{
WriteLineWithSpecColor("Unfortunately you can't receive notifications.");
}
}
_customer.Email = eMail;
}
public ActionResult GetCustomersSearch(string searchKey)
{
List<CustomersViewModel> models = CustomersDAL.GetDataSearch(searchKey);
return PartialView("_ListCustomers", models);
}