public static RemoteCustomer checkUserRemoteAvailability(string mobile)
{
using (POCDBContext context = new POCDBContext())
{
RemoteCustomer customer = new RemoteCustomer();
dynamic customers = context.spCheckRemoteAvailability(mobile).FirstOrDefault();
if (customers != null)
{
customer.address = customers.address;
customer.mobile = customers.mobile;
customer.DOB = customers.DOB;
customer.firstname = customers.firstname;
customer.lastname = customers.lastname;
customer.address = customers.address;
customer.city = customers.city;
customer.PIN = customers.PIN;
customer.state = customers.state;
customer.country = customers.country;
}
else
customer = (RemoteCustomer)customers;
return customer;
}
}
public static void writeEventLog(AuditLog AL)
{
using (POCDBContext context = new POCDBContext())
{
context.spInsertTransLog(AL.userid, AL.eventtypeid, AL.source, AL.logmessage);
}
}
public static void writeEmailLog(EmailLog EL, AuditLog AL)
{
using (POCDBContext context = new POCDBContext())
{
context.spInsertEmailLog(AL.userid, AL.eventtypeid, AL.source, AL.logmessage, EL.emailaddress, EL.emailstatus);
}
}
public static RemoteCustomer checkUserRemoteAvailability(string mobile)
{
using (POCDBContext context = new POCDBContext())
{
RemoteCustomer customer = new RemoteCustomer();
dynamic customers = context.spCheckRemoteAvailability(mobile).FirstOrDefault();
if (customers != null)
{
customer.address = customers.address;
customer.mobile = customers.mobile;
customer.DOB = customers.DOB;
customer.firstname = customers.firstname;
customer.lastname = customers.lastname;
customer.address = customers.address;
customer.city = customers.city;
customer.PIN = customers.PIN;
customer.state = customers.state;
customer.country = customers.country;
}
else
{
customer = (RemoteCustomer)customers;
}
return(customer);
}
}
public static Customer findUserByMobile(string mobile)
{
using (POCDBContext context = new POCDBContext())
{
Customer customer = new Customer();
return customer;
}
}
public static Customer findUserByEmail(string email)
{
using (POCDBContext context = new POCDBContext())
{
Customer customer = new Customer();
return customer;
}
}
public static List<Dictionary<string, int>> getEventTypes()
{
using (POCDBContext context = new POCDBContext())
{
dynamic eventtypes = context.FunGetEventType();
return eventtypes;
}
}
public static List <Dictionary <string, int> > getEventTypes()
{
using (POCDBContext context = new POCDBContext())
{
dynamic eventtypes = context.FunGetEventType();
return(eventtypes);
}
}
public static Customer getUser(int userid)
{
using (POCDBContext context = new POCDBContext())
{
dynamic customer = context.FunGetCustomer(userid).FirstOrDefault();
return((Customer)customer);
}
}
public static Customer findUserByEmail(string email)
{
using (POCDBContext context = new POCDBContext())
{
Customer customer = new Customer();
return(customer);
}
}
public static List <ServiceArea> getServiceAreas(string pin)
{
using (POCDBContext context = new POCDBContext())
{
List <ServiceArea> Pins = context.FunGetServiceArea(pin).ToList();
return(Pins);
}
}
public static Customer findUserByMobile(string mobile)
{
using (POCDBContext context = new POCDBContext())
{
Customer customer = new Customer();
return(customer);
}
}
public static bool saveUser(Customer customer, string password)
{
using (POCDBContext context = new POCDBContext())
{
ObjectParameter userid = new ObjectParameter("userid", 0);
context.spInsertCustomer(password, customer.mobile, customer.PIN, customer.DOB, customer.firstname, customer.lastname, customer.address, customer.city, customer.state, customer.country, userid);
return(((int)userid.Value == 0) ? false : true);
}
}
public static bool checkUserAvailability(string mobile)
{
using (POCDBContext context = new POCDBContext())
{
bool availability = false;
ObjectResult OR=context.spCheckAvailability(mobile);
foreach (dynamic R in OR) availability= (R > 0)? true:false;
return availability;
}
}
public static bool checkUserAvailability(string mobile)
{
using (POCDBContext context = new POCDBContext())
{
bool availability = false;
ObjectResult OR = context.spCheckAvailability(mobile);
foreach (dynamic R in OR)
{
availability = (R > 0)? true:false;
}
return(availability);
}
}
public static bool saveUser(Customer customer, string password)
{
using (POCDBContext context = new POCDBContext())
{
ObjectParameter userid=new ObjectParameter("userid" , 0);
context.spInsertCustomer(password, customer.mobile, customer.PIN, customer.DOB, customer.firstname, customer.lastname, customer.address, customer.city, customer.state, customer.country, userid);
return ((int)userid.Value == 0) ? false : true;
}
}
public static void writeEventLog(AuditLog AL)
{
using (POCDBContext context = new POCDBContext())
{
context.spInsertTransLog(AL.userid, AL.eventtypeid, AL.source, AL.logmessage);
}
}
public static void writeEmailLog(EmailLog EL,AuditLog AL)
{
using (POCDBContext context = new POCDBContext())
{
context.spInsertEmailLog(AL.userid, AL.eventtypeid, AL.source, AL.logmessage, EL.emailaddress, EL.emailstatus);
}
}
public static Customer getUser(int userid)
{
using (POCDBContext context = new POCDBContext())
{
dynamic customer = context.FunGetCustomer(userid).FirstOrDefault();
return (Customer) customer;
}
}
public static List<ServiceArea> getServiceAreas(string pin)
{
using (POCDBContext context = new POCDBContext())
{
List<ServiceArea> Pins = context.FunGetServiceArea(pin).ToList();
return Pins;
}
}
