/// <summary>
/// Get Comission setting
/// </summary>
/// <returns></returns>
public static ComissionSetting GetComission()
{
using (NetworkEntities context = new NetworkEntities())
{
return context.ComissionSettings.FirstOrDefault();
}
}
/// <summary>
/// Edit record on Company table
/// </summary>
/// <param name="pTaxID"></param>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Edit(string pName, string pAddress, string pRegistrationNumber, string pPanNumber, string pPhoneNumber, string pFax, string pEmail, string pWebsite, string pContactPerson)
{
using (NetworkEntities context = new NetworkEntities())
{
if (context.Companies.Count() > 0)
{
FFModal.Company objCompany = context.Companies.FirstOrDefault();
objCompany.Name = pName;
objCompany.Address = pAddress;
objCompany.RegistrationNumber = pRegistrationNumber;
objCompany.PanNumber = pPanNumber;
objCompany.PhoneNumber = pPhoneNumber;
objCompany.Fax = pFax;
objCompany.Email = pEmail;
objCompany.Website = pWebsite;
objCompany.ContactPerson = pContactPerson;
context.SaveChanges();
}
else
{
Add(pName, pAddress, pRegistrationNumber, pPanNumber, pPhoneNumber, pFax, pEmail, pWebsite, pContactPerson);
}
return true;
}
}
/// <summary>
/// Get commision percentage
/// </summary>
/// <returns></returns>
public static decimal GetCommisionPercentage()
{
using (NetworkEntities context = new NetworkEntities())
{
return context.ComissionSettings.ToList()[0].ComissionPercentage;
}
}
/// <summary>
/// Get Tax setting
/// </summary>
/// <param name="pMembershipId"></param>
/// <returns></returns>
public static TaxSetting GetTaxSetting()
{
using (NetworkEntities context = new NetworkEntities())
{
return context.TaxSettings.SingleOrDefault();
}
}
/// <summary>
/// Get all areas
/// </summary>
/// <returns></returns>
public static List<Area> GetAll()
{
using (NetworkEntities context = new NetworkEntities())
{
return context.Areas.ToList();
}
}
/// <summary>
/// Get user by username and password
/// </summary>
/// <param name="pUserName"></param>
/// <param name="pPassword"></param>
/// <returns></returns>
public static User GetUser(string pUserName,string pPassword )
{
using (NetworkEntities context = new NetworkEntities())
{
var query= from c in context.Users where c.UserName==pUserName && c.Password==pPassword select c;
return query.ToList().SingleOrDefault();
}
}
/// <summary>
/// Get Company by ID
/// </summary>
/// <param name="pAreaCode"></param>
/// <returns></returns>
public static Company Get()
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Company objCompany = context.Companies.FirstOrDefault();
return objCompany;
}
}
/// <summary>
/// Get max vertical level
/// </summary>
/// <returns></returns>
public static int GetMaxLevel()
{
using (NetworkEntities context = new NetworkEntities())
{
int maxLevel = context.ComissionSettings.ToList()[0].MaxLevel;
return maxLevel;
}
}
/// <summary>
/// Edit record on TaxSetting table
/// </summary>
/// <param name="pTaxID"></param>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Edit(Int32 pTaxID,Int32 pTaxRate)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.TaxSetting objTax = context.TaxSettings.FirstOrDefault(x => x.TaxID == pTaxID);
objTax.TaxRate = pTaxRate;
context.SaveChanges();
return true;
}
}
/// <summary>
/// Insert new record on TaxSetting tabel
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Add(Int32 pTaxRate)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.TaxSetting objTax = new FFModal.TaxSetting();
objTax.TaxRate = pTaxRate;
context.TaxSettings.AddObject(objTax);
context.SaveChanges();
return true;
}
}
/// <summary>
/// Edit record on TaxSetting table
/// </summary>
/// <param name="pTaxID"></param>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Edit(string pAreaCode, string pAreaName)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Area objArea = context.Areas.FirstOrDefault(x => x.AreaCode == pAreaCode);
objArea.AreaCode = pAreaCode; ;
objArea.AreaDescription = pAreaName;
context.SaveChanges();
return true;
}
}
/// <summary>
/// Insert new record on TaxSetting tabel
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Add(string pAreaCode, string pAreaName)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Area objArea = new FFModal.Area();
objArea.AreaCode = pAreaCode;
objArea.AreaDescription = pAreaName;
context.Areas.AddObject(objArea);
context.SaveChanges();
return true;
}
}
/// <summary>
/// Insert new record on ComissionSetting tabel
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Add(Int32 pMaxLevel,Int32 pMaxNode,decimal pPercetage)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.ComissionSetting objComission = new FFModal.ComissionSetting();
objComission.MaxLevel = pMaxLevel;
objComission.MaxNode=pMaxNode;
objComission.ComissionPercentage = pPercetage;
context.ComissionSettings.AddObject(objComission);
context.SaveChanges();
return true;
}
}
/// <summary>
/// Delete CustomerComission by order id
/// </summary>
/// <param name="PAreaCode"></param>
/// <returns></returns>
public static bool Delete(string pOrderId)
{
using (NetworkEntities context = new NetworkEntities())
{
var query = from c in context.CustomerComissions where c.OrderID==pOrderId select c;
foreach(CustomerComission obj in query)
{
context.CustomerComissions.DeleteObject(obj);
}
context.SaveChanges();
return true;
}
}
/// <summary>
/// Insert new record on CustomerComission tabel
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Add(string pMembershipID,string pOrderID,decimal pAmount,DateTime? pComissionPaidDate)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.CustomerComission objComission = new FFModal.CustomerComission();
objComission.MembershipID = pMembershipID;
objComission.OrderID = pOrderID;
objComission.Amount = pAmount;
objComission.ComissionPaidDate = pComissionPaidDate;
objComission.IsComissionPaid = false;
context.CustomerComissions.AddObject(objComission);
context.SaveChanges();
return true;
}
}
/// <summary>
/// Delete Area by area code
/// </summary>
/// <param name="PAreaCode"></param>
/// <returns></returns>
public static bool Delete(string pAreaCode)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Area objArea = context.Areas.FirstOrDefault(x => x.AreaCode == pAreaCode);
if (objArea.Customers.Count > 0)
return false;
else
{
context.Areas.DeleteObject(objArea);
context.SaveChanges();
return true;
}
}
}
/// <summary>
/// Edit record on TaxSetting table
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Edit(Int32 pTaxRate)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.TaxSetting objTax = context.TaxSettings.FirstOrDefault();
if (objTax != null)
{
objTax.TaxRate = pTaxRate;
context.SaveChanges();
}
else
{
Add(pTaxRate);
}
}
return true;
}
/// <summary>
/// Changing password
/// </summary>
/// <param name="pUserName"></param>
/// <param name="pNewPassword"></param>
/// <returns></returns>
public static bool ChangePassword(string pUserName,string pNewPassword)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.User objUser = context.Users.FirstOrDefault(x => x.UserName == pUserName);
if (objUser != null)
{
objUser.Password=pNewPassword;
context.SaveChanges();
return true;
}
else
{
return false;
}
}
}
/// <summary>
/// Insert Customer on database
/// </summary>
/// <param name="pMembershipID"></param>
/// <param name="pIntroducerID"></param>
/// <param name="pReferenceID"></param>
/// <param name="pCustomerName"></param>
/// <param name="pBenificiaryName"></param>
/// <param name="pGender"></param>
/// <param name="pDateOfBirth"></param>
/// <param name="pCreatedDate"></param>
/// <param name="pCreatedBy"></param>
/// <param name="pMaratialStatus"></param>
/// <param name="pNationality"></param>
/// <param name="pCitizenshipID"></param>
/// <param name="pLicenseID"></param>
/// <param name="pPassportID"></param>
/// <param name="pCountry"></param>
/// <param name="pCity"></param>
/// <param name="pMunicipality"></param>
/// <param name="pDistrict"></param>
/// <param name="pStreet"></param>
/// <param name="pHomeNumber"></param>
/// <param name="pAreaCode"></param>
/// <param name="pAddress"></param>
/// <param name="pHomeTelephone"></param>
/// <param name="pMobile"></param>
/// <param name="pEmailAddress"></param>
/// <param name="pPhoto"></param>
/// <param name="pCustomerTypeID"></param>
/// <param name="pMROrientationDate"></param>
/// <returns></returns>
public static bool Add(String pMembershipID, String pIntroducerID, String pReferenceID, String pCustomerName,
String pBenificiaryName, String pGender, DateTime? pDateOfBirth, DateTime? pCreatedDate, Int32 pCreatedBy,
String pMaratialStatus, String pNationality, String pCitizenshipID, String pLicenseID, String pPassportID,
String pCountry, String pCity, String pMunicipality, String pDistrict, String pStreet, String pHomeNumber,
String pAreaCode, String pAddress, String pHomeTelephone, String pMobile, String pEmailAddress, byte[] pPhoto, Int32 pCustomerTypeID, DateTime? pMROrientationDate)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Customer objCustomer = new FFModal.Customer();
objCustomer.MembershipID = pMembershipID;
objCustomer.IntroducerID = pIntroducerID;
objCustomer.ReferenceID = pReferenceID;
objCustomer.CustomerName = pCustomerName;
objCustomer.BenificiaryName = pBenificiaryName;
objCustomer.Gender = pGender;
objCustomer.DateOfBirth = pDateOfBirth;
objCustomer.CreatedDate = DateTime.Now;
objCustomer.MaratialStatus = pMaratialStatus;
objCustomer.Nationality = pNationality;
objCustomer.CitizenshipID = pCitizenshipID;
objCustomer.LicenseID = pLicenseID;
objCustomer.PassportID = pPassportID;
objCustomer.Country = pCountry;
objCustomer.City = pCity;
objCustomer.Municipality = pMunicipality;
objCustomer.District = pDistrict;
objCustomer.Street = pStreet;
objCustomer.HomeNumber = pHomeNumber;
objCustomer.AreaCode = pAreaCode;
objCustomer.Address = pAddress;
objCustomer.HomeTelephone = pHomeTelephone;
objCustomer.Mobile = pMobile;
objCustomer.EmailAddress = pEmailAddress;
if (pPhoto != null)
{
objCustomer.Photo =pPhoto;
}
objCustomer.CreatedBy = pCreatedBy;
objCustomer.CustomerTypeID = pCustomerTypeID;
objCustomer.MROrientationDate = pMROrientationDate;
context.Customers.AddObject(objCustomer);
context.SaveChanges();
}
return true;
}
/// <summary>
/// Insert new record on Company tabel
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Add(string pName,string pAddress,string pRegistrationNumber,string pPanNumber,string pPhoneNumber ,string pFax ,string pEmail,string pWebsite, string pContactPerson)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Company objCompany = new FFModal.Company();
objCompany.Name = pName;
objCompany.Address = pAddress;
objCompany.RegistrationNumber = pRegistrationNumber;
objCompany.PanNumber = pPanNumber;
objCompany.PhoneNumber = pPhoneNumber;
objCompany.Fax = pFax;
objCompany.Email = pEmail;
objCompany.Website = pWebsite;
objCompany.ContactPerson = pContactPerson;
context.Companies.AddObject(objCompany);
context.SaveChanges();
return true;
}
}
/// <summary>
/// Edit record on TaxSetting table
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Edit(Int32 pMaxLevel, Int32 pMaxNode, decimal pPercetage)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.ComissionSetting objComission = context.ComissionSettings.FirstOrDefault();
if (objComission != null)
{
objComission.MaxLevel = pMaxLevel;
objComission.MaxNode = pMaxNode;
objComission.ComissionPercentage = pPercetage;
context.SaveChanges();
}
else
{
Add(pMaxLevel,pMaxNode,pPercetage);
}
}
return true;
}
/// <summary>
/// Edit record on CustomerComission table
/// </summary>
/// <param name="pTaxRate"></param>
/// <returns></returns>
public static bool Edit(string pMembershipID,string pOrderID,decimal pAmount,bool pIsPaid, DateTime? pComissionPaidDate)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.CustomerComission objComission = context.CustomerComissions.FirstOrDefault(x=>x.MembershipID==pMembershipID && x.OrderID==pOrderID);
if (objComission != null)
{
objComission.MembershipID = pMembershipID;
objComission.OrderID = pOrderID;
objComission.Amount = pAmount;
objComission.IsComissionPaid = pIsPaid;
objComission.ComissionPaidDate = pComissionPaidDate;
context.SaveChanges();
}
else
{
Add(pMembershipID, pOrderID, pAmount, pComissionPaidDate);
}
}
return true;
}
/// <summary>
/// Delete customer from databaes
/// </summary>
/// <param name="pMembershipID"></param>
/// <returns></returns>
public static bool Delete(String pMembershipID)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Customer objCustomer = context.Customers.FirstOrDefault(x => x.MembershipID == pMembershipID);
if (objCustomer != null)
{
context.Customers.DeleteObject(objCustomer);
context.SaveChanges();
}
}
return true;
}
/// <summary>
/// Check given membershipid is valid or not
/// </summary>
/// <param name="pMembershipID"></param>
/// <returns></returns>
public static bool IsValidReferenceMemberID(string pMembershipID)
{
using (NetworkEntities context = new NetworkEntities())
{
var query = from c in context.Customers where c.ReferenceID==pMembershipID select c;
int MaxNode = context.ComissionSettings.ToList()[0].MaxNode;
if (MaxNode <= query.ToList().Count)
{
return true;
}
else
{
return false;
}
}
}
/// <summary>
/// Get Area by area name
/// </summary>
/// <param name="pAreaCode"></param>
/// <returns></returns>
public static Area GetAreaByName(string pAreaName)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Area objArea = context.Areas.FirstOrDefault(x => x.AreaDescription == pAreaName);
return objArea;
}
}
/// <summary>
/// Get next membership id
/// </summary>
/// <param name="pAreaCode"></param>
/// <returns></returns>
public static string GetNextMembershipId(string pAreaCode)
{
using (NetworkEntities context = new NetworkEntities())
{
double rec = 1;
var query = from c in context.Customers where c.MembershipID.StartsWith(pAreaCode) select c;
List<FFModal.Customer> lstCustomers = query.ToList();
if (lstCustomers.Count>0)
{
return pAreaCode + "-" + (Convert.ToInt32(lstCustomers[lstCustomers.Count - 1].MembershipID.Replace(pAreaCode + "-", "")) + 1).ToString("00000");
}
else
{
return pAreaCode + "-" + rec.ToString("00000");
}
}
}
public static List<CustomerType> GetCustomerType()
{
using (NetworkEntities context = new NetworkEntities())
{
return context.CustomerTypes.ToList();
}
}
/// <summary>
/// Get Customer by Membership id
/// </summary>
/// <param name="pMembershipId"></param>
/// <returns></returns>
public static Customer GetCustomer(String pMembershipId,out int pOrderCount)
{
using (NetworkEntities context = new NetworkEntities())
{
Customer objCustomer= context.Customers.SingleOrDefault(x => x.MembershipID == pMembershipId);
pOrderCount = objCustomer.Orders.Count;
return objCustomer;
}
}
/// <summary>
/// Get Customer by Membership id
/// </summary>
/// <param name="pMembershipId"></param>
/// <returns></returns>
public static Customer GetCustomer(String pMembershipId)
{
using (NetworkEntities context = new NetworkEntities())
{
return context.Customers.SingleOrDefault(x => x.MembershipID == pMembershipId);
}
}
/// <summary>
/// Get Area by area code
/// </summary>
/// <param name="pAreaCode"></param>
/// <returns></returns>
public static Area GetAreaByCode(string pAreaCode, out int pCustomerCount)
{
using (NetworkEntities context = new NetworkEntities())
{
FFModal.Area objArea = context.Areas.FirstOrDefault(x => x.AreaCode == pAreaCode);
pCustomerCount = objArea.Customers.Count();
return objArea;
}
}
