public void FillCompanyDllAction(int accessLevel) { SQLHandler sql = new SQLHandler(); if ((int)Enums.AccessLevel.CompanyAdmin == accessLevel) { dt = sql.ExecuteSqlReterieve(SqlCache.GetSql("GetUserPharmaCompany")); } else if ((int)Enums.AccessLevel.PharmacyAdmin == accessLevel || (int)Enums.AccessLevel.Operator == accessLevel) { dt = sql.ExecuteSqlReterieve(SqlCache.GetSql("GetUserPharmacy")); } MessageCollection.copyFrom(sql.Messages); if (dt == null || dt.Rows.Count <= 0) { MessageCollection.addMessage(new Message() { Context = "UsersHandler", ErrorCode = ErrorCache.RecordsNotFound, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.RecordsNotFound) + " in Company/Pharmacy Table", isError = true, LogType = Enums.LogType.Exception, WebPage = "Users" }); } }
public void GetMedicineAgainstQRCode(string qrcode, DataTable viewData, int pharmacyid) { SQLHandler sql = new SQLHandler(new ArrayList() { qrcode }); dt = sql.ExecuteSqlReterieve(SqlCache.GetSql("GetMedicinesForQRCode")); MessageCollection.copyFrom(sql.Messages); if (dt == null || dt.Rows.Count <= 0) { MessageCollection.addMessage(new Message() { Context = "MedicineHandler", ErrorCode = ErrorCache.RecordsNotFound, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.RecordsNotFound), isError = true, LogType = Enums.LogType.Exception, WebPage = "Medicine" }); } Decrementquantity(dt.Rows[0].Field <int>("pharmacyid"), dt.Rows[0].Field <int>("medicineid")); viewData.Rows.Add(dt.Rows[0]); dt = viewData; }
public override void DoAction() { ArrayList Params = new ArrayList() { userName, password }; SQLHandler sql = new SQLHandler(Params); dt = sql.ExecuteSqlReterieve(SqlCache.GetSql("UserLogin")); MessageCollection.copyFrom(sql.Messages); if (!MessageCollection.isErrorOccured) { if (dt != null && dt.Rows.Count > 0) { Session[Enums.SessionName.UserDetails.ToString()] = dt; accessLevel = Convert.ToInt16(dt.Rows[0]["accesslevel"].ToString()); } else if (dt == null || dt.Rows.Count <= 0) { MessageCollection.addMessage(new Message() { Context = "LoginHandler", ErrorCode = ErrorCache.LoginFailed, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.LoginFailed), isError = true, LogType = Enums.LogType.Exception, WebPage = "Login" }); } } }
internal void DoSqlUpdateAction(string token, string EmailFrom) { ArrayList Params = new ArrayList() { token, EmailFrom }; SQLHandler sqlHandler = new SQLHandler(Params); DataTable dt = sqlHandler.ExecuteSqlReterieve(SqlCache.GetSql("CheckToken")); if (dt != null && dt.Rows.Count > 0) { if (!Convert.ToBoolean(dt.Rows[0]["isUsed"])) { sqlHandler = new SQLHandler(Params); sqlHandler.ExecuteNonQuery(SqlCache.GetSql("UpdateToken")); } else { messageCollection.addMessage( new Message() { Context = "MailingHandler", ErrorCode = 1, ErrorMessage = "The Token is already Used", isError = true, LogType = Enums.LogType.Exception }); } } else { messageCollection.addMessage( new Message() { Context = "MailingHandler", ErrorCode = 1, ErrorMessage = "There is no token with that signature", isError = true, LogType = Enums.LogType.Exception }); } }
public override void DoFillGridAction() { SQLHandler sql = new SQLHandler(); dt = sql.ExecuteSqlReterieve(SqlCache.GetSql("GetMedicines")); MessageCollection.copyFrom(sql.Messages); if (dt == null || dt.Rows.Count <= 0) { MessageCollection.addMessage(new Message() { Context = "MedicineHandler", ErrorCode = ErrorCache.RecordsNotFound, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.RecordsNotFound), isError = true, LogType = Enums.LogType.Exception, WebPage = "Medicine" }); } }
public override void DoFillBackPanelAction(int ID) { SQLHandler sql = new SQLHandler(new ArrayList() { ID }); dt = sql.ExecuteSqlReterieve(SqlCache.GetSql("GetUser")); MessageCollection.copyFrom(sql.Messages); if (dt == null || dt.Rows.Count <= 0) { MessageCollection.addMessage(new Message() { Context = "UsersHandler", ErrorCode = ErrorCache.RecordsNotFound, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.RecordsNotFound), isError = true, LogType = Enums.LogType.Exception, WebPage = "Users" }); } }
public DataTable GetMedicine(PharmacyInventoryModel model) { SQLHandler sql = new SQLHandler(new ArrayList() { model.PharmacyID, model.MedicineID }); dt = sql.ExecuteSqlReterieve(SqlCache.GetSql("GetPOSMedicine")); MessageCollection.copyFrom(sql.Messages); if (dt == null || dt.Rows.Count <= 0) { MessageCollection.addMessage(new Message() { Context = "PharmacyPOSHandler", ErrorCode = ErrorCache.RecordsNotFound, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.RecordsNotFound), isError = true, LogType = Enums.LogType.Exception, WebPage = "PharmacyPOS" }); } return(dt); }