public static Customer CheckLogin(Customer customer) { using (CustomerDBContext context = new CustomerDBContext()) { return(context.customers.Where(data => data.mobilenumber == customer.mobilenumber && data.password == customer.password).SingleOrDefault()); } }
public static Customer CheckUser() { using (CustomerDBContext context = new CustomerDBContext()) { return(context.customers.Where(data => data.role != "Admin").SingleOrDefault()); } }
public void AddCustomer(Customer customer) { using (CustomerDBContext context = new CustomerDBContext()) { //context.customers.Add(customer); SqlParameter name = new SqlParameter("@name", customer.name); SqlParameter type = new SqlParameter("@type", customer.type); SqlParameter monthlyIncome = new SqlParameter("@monthlyIncome", customer.monthlyIncome); SqlParameter mobilenumber = new SqlParameter("@mobilenumber", customer.mobilenumber); SqlParameter residentArea = new SqlParameter("@residentArea", customer.residentArea); SqlParameter salaryReceivedIn = new SqlParameter("@salaryReceivedIn", customer.salaryReceivedIn); SqlParameter desiredLoanAmount = new SqlParameter("@desiredLoanAmount", customer.desiredLoanAmount); SqlParameter gender = new SqlParameter("@gender", customer.gender); SqlParameter pincode = new SqlParameter("@pincode", customer.pincode); SqlParameter panCardNumber = new SqlParameter("@panCardNumber", customer.panCardNumber); SqlParameter dateOfBirth = new SqlParameter("@dateOfBirth", customer.dateOfBirth); SqlParameter email = new SqlParameter("@email", customer.email); SqlParameter company = new SqlParameter("@company", customer.company); SqlParameter currentEMIAmount = new SqlParameter("@currentEMIAmount", customer.currentEMIAmount); SqlParameter tenure = new SqlParameter("@tenure", customer.tenure); SqlParameter experience = new SqlParameter("@experience", customer.experience); SqlParameter haveLoan = new SqlParameter("@haveLoan", customer.haveLoan); SqlParameter password = new SqlParameter("@password", customer.password); SqlParameter role = new SqlParameter("@role", customer.role); var data = context.Database.ExecuteSqlCommand("Customer_Insert @name,@type,@monthlyIncome,@mobilenumber,@residentArea,@salaryReceivedIn,@desiredLoanAmount,@gender,@pincode,@panCardNumber,@dateOfBirth,@email,@company,@currentEMIAmount,@tenure,@experience,@haveLoan,@password,@role", name, type, monthlyIncome, mobilenumber, residentArea, salaryReceivedIn, desiredLoanAmount, gender, pincode, panCardNumber, dateOfBirth, email, company, currentEMIAmount, tenure, experience, haveLoan, password, role); //context.SaveChanges(); } }
public List <Customer> GetCustomers() { using (CustomerDBContext context = new CustomerDBContext()) { return(context.customers.ToList()); } }
public void DeleteCustomer(int customerid) { using (CustomerDBContext context = new CustomerDBContext()) { SqlParameter id = new SqlParameter("@customerid", customerid); var data = context.Database.ExecuteSqlCommand("Customer_Delete @customerid", id); //Customer customer = context.customers.Find(id); //context.customers.Remove(customer); //context.SaveChanges(); } }
public void EditCustomer(Customer customer) { using (CustomerDBContext context = new CustomerDBContext()) { //context.Entry(customer).State = EntityState.Modified; SqlParameter residentArea = new SqlParameter("@residentArea", customer.residentArea); SqlParameter email = new SqlParameter("@email", customer.email); SqlParameter currentEMIAmount = new SqlParameter("@currentEMIAmount", customer.currentEMIAmount); SqlParameter tenure = new SqlParameter("@tenure", customer.tenure); SqlParameter password = new SqlParameter("@password", customer.password); var data = context.Database.ExecuteSqlCommand("Customer_Update @residentArea,@email,@currentEMIAmount,@tenure,,@password", residentArea, email, currentEMIAmount, tenure, password); //context.SaveChanges(); } }
public List <Customer> GetCustomers() { CustomerDBContext context = new CustomerDBContext(); return(context.customers.ToList()); }