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();
}
