/// <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; }