public MaterialDL(string MaterialDescription)
: base()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
_materialDescription = MaterialDescription;
}
public AgentDL(string AgentDescription)
: base()
{
this._myConnection = new ACEConnection();
this.AddEditOption = 0;
this.AgentDescription = AgentDescription;
}
public City(int CityID, bool getAllProperties)
: base()
{
this._myConnection = new ACEConnection();
this.AddEditOption = 0;
this._cityID = CityID;
if (getAllProperties)
{
GetCity();
}
}
/// <summary>
/// Get Page ID
/// </summary>
/// <returns></returns>
public static int GetPageID()
{
ACEConnection _myConnection = new ACEConnection();
Database db = DatabaseFactory.CreateDatabase(_myConnection.DatabaseName);
DbCommand dbCommand = db.GetStoredProcCommand("spGetPageID");
String AppPath = System.Web.HttpContext.Current.Request.ApplicationPath;
String AbsPath = System.Web.HttpContext.Current.Request.Url.AbsolutePath;
String URL = AppPath == "/" ? AbsPath : AbsPath.Remove(AbsPath.IndexOf(AppPath), AppPath.Length);
db.AddInParameter(dbCommand, "URL", DbType.String, URL);
return(Convert.ToInt32(db.ExecuteScalar(dbCommand)));
}
public ContactDL()
: base()
{
this._myConnection = new ACEConnection();
this._fName = "";
this._lName = "";
this._homeEmail = "";
this._workEmail = "";
this._homePhone = "";
this._workPhone = "";
this._mobilePhone = "";
this._comments = "";
this._addEditOption = 0;
this._contactAddress = new MailingAddressDL();
}
public SupplierDL()
: base()
{
_myConnection = new ACEConnection();
_supplierName = "";
_supplierCompanyName = "";
_homeEmail = "";
_workEmail = "";
_homePhone = "";
_workPhone = "";
_mobilePhone = "";
_comments = "";
_addEditOption = 0;
_supplierAddress = new MailingAddressDL();
}
public SupplierDL(int SupplierID, int companyID, bool allProperties)
: base()
{
_myConnection = new ACEConnection();
_supplierName = "";
_supplierCompanyName = "";
_homeEmail = "";
_workEmail = "";
_homePhone = "";
_workPhone = "";
_mobilePhone = "";
_comments = "";
_addEditOption = 0;
_supplierID = SupplierID;
_companyID = companyID;
if (allProperties)
{
_supplierAddress = new MailingAddressDL();
GetSupplier();
}
}
public ContactDL(int contactID, int companyID, bool allProperties)
: base()
{
this._myConnection = new ACEConnection();
this._fName = "";
this._lName = "";
this._homeEmail = "";
this._workEmail = "";
this._homePhone = "";
this._workPhone = "";
this._mobilePhone = "";
this._comments = "";
this._addEditOption = 0;
this._contactID = contactID;
this._companyID = companyID;
if (allProperties)
{
this._contactAddress = new MailingAddressDL();
GetContact();
}
}
public ContactDL(string fName, string lName, MailingAddressDL contactAddress, string homeEmail, string workEmail, string homePhone, string workPhone, string mobilePhone, string comments)
: base()
{
this._myConnection = new ACEConnection();
this._fName = "";
this._lName = "";
this._homeEmail = "";
this._workEmail = "";
this._homePhone = "";
this._workPhone = "";
this._mobilePhone = "";
this._comments = "";
this._addEditOption = 0;
this._fName = fName;
this._lName = lName;
this._contactAddress = contactAddress;
this._homeEmail = homeEmail;
this._workEmail = workEmail;
this._homePhone = homePhone;
this._workPhone = workPhone;
this._mobilePhone = mobilePhone;
this._comments = comments;
}
public PODocumentUploadDL()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}
public EnquiryReviewChecklistDL()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}
public AgentDL()
: base()
{
this._myConnection = new ACEConnection();
this.AddEditOption = 0;
}
public PurchaseOrderDL()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}
public City() : base()
{
this._myConnection = new ACEConnection();
this.AddEditOption = 0;
}
public MaterialDL()
: base()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}
public OrderAcceptanceParticularsListDL()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}
public EnquiryRegisterDL()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}
public OrderAcceptanceChecklistDL()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}
public StockDL()
: base()
{
_myConnection = new ACEConnection();
AddEditOption = 0;
}