/// <summary>
/// Adds page access to the specified account type
/// </summary>
/// <param name="pageId"></param>
/// <param name="accountTypeId"></param>
public static void AddAccountTypeAccess(int pageId, int accountTypeId)
{
Query query = new Query(SqlQueryType.SqlStoredProc, "PageAddAccess");
query.AddParameter("@PageId", pageId);
query.AddParameter("@AccountTypeId", accountTypeId);
DBManager.Execute(query);
}
/// <summary>
/// Deletes an item for the vendor
/// </summary>
/// <param name="vendorId"></param>
/// <param name="itemName"></param>
public static void Delete(int vendorId, string itemName)
{
Query query = new Query(SqlQueryType.SqlStoredProc, "ItemDelete");
query.AddParameter("@VendorID", vendorId);
query.AddParameter("@ItemName", itemName);
DBManager.Execute(query);
}
/// <summary>
/// Creates an account
/// </summary>
/// <param name="accountId"></param>
/// <param name="accountTypeId"></param>
/// <param name="accountUsername"></param>
/// <param name="accountPassword"></param>
/// <returns></returns>
public static void Create(int accountId, int accountTypeId, string accountUsername, string accountPassword)
{
Query query = new Query(SqlQueryType.SqlStoredProc, "AccountSave");
query.AddParameter("@AccountId", accountId);
query.AddParameter("@AccountTypeId", accountTypeId);
query.AddParameter("@AccountUsername", accountUsername);
query.AddParameter("@AccountPassword", accountPassword);
DBManager.Execute(query);
}
/// <summary>
/// Creates an item for the vendor
/// </summary>
/// <param name="vendorId"></param>
/// <param name="itemName"></param>
/// <param name="itemDesc"></param>
/// <param name="itemPrice"></param>
/// <param name="itemProcessingTime"></param>
public static void Create(int vendorId, string itemName, string itemDesc, decimal itemPrice, int itemProcessingTime)
{
Query query = new Query(SqlQueryType.SqlStoredProc, "ItemSave");
query.AddParameter("@VendorId", vendorId);
query.AddParameter("@ItemName", itemName);
query.AddParameter("@ItemDesc", itemDesc);
query.AddParameter("@ItemPrice", itemPrice);
query.AddParameter("@ItemProcessingTime", itemProcessingTime);
DBManager.Execute(query);
}
/// <summary>
/// Creates a new page
/// </summary>
/// <param name="pageName"></param>
/// <param name="pageUrl"></param>
/// <returns></returns>
public static bool CheckAccess(int pageId, int accountTypeId)
{
int? newPageId = null;
Query query = new Query(SqlQueryType.SqlStoredProc, "PageCheckAccess");
query.AddParameter("@PageId", pageId);
query.AddParameter("@AccountTypeId", accountTypeId);
DBManager.ExecuteScalar(query, ref newPageId);
return newPageId.HasValue;
}
/// <summary>
/// Creates a new page
/// </summary>
/// <param name="pageName"></param>
/// <param name="pageUrl"></param>
/// <returns></returns>
public static int Create(string pageName, string pageUrl)
{
int? pageId = null;
Query query = new Query(SqlQueryType.SqlStoredProc, "PageSave");
query.AddParameter("@PageName", pageName);
query.AddParameter("@PageUrl", pageUrl);
DBManager.ExecuteScalar(query, ref pageId);
return pageId.Value;
}
public static int Create(string eventTypeName, string eventTypeDesc)
{
int? eventTypeId = null;
Query query = new Query(SqlQueryType.SqlStoredProc, "EventTypeSave");
query.AddParameter("@EventTypeName", eventTypeName);
query.AddParameter("@EventTypeDesc", eventTypeDesc);
DBManager.ExecuteScalar(query, ref eventTypeId);
return eventTypeId.Value;
}
/// <summary>
/// Creates an Account Type Object
/// </summary>
/// <param name="accountTypeName"></param>
/// <param name="accountTypeDesc"></param>
/// <param name="landingUrl"></param>
/// <returns></returns>
public static int Create(string accountTypeName, string accountTypeDesc, string landingUrl)
{
int? accountTypeId = null;
Query query = new Query(SqlQueryType.SqlStoredProc, "AccountTypeSave");
query.AddParameter("@AccountTypeName", accountTypeName);
query.AddParameter("@AccountTypeDesc", accountTypeDesc);
query.AddParameter("@AccountTypeLandingUrl", landingUrl);
DBManager.ExecuteScalar(query, ref accountTypeId);
return accountTypeId.Value;
}
/// <summary>
/// Deletes the specifed test
/// </summary>
/// <param name="adminId"></param>
public static void Delete(Guid testId)
{
Query query = new Query(SqlQueryType.SqlStoredProc, "TestDelete");
query.AddParameter("@TestId", testId);
DBManager.Execute(query);
}
/// <summary>
/// Saves the specified test into the database
/// </summary>
/// <returns></returns>
public static Guid Save(Guid? testId)
{
Guid returnId = Guid.Empty;
Query query = new Query(SqlQueryType.SqlStoredProc, "TestSave");
query.AddParameter("@TestId", testId);
DBManager.ExecuteScalar(query, ref returnId);
return returnId;
}
/// <summary>
/// Create an employee
/// </summary>
/// <param name="companyId"></param>
/// <param name="fName"></param>
/// <param name="lName"></param>
/// <param name="DOB"></param>
/// <param name="StartDate"></param>
/// <param name="shipAddress"></param>
/// <param name="shipCity"></param>
/// <param name="shipState"></param>
/// <param name="shipZip"></param>
/// <returns></returns>
public static int Create(int companyId, string fName, string lName, DateTime DOB, DateTime StartDate, string shipAddress, string shipCity, string shipState, string shipZip)
{
int? newCompanyId = null;
Query query = new Query(SqlQueryType.SqlStoredProc, "EmployeeSave");
query.AddParameter("@CompanyId", companyId);
query.AddParameter("@EmployeeFName", fName);
query.AddParameter("@EmployeeLName", lName);
query.AddParameter("@EmployeeDOB", DOB.Date);
query.AddParameter("@EmployeeStartDate", StartDate.Date);
query.AddParameter("@EmployeeShipAddress", shipAddress);
query.AddParameter("@EmployeeShipCity", shipCity);
query.AddParameter("@EmployeeShipState", shipState);
query.AddParameter("@EmployeeShipZip", shipZip);
DBManager.ExecuteScalar(query, ref newCompanyId);
return newCompanyId.Value;
}
/// <summary>
/// Returns a loginObject if successful login
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static LoginObject CheckLogin(string username, string password)
{
LoginObject loginObject = null;
DataTable dt = null;
Query query = new Query(SqlQueryType.SqlStoredProc,"AccountCheckLogin");
query.AddParameter("@Username", username);
query.AddParameter("@Password", password);
DBManager.Execute(query, ref dt);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
int accountId = (int)row["AccountID"];
int accountTypeId = (int)row["AccountTypeID"];
string landingUrl = row["AccountTypeLandingUrl"] as string;
loginObject = new LoginObject { AccountId = accountId, AccountTypeId = accountTypeId, LandingUrl = landingUrl };
}
return loginObject;
}
/// <summary>
/// Creates a company
/// </summary>
/// <param name="name"></param>
/// <param name="address"></param>
/// <param name="city"></param>
/// <param name="state"></param>
/// <param name="zip"></param>
/// <param name="phone"></param>
/// <param name="email"></param>
/// <param name="contactName"></param>
/// <returns></returns>
public static int Create(string name, string address, string city, string state, string zip, string phone, string email, string contactName)
{
int? companyId = null;
Query query = new Query(SqlQueryType.SqlStoredProc, "CompanySave");
query.AddParameter("@CompanyName", name);
query.AddParameter("@CompanyAddress", address);
query.AddParameter("@CompanyCity", city);
query.AddParameter("@CompanyState", state);
query.AddParameter("@CompanyZip", zip);
query.AddParameter("@CompanyPhone", phone);
query.AddParameter("@CompanyEmail", email);
query.AddParameter("@companyContactName", contactName);
DBManager.ExecuteScalar(query, ref companyId);
return companyId.Value;
}
/// <summary>
/// Creates a vendor
/// </summary>
/// <param name="name"></param>
/// <param name="address"></param>
/// <param name="city"></param>
/// <param name="state"></param>
/// <param name="zip"></param>
/// <param name="phone"></param>
/// <param name="email"></param>
/// <param name="contactName"></param>
/// <returns></returns>
public static int Create(string name, string address, string city, string state, string zip, string phone, string email, string contactName)
{
int? vendorId = null;
Query query = new Query(SqlQueryType.SqlStoredProc, "VendorSave");
query.AddParameter("@VendorName", name);
query.AddParameter("@VendorAddress", address);
query.AddParameter("@VendorCity", city);
query.AddParameter("@VendorState", state);
query.AddParameter("@VendorZip", zip);
query.AddParameter("@VendorPhone", phone);
query.AddParameter("@VendorEmail", email);
query.AddParameter("@VendorContactName", contactName);
DBManager.ExecuteScalar(query, ref vendorId);
return vendorId .Value;
}