protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
entities = new CustomerEntities();
}
}
public JsonResult SaveCustomer(CustomerViewModel customer)
{
using (var db = new CustomerEntities())
{
var cus = db.Customers.Find(customer.ID);
if (cus != null)
{
cus.Name = customer.Name;
cus.Address = customer.Address;
cus.Phone = customer.Phone;
if (db.SaveChanges() > 0)
{
return(Json(new { status = "success", response = cus }));
}
else
{
return(Json(new { status = "failed", reason = "could not save" }));
}
}
else
{
return(Json(new { status = "failed", reason = "not found" }));
}
}
}
public IEnumerable <Customer> Get()
{
using (CustomerEntities entities = new CustomerEntities())
{
return(entities.Customer.ToList());
}
}
public void Validate(CustomerEntities cust)
{
if (Regex.IsMatch(cust.CustomerName, "^[a-zA-Z]$") == false)
{
throw new InvalidStringException("not a valid name");
}
if (Regex.IsMatch(cust.CustomerAddress, @"^[0-9]+\s+([a-zA-Z]+|[a-zA-Z]+\s[a-zA-Z]+)$") == false)
{
throw new InvalidStringException("not a valid address");
}
if (Regex.IsMatch(cust.CustomerMobile, @"\+?[0-9]{10}") == false)
{
throw new InvalidStringException("not a valid mobile");
}
if (Regex.IsMatch(cust.CustomerEmail, @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$") == false)
{
throw new InvalidStringException("not a valid email");
}
if (Regex.IsMatch(cust.CustomerPan, @"^([A - Z]{ 5}\d{ 4}[A-Z]{1})$") == false)
{
throw new InvalidStringException("not a valid pan ");
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
var Cus = new CustomerEntities();
Cus.Name = txtName.Text;
Cus.IDCardNumber = int.Parse(txtIDCardNumber.Text);
Cus.Phone = txtPhone.Text;
Cus.Address = txtAddress.Text;
if (rbNam.Checked)
{
Cus.Sex = true;
}
else
{
Cus.Sex = false;
}
CusPro.Create(Cus);
this.Close();
new ManageBill();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public Customer Get(int id)
{
using (CustomerEntities entities = new CustomerEntities())
{
return(entities.Customer.FirstOrDefault(e => e.Id == id));
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,IdCode,FullName,PhoneNumber,Address,Gender,Status")] CustomerEntities customerEntities)
{
if (id != customerEntities.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(customerEntities);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerEntitiesExists(customerEntities.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(customerEntities));
}
public ActionResult Search(CustomerVM customerVmValue)
{
using (var db = new CustomerEntities())
{
var customerSearchResults = from customerRec in db.Customers
where ((customerVmValue.Name == null) || (customerRec.Name == customerVmValue.Name.Trim())) &&
((customerVmValue.City == null) || (customerRec.City == customerVmValue.City.Trim())) &&
((customerVmValue.State == null) || (customerRec.State == customerVmValue.State.Trim()))
select new
{
Name = customerRec.Name
,
City = customerRec.City
,
State = customerRec.State
};
List <Customer> lstCustomer = new List <Customer>();
foreach (var record in customerSearchResults)
{
Customer customerValue = new Customer();
customerValue.Name = record.Name;
customerValue.City = record.City;
customerValue.State = record.State;
lstCustomer.Add(customerValue);
}
customerVmValue.Customers = lstCustomer;
return(View(customerVmValue));
}
}
public CustomerEntities GetCustomerByCustomerID_DAL(string CustomerID)
{
try
{
foreach (CustomerEntities cust in Customers)
{
if (cust.CustomerID.Equals(CustomerID) == true)
{
Console.WriteLine("Customer Name :-" + cust.CustomerName);
Console.WriteLine("Customer Address :-" + cust.CustomerAddress);
Console.WriteLine("Customer Mobile no :-" + cust.CustomerMobile);
Console.WriteLine("Customer Email :-" + cust.CustomerEmail);
Console.WriteLine("Customer Pan :-" + cust.CustomerPan);
return(cust);
}
}
//if customerID not found
CustomerEntities c = new CustomerEntities();
return(c);
}
catch (Exception e)
{
CustomerEntities c = new CustomerEntities();
return(c);
}
}
public CustomerEntities GetCustomerByCustomerID_DAL(string CustomerID)
{
bool validate = false;
try
{
CustomerEntities customerEntitiesTemporary = new CustomerEntities();
List <CustomerEntities> custlist = DeserializeFromJSON("Customerdata.txt"); //we have to search customer through CustomerID
foreach (CustomerEntities cust in custlist) //foreach will search the list
{
if (cust.CustomerID.Equals(CustomerID) == true)
{
validate = true;
customerEntitiesTemporary = cust;
break;
}
}
if (validate != true)
{
throw new CustomerDoesNotExistException("Customer Not available based on given CustomerID");
}
//if customerID not found
return(customerEntitiesTemporary);
}
catch (Exception e)
{
CustomerEntities c = new CustomerEntities();
return(c);
}
}
public PartialViewResult UserList()
{
CustomerEntities db = new CustomerEntities();
List <CustomerInformation> user = db.CustomerInformations.ToList();
return(PartialView(user));
}
public ActionResult Index(int?page)
{
var pageNumber = page ?? 1;
var pageSize = 2;
using (var db = new CustomerEntities())
{
//var cust = db.Database.SqlQuery<Customer>("Select * from customer").ToList();
//var customersList = db.Customers.OrderBy(x => x.Id).Select(x => new CustomerViewModel
//{
// ID = x.Id,
// Name = x.Name,
// Address = x.Address,
// Phone = x.Phone
//}).ToPagedList(pageNumber, pageSize);
var customersList = db.Customers.OrderBy(x => x.Id).ToPagedList(pageNumber, pageSize);
var model = new GridViewModel
{
Customers = customersList
};
return(View(model));
}
}
public async Task <Customer> CreateOrUpdateAsync(Customer customer)
{
Customer record = null;
using (var db = new CustomerEntities())
{
if (customer.Id != 0)
{
record = db.Customers.SingleOrDefault(c => c.Id == customer.Id);
if (record != null)
{
record.FirstName = customer.FirstName;
record.LastName = customer.LastName;
record.PhoneNumber = customer.PhoneNumber;
record.Email = customer.Email;
await db.SaveChangesAsync();
}
}
else
{
record = db.Customers.Create();
record.FirstName = customer.FirstName;
record.LastName = customer.LastName;
record.Email = customer.Email;
record.PhoneNumber = customer.PhoneNumber;
db.Customers.Add(record);
await db.SaveChangesAsync();
}
return(record);
}
}
public ActionResult Create(CustomerEntities xct)
{
CustomerServices cs = new CustomerServices();
cs.Create(xct);
return(View());
}
public async Task <ActionResult> ViewCustomer(int Id)
{
CustomerEntities customers = (await new nuDirectApiController().GetAllCustomers()).FirstOrDefault(x => x.CustomerId == Id);
ViewBag.Endpoints = (await new nuDirectApiController().GetAllEndpoints()).Where(x => x.CustomerId == customers.CustomerId);
return(View(customers));
}
public int AddCustomer(CustomerEntities ce)
{
var res = (from c in dbEntites.Employees
where c.Pan == ce.Pan
select c).Count();
var res2 = (from c in dbEntites.Customers
where c.Pan == ce.Pan
select c).Count();
if (res > 0 || res2 > 0)
{
return(0);
}
else
{
var cd = dbEntites.Customers.OrderByDescending(t => t.CustId).FirstOrDefault();
if (cd == null)
{
ce.CustId = "MLA10001";
}
else
{
ce.CustId = "MLA" + (Convert.ToInt32(cd.CustId.Substring(3, 5)) + 1).ToString();
}
Customer c = new Customer()
{
CustId = ce.CustId,
CustName = ce.CustName,
Pan = ce.Pan,
Dob = ce.Dob,
Password = ce.Password,
Status = true,
Email = ce.Email
};
dbEntites.Customers.Add(c);
var ac = dbEntites.SavingsAccounts.OrderByDescending(t => t.Accountid).FirstOrDefault();
if (ac == null)
{
ce.Accountid = "SB10001";
}
else
{
ce.Accountid = "SB" + (Convert.ToInt32(ac.Accountid.Substring(2, 5)) + 1).ToString();
}
SavingsAccount sac = new SavingsAccount()
{
Accountid = ce.Accountid,
CustId = ce.CustId,
Balance = ce.balance
};
dbEntites.SavingsAccounts.Add(sac);
dbEntites.SaveChanges();
return(1);
}
}
public IHttpActionResult RegisterCustomer(CustomerEntities model)
{
try
{
using (var ts = new TransactionScope())
{
if (model == null)
{
response.Data = null;
response.Error = true;
response.Message = "Error, Empty model";
return(Content(HttpStatusCode.BadRequest, response));
}
else
{
Customer customer = new Customer();
if (context.Customer.FirstOrDefault(x => x.Username == model.Username) != null)
{
response.Data = null;
response.Error = true;
response.Message = "Error, Existing customer";
return(Content(HttpStatusCode.BadRequest, response));
}
else
{
context.Customer.Add(customer);
customer.Names = model.Names;
customer.LastNames = model.LastNames;
customer.DocumentIdentity = model.DocumentIdentity;
customer.Password = CipherLogic.Cipher(CipherAction.Encrypt, CipherType.UserPassword, model.Password);
customer.BirthdayDate = model.Birthday;
customer.Username = model.Username;
customer.Status = ConstantHelpers.Status.ACTIVE;
customer.DepartmentId = model.DepartmentId;
customer.ProvinceId = model.ProvinceId;
customer.DistrictId = model.DistrictId;
customer.Phone = model.Phone;
context.SaveChanges();
response.Data = null;
response.Error = false;
response.Message = "Success, saved customer";
}
ts.Complete();
}
}
return(Ok(response));
}
catch (Exception ex)
{
return(Unauthorized());
}
}
public JsonResult CheckEmail(Customer customer)
{
bool answer;
using (CustomerEntities cEntity = new CustomerEntities())
{
var email = cEntity.Customers.Where(x=>x.email == customer.email).FirstOrDefault();
answer = (email != null) ? false : true;
}
return Json(answer, JsonRequestBehavior.AllowGet);
}
public bool AddCustomerBL(CustomerEntities cust)
{
CustomerBL customer = new CustomerBL();
Validate(cust);
CustomerDAL obj = new CustomerDAL();
return(obj.AddCustomerDAL(cust));
}
private static void SetDbHTTPContext()
{
DbContext dbContext = new CustomerEntities();
//dbContext.Database.Log = (sql) =>
//{
// System.IO.File.AppendText(HostingEnvironment.MapPath(@"~\App_Data\logs.txt"));
//};
HttpContext.Current.Items[Repositories.FieldKey.DB_CONTEXT_KEY] = dbContext;
}
/// <summary>
/// Load data method.
/// </summary>
/// <returns>Returns - Data</returns>
private List <SalesOrderDetail> LoadData()
{
// Initialization.
List <SalesOrderDetail> lst = new List <SalesOrderDetail>();
CustomerEntities ctx = new CustomerEntities();
lst = ctx.SalesOrderDetails.ToList();
try
{
// Initialization.
//string line = string.Empty;
//string srcFilePath = "Content/files/SalesOrderDetail.txt";
//var rootPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
//var fullPath = Path.Combine(rootPath, srcFilePath);
//string filePath = new Uri(fullPath).LocalPath;
//StreamReader sr = new StreamReader(new FileStream(filePath, FileMode.Open, FileAccess.Read));
//// Read file.
//while ((line = sr.ReadLine()) != null)
//{
// // Initialization.
// SalesOrderDetail infoObj = new SalesOrderDetail();
// string[] info = line.Split(',');
// // Setting.
// infoObj.Sr = Convert.ToInt32(info[0].ToString());
// infoObj.OrderTrackNumber = info[1].ToString();
// infoObj.Quantity = Convert.ToInt32(info[2].ToString());
// infoObj.ProductName = info[3].ToString();
// infoObj.SpecialOffer = info[4].ToString();
// infoObj.UnitPrice = Convert.ToDecimal(info[5].ToString());
// infoObj.UnitPriceDiscount = Convert.ToDecimal(info[6].ToString());
// // Adding.
// lst.Add(infoObj);
// ctx.SalesOrderDetails.Add(infoObj);
//}
//ctx.SaveChanges();
// Closing.
//sr.Dispose();
//sr.Close();
}
catch (Exception ex)
{
// info.
Console.Write(ex);
}
// info.
return(lst);
}
public async Task <IActionResult> Create([Bind("Id,IdCode,FullName,PhoneNumber,Address,Gender,Status")] CustomerEntities customerEntities)
{
if (ModelState.IsValid)
{
_context.Add(customerEntities);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(customerEntities));
}
public string Add(CustomerInformation model)
{
CustomerEntities db = new CustomerEntities();
CustomerInformation cs = new CustomerInformation();
cs.Name = model.Name;
cs.Surname = model.Surname;
db.CustomerInformations.Add(cs);
db.SaveChanges();
return("1");
}
public async Task <List <Customer> > ListAllAsync()
{
List <Customer> customers = new List <Customer>();
using (var db = new CustomerEntities())
{
customers = await db.Customers.ToListAsync();
}
return(customers);
}
public static void CustomerEFPageTest()
{
//using (var context = new CustomerEntities())
//{
// // 删除之前的数据
// context.Database.ExecuteSqlCommand("delete from Chapter3.Customer");
// // 添加新的测试数据
// context.Customers.Add(new Customer
// {
// Name = "Roberts, Jill",
// Email = "*****@*****.**"
// });
// context.Customers.Add(new Customer
// {
// Name = "Robertson, Alice",
// Email = "*****@*****.**"
// });
// context.Customers.Add(new Customer
// {
// Name = "Rogers, Steven",
// Email = "*****@*****.**"
// });
// context.Customers.Add(new Customer
// {
// Name = "Roe, Allen",
// Email = "*****@*****.**"
// });
// context.Customers.Add(new Customer
// {
// Name = "Jones, Chris",
// Email = "*****@*****.**"
// });
// context.SaveChanges();
//}
using (var context = new CustomerEntities())
{
string match = "Ro";
int pageIndex = 1;
int pageSize = 3;
var customers = context.Customers.Where(m => m.Name.Contains(match))
.OrderBy(m => m.Name)
.Skip(pageIndex * pageSize)
.Take(pageSize);
Console.WriteLine("Customers Ro*");
foreach (var customer in customers)
{
Console.WriteLine("{0} [email: {1}]", customer.Name, customer.Email);
}
}
}
public ActionResult Search()
{
using (var db = new CustomerEntities())
{
var customer = db.Customers.ToList();
var data = new CustomerVM()
{
Customers = customer
};
return(View(data));
}
}
public ActionResult Account()
{
if (ModelState.IsValid)
{
using (CustomerEntities cEntities = new CustomerEntities())
{
int customerID = Convert.ToInt32(Session["customerID"]);
ViewBag.customerInfo = cEntities.Customers.Where(x => x.customer_ID == customerID).ToList();
}
}
return View();
}
public Customer Post(Customer customer)
{
using (CustomerEntities entities = new CustomerEntities())
{
entities.Customer.Add(new Customer()
{
Name = "Poopoo"
});
entities.SaveChanges();
return(entities.Customer.FirstOrDefault());
}
}
public ActionResult Account(Customer customer)
{
if (ModelState.IsValid)
{
using (CustomerEntities cEntities = new CustomerEntities())
{
customer.customer_ID = Convert.ToInt32(Session["customerID"]);
cEntities.Entry(customer).State = EntityState.Modified;
cEntities.SaveChanges();
return RedirectToAction("Account");
}
}
return View();
}
public void UpdateCustomerByCustomerID_BL(CustomerEntities customerEntities)
{
Validate(customerEntities);
ValidateCustomerID(customerEntities.CustomerID);
CustomerDAL obj = new CustomerDAL();
CustomerEntities customerEntitiesTemporary = new CustomerEntities();
customerEntitiesTemporary = obj.GetCustomerByCustomerID_DAL(customerEntities.CustomerID);
customerEntitiesTemporary.CustomerName = customerEntities.CustomerName;
customerEntitiesTemporary.CustomerID = customerEntities.CustomerID;
customerEntitiesTemporary.CustomerMobile = customerEntities.CustomerMobile;
customerEntitiesTemporary.CustomerEmail = customerEntitiesTemporary.CustomerEmail;
customerEntitiesTemporary.CustomerAddress = customerEntitiesTemporary.CustomerAddress;
customerEntitiesTemporary.CustomerPan = customerEntitiesTemporary.CustomerPan;
}
public static List <CustomerEntities> CustomersList; // list of customers is created by passing CustomerEntities class as data type
public bool AddCustomerDAL(CustomerEntities customerEntities)
{
try
{
DateTime Time = DateTime.Now;
string customerID = Time.ToString("yyyyMMddhhmmss");
customerEntities.CustomerID = customerID;
CustomersList.Add(customerEntities); //Customer is added in the list
return(SerialiazeIntoJSON(CustomersList, "Customerdata.txt"));
}
catch (Exception e)
{
return(false);
}
}
public static List <CustomerEntities> Customers; // list of customers is created by passing CustomerEntities class as data type
public bool AddCustomerDAL(CustomerEntities c)
{
try
{
DateTime Time = DateTime.Now;
string customerID = Time.ToString("yyyyMMddhhmmss");
c.CustomerID = customerID;
Customers.Add(c); //Customer is added in the list
return(true);
}
catch (Exception e)
{
return(false);
}
}
public async Task <bool> DeleteAsync(int id)
{
bool isDeleted = false;
using (var db = new CustomerEntities())
{
var customer = db.Customers.SingleOrDefault(c => c.Id == id);
if (customer != null)
{
db.Entry(customer).State = EntityState.Deleted;
await db.SaveChangesAsync();
isDeleted = true;
}
}
return(isDeleted);
}
public bool AddCustomer(string customer)
{
try
{
using (var db = new CustomerEntities())
{
var newCustomer = db.Main_Dim_CustomerSet.Create();
newCustomer.Customer_name = customer;
db.Main_Dim_CustomerSet.Add(newCustomer);
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
public ActionResult Register(Customer customer, CustomerAddress customerAddress, CustomerLogin customerLogin)
{
string viewChange = "";
try
{
if (ModelState.IsValid)
{
//encrypt the password
customerLogin.password = HashKey.GetHashKey(customerLogin.password);
//inserting into customers table
using (CustomerEntities cEntityy = new CustomerEntities())
{
cEntityy.Customers.Add(customer);
cEntityy.SaveChanges();
}
using (CustomerAddressEntities caEntity = new CustomerAddressEntities())
{
customerAddress.customer_ID = customer.customer_ID;
//inserting into customer address table
caEntity.CustomerAddresses.Add(customerAddress);
caEntity.SaveChanges();
}
using (CustomerLoginEntities clEntity = new CustomerLoginEntities())
{
customerLogin.customer_ID = customer.customer_ID;
customerLogin.email = customer.email;
customerLogin.dateCreated = DateTime.Now;
//inserting into customer login table
clEntity.CustomerLogins.Add(customerLogin);
clEntity.SaveChanges();
return RedirectToAction("Index", "Customer");
}
}
else
{
viewChange = "LoginRegister";
}
}
catch(EntryPointNotFoundException ex){}
catch (Exception ex) { viewChange = "LoginRegister"; }
return View(viewChange);
}
public bool UserExist(string username)
{
try
{
using (var db = new CustomerEntities())
{
if (db.Main_UsersSet.Any(o => o.Username.Equals(username)))
{
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
return false;
}
}
public bool UnitExist(string ID)
{
try
{
using (var db = new CustomerEntities())
{
if (db.Main_Bridge_Customer_UnitSet.Any(o => o.Main_Dim_UnitSet.UnitID.Equals(ID)))
{
return true;
}
else
{
return false;
}
}
}
catch
{
return false;
}
}
public bool Adduser(string username, string password, string customer)
{
try
{
using (var db = new CustomerEntities())
{
var newUser = db.Main_UsersSet.Create();
newUser.Username = username;
newUser.Password = password;
newUser.Customer = customer;
db.Main_UsersSet.Add(newUser);
db.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public bool AddUnitToCustomerTable(string UnitID, string customer)
{
try
{
using (var dbCustomer = new CustomerEntities())
{
var newBridgeUnit = dbCustomer.Main_Bridge_Customer_UnitSet.Create();
var newUnit = dbCustomer.Main_Dim_UnitSet.Create();
var cust = dbCustomer.Main_Dim_CustomerSet.Where(o => o.Customer_name.Equals(customer)).First();
newUnit.UnitID = UnitID;
newBridgeUnit.Main_Dim_UnitSet = newUnit;
newBridgeUnit.Main_Dim_CustomerSet = cust;
dbCustomer.Main_Bridge_Customer_UnitSet.Add(newBridgeUnit);
dbCustomer.SaveChanges();
}
return true;
}
catch (Exception ex)
{
return false;
}
/*switch (customer)
{
case "RegionH":
try
{
using (var dbCustomer = new CustomerEntities())
{
var newBridgeUnit = dbCustomer.Main_Bridge_Customer_UnitSet.Create();
var newUnit = dbCustomer.Main_Dim_UnitSet.Create();
var cust = dbCustomer.Main_Dim_CustomerSet.Where(o => o.Customer_name.Equals(customer)).First();
newUnit.UnitID = UnitID;
newBridgeUnit.Main_Dim_UnitSet = newUnit;
newBridgeUnit.Main_Dim_CustomerSet = cust;
dbCustomer.Main_Bridge_Customer_UnitSet.Add(newBridgeUnit);
dbCustomer.SaveChanges();
}
return true;
}
catch (Exception ex)
{
return false;
}
case "Lundbeck":
try
{
using (var db = new LundbeckEntities())
{
//CHANGE!!
}
return true;
}
catch (Exception ex)
{
return false;
}
default:
return false;
}*/
}
/*public string getCustomerForUnit(string unitID)
{
try
{
using (var db = new CustomerEntities())
{
var cust = db.Main_Bridge_Customer_UnitSet.Where(o => o.Main_Dim_UnitSet.UnitID.Equals(unitID)).First();
return cust.Main_Dim_CustomerSet.Customer_name;
}
}
catch (Exception ex)
{
return "Failed to retrieve Customer ID";
}
}*/
public bool checkLogin(string username, string password)
{
try
{
using (var db = new CustomerEntities())
{
if (db.Main_UsersSet.Any(o => o.Username.Equals(username) && o.Password.Equals(password)))
{
return true;
}
else
{
//User credentials doesn't match
return false;
}
}
}
catch (Exception ex)
{
return false;
}
}
public bool AddLogToMainTable(string ID, DateTime timestamp, string action)
{
try
{
using (var db = new CustomerEntities())
{
var newlog = db.Main_Fact_LogsSet.Create();
newlog.UnitName = ID;
newlog.Timestamp = timestamp;
newlog.EventName = action;
db.Main_Fact_LogsSet.Add(newlog);
db.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public ActionResult Index()
{
if (Session["customerID"] == null)
{
return RedirectToAction("Index","Registration");
}
if (Session["customerID"] != null)
{
using (CustomerEntities cEntites = new CustomerEntities())
{
int customerID = Convert.ToInt32(Session["customerID"]);
List<Customer> customerList = cEntites.Customers.Where(x => x.customer_ID == customerID).ToList();
ViewBag.customerName = customerList[0].firstName + " " + customerList[0].lastName;
}
}
return View();
}
public bool customerExist(string customer)
{
try
{
using (var db = new CustomerEntities())
{
if (db.Main_Dim_CustomerSet.Any(o => o.Customer_name.Equals(customer)))
{
return true;
}
else
{
return false;
}
}
}
catch
{
return false;
}
}
public EFUnitOfWork()
{
Context = new CustomerEntities();
}
public string getCustomerForUser(string username)
{
try
{
using (var db = new CustomerEntities())
{
var userSet = db.Main_UsersSet.Where(o => o.Username.Equals(username)).First();
return userSet.Customer;
}
}
catch (Exception ex)
{
return "Couldn't get Customer name";
}
}
public string getCustomerForUnit(string UnitID)
{
try
{
using (var db = new CustomerEntities())
{
if (db.Main_Bridge_Customer_UnitSet.Any(o => o.Main_Dim_UnitSet.UnitID.Equals(UnitID)))
{
var unit = db.Main_Bridge_Customer_UnitSet.Where(x => x.Main_Dim_UnitSet.UnitID.Equals(UnitID)).First();
return unit.Main_Dim_CustomerSet.Customer_name;
}
else
{
return "Unit not found at customer";
}
}
}
catch
{
return "Couldn't connect to CustomerEntities";
}
//return "gg";
}