public void UpdateCustomerPassword(int CustomerID, string CurrentPassword, string NewPassword)
{
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
objCustomer.UpdateCustomerPassword(CustomerID, CurrentPassword, NewPassword);
}
}
public void ActiveDeactiveCustomer(int CustomerID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
objCustomer.ActiveDeactiveCustomer(CustomerID);
}
}
public void AddEditCustomerRegistration(int Customerid, string username, string email, string password, string ip, string MobileNo, string memberid, string referral)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
dt = objCustomer.AddEditCustomerRegistration(Customerid, username, email, password, ip, MobileNo, memberid, referral);
}
}
public DataTable GetCustomerBymobile(string mobile)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
dt = objCustomer.GetCustomerBymobile(mobile);
}
return(dt);
}
public DataTable GetAllCustomer(int CustomerID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
dt = objCustomer.GetAllCustomer(CustomerID);
}
return(dt);
}
public DataTable CustomerLogin(string Email, string Password)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
dt = objCustomer.CustomerLogin(Email, Password);
}
return(dt);
}
public DataTable GetLoginforbulk(string mobileno, string password)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
dt = objCustomer.GetLoginforbulk(mobileno, password);
}
return(dt);
}
public DataTable getnetwork(string memberid)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
dt = objCustomer.getnetwork(memberid);
}
return(dt);
}
public int AddEditCustomer(int CustomerID, string username, string Email, string ContactNo1, string ImageUrl, string Password, string Address, string Country, string State, string City, string ZIP, string IPAddress, string Remark, int CountryID, int StateID, int CityID)
{
int id;
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter objCustomer = new AustraliaDAL.DataSet1TableAdapters.tblCustomerTableAdapter())
{
dt = objCustomer.AddEditCustomer(CustomerID, username, Email, ContactNo1, ImageUrl, Password, Address, Country, State, City, ZIP, IPAddress, Remark, CountryID, StateID, CityID);
}
id = Convert.ToInt32(dt.Rows[0]["CustomerID"].ToString());
return(id);
}
