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 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 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" }); } } }
public DataTable ExecuteSqlReterieve(string query) { try { try { if (sqlConnection != null) { sqlConnection.Close(); sqlConnection = null; } sqlConnection = new SqlConnection(SQL_CONNECTION); sqlConnection.Open(); } catch (Exception ex) { Messages.addMessage(new Message() { Context = CONTEXT, ErrorCode = ErrorCache.SqlConnectionError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.SqlConnectionError) + ": " + ex.Message, isError = true, }); } if (!Messages.isErrorOccured) { using (SqlCommand sqlCommand = new SqlCommand(query, sqlConnection)) { if (Params != null) { for (int i = 0; i < Params.Count; i++) { sqlCommand.Parameters.AddWithValue("arg" + i, Params[i]); } } SqlDataAdapter da = new SqlDataAdapter(sqlCommand); da.Fill(ds); dt = ds.Tables[0]; } sqlConnection.Close(); return(dt); } } catch (Exception ex) { Messages.addMessage(new Message() { Context = CONTEXT, ErrorCode = ErrorCache.GeneralSqlError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.GeneralSqlError) + ":" + ex.Message, isError = true, }); } return(null); }
public int?ExecuteScalar(string query) { try { int Id; try { if (sqlConnection != null) { sqlConnection.Close(); sqlConnection = null; } sqlConnection = new SqlConnection(SQL_CONNECTION); sqlConnection.Open(); } catch (Exception ex) { Messages.addMessage(new Message() { Context = CONTEXT, ErrorCode = ErrorCache.SqlConnectionError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.SqlConnectionError) + ": " + ex.Message, isError = true, }); } if (!Messages.isErrorOccured) { using (SqlCommand sqlCommand = new SqlCommand(query, sqlConnection)) { if (Params != null) { for (int i = 0; i < Params.Count; i++) { sqlCommand.Parameters.AddWithValue("arg" + i, Params[i]); } } Id = Convert.ToInt32(sqlCommand.ExecuteScalar()); sqlConnection.Close(); } sqlConnection.Close(); return(Id); } } catch (Exception ex) { Messages.addMessage(new Message() { Context = CONTEXT, ErrorCode = ErrorCache.GeneralSqlError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.GeneralSqlError) + ":" + ex.Message, isError = true, }); } return(null); }
public void CheckNull(string value, string FieldName) { if (string.IsNullOrWhiteSpace(value)) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.NullError, ErrorMessage = FieldName + ErrorCache.getErrorMessage(ErrorCache.NullError), isError = true, LogType = Enums.LogType.Exception }); } }
public void CheckDate(DateTime value, string FieldName) { if (value < DateTime.Now) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.InvalidDateError, ErrorMessage = FieldName + ":" + ErrorCache.getErrorMessage(ErrorCache.InvalidDateError), isError = true, LogType = Enums.LogType.Exception }); } }
public void CheckDateComparison(DateTime value, DateTime value2) { if (value < value2) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.InvalidDateError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.InvalidDateError), isError = true, LogType = Enums.LogType.Exception }); } }
public void CheckMaxLength(string value, string FieldName, int MaxLength) { if (value.Length > MaxLength) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.MaxCharacterError, ErrorMessage = FieldName + ErrorCache.getErrorMessage(ErrorCache.MaxCharacterError), isError = true, LogType = Enums.LogType.Exception }); } }
public void CheckNull(ref DataTable dt, string FieldName) { if (dt is null || dt.Rows.Count <= 0) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.NullError, ErrorMessage = FieldName + ErrorCache.getErrorMessage(ErrorCache.NullError), isError = true, LogType = Enums.LogType.Exception }); } }
public void CheckDate(ref TextBox textBox, string FieldName) { if (Convert.ToDateTime(textBox.Text) < DateTime.Now) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.InvalidDateError, ErrorMessage = FieldName + ":" + ErrorCache.getErrorMessage(ErrorCache.InvalidDateError), isError = true, LogType = Enums.LogType.Exception, WebPage = PageName }); } }
public void CheckNull(ref DropDownList dropDownList, string FieldName) { if (string.IsNullOrWhiteSpace(dropDownList.SelectedValue)) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.NullError, ErrorMessage = FieldName + ErrorCache.getErrorMessage(ErrorCache.NullError), isError = true, LogType = Enums.LogType.Exception, WebPage = PageName }); } }
public void CheckNull(ref TextBox textBox, string FieldName) { if (string.IsNullOrWhiteSpace(textBox.Text) && string.IsNullOrWhiteSpace(textBox.Attributes["value"])) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.NullError, ErrorMessage = FieldName + ErrorCache.getErrorMessage(ErrorCache.NullError), isError = true, LogType = Enums.LogType.Exception, WebPage = PageName }); } }
public void CheckDateComparison(ref TextBox textBox, ref TextBox textBox2) { if (Convert.ToDateTime(textBox.Text) < Convert.ToDateTime(textBox2.Text)) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.InvalidDateError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.InvalidDateError), isError = true, LogType = Enums.LogType.Exception, WebPage = PageName }); } }
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 void CheckNumber(ref TextBox textBox, string FieldName) { int number; if (!string.IsNullOrWhiteSpace(textBox.Text)) { if (!int.TryParse(textBox.Text, out number)) { messageCollection.addMessage(new Message() { Context = "ValidationHandler", ErrorCode = ErrorCache.NumberError, ErrorMessage = FieldName + ErrorCache.getErrorMessage(ErrorCache.NumberError), isError = true, LogType = Enums.LogType.Exception, WebPage = PageName }); } } }
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); }
protected void txt_qrcode_TextChanged(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(txt_qrcode.Text)) { var model = MapModelForQRCode(); PharmacyPOSHandler handler = new PharmacyPOSHandler(); var dt = handler.GetMedicine(model); MessageCollection.copyFrom(handler.MessageCollection); if (!MessageCollection.isErrorOccured) { if (ViewState != null && ViewState[Enums.SessionName.POSdetail.ToString()] != null && ViewState[Enums.SessionName.MedicineDetail.ToString()] != null) { DataRow ValueRow = dt.Rows[0]; string qrCode = ValueRow["QRCode"].ToString(); medQuantity = (Dictionary <string, int>)ViewState[Enums.SessionName.MedicineDetail.ToString()]; if (medQuantity.ContainsKey(qrCode)) { if (medQuantity[qrCode] == 0) { MessageCollection.addMessage(new Message() { Context = "PharmacyPOS", LogType = Enums.LogType.Exception, WebPage = "PharmacyPOS", isError = true, ErrorCode = ErrorCache.NoQuantityLeftError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.NoQuantityLeftError) }); MessageCollection.PublishLog(); lbl_err.Text = MessageCollection.Messages[MessageCollection.Messages.Count - 1].ErrorMessage; lbl_err.Visible = true; } else { medQuantity[qrCode] = medQuantity[qrCode] - 1; } } else { medQuantity.Add(qrCode, Convert.ToInt32(ValueRow["Quantity"]) - 1); } if (!MessageCollection.isErrorOccured) { DataTable POSdt = (DataTable)ViewState[Enums.SessionName.POSdetail.ToString()]; DataRow dr = POSdt.NewRow(); dr["ID"] = ValueRow["ID"]; dr["Name"] = ValueRow["Name"]; dr["BatchNo"] = ValueRow["BatchNo"]; dr["ExpiryDate"] = ValueRow["ExpiryDate"]; dr["MfgDate"] = ValueRow["MfgDate"]; dr["Price"] = ValueRow["Price"]; dr["QRCode"] = ValueRow["QRCode"]; POSdt.Rows.Add(dr); gridView.DataSource = POSdt; gridView.DataBind(); CalculateSum(POSdt); } } else { if (Convert.ToInt32(dt.Rows[0]["quantity"]) != 0) { ViewState[Enums.SessionName.POSdetail.ToString()] = dt; medQuantity.Add(dt.Rows[0]["qrcode"].ToString(), Convert.ToInt32(dt.Rows[0]["quantity"]) - 1); ViewState[Enums.SessionName.MedicineDetail.ToString()] = medQuantity; gridView.DataSource = dt; gridView.DataBind(); CalculateSum(dt); } else { MessageCollection.addMessage(new Message() { Context = "PharmacyPOS", LogType = Enums.LogType.Exception, WebPage = "PharmacyPOS", isError = true, ErrorCode = ErrorCache.NoQuantityLeftError, ErrorMessage = ErrorCache.getErrorMessage(ErrorCache.NoQuantityLeftError) }); MessageCollection.PublishLog(); lbl_err.Text = MessageCollection.Messages[MessageCollection.Messages.Count - 1].ErrorMessage; lbl_err.Visible = true; } } } } txt_qrcode.Text = ""; txt_qrcode.Focus(); }