public void UpdatePrescriptionDetails( string UniqueID)
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[UpdatePrescriptionDetails]";
cmd.Parameters.Add("@UniqueID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(UniqueID);
cmd.Parameters.Add("@MedcineID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(MedicineID);
cmd.Parameters.Add("@Qty", SqlDbType.Real).Value = Qty;
cmd.Parameters.Add("@Unit", SqlDbType.Real).Value = Unit;
cmd.Parameters.Add("@Dosage", SqlDbType.Real).Value = Dosage;
cmd.Parameters.Add("@Timing", SqlDbType.NVarChar, 255).Value = Timing;
cmd.Parameters.Add("@Days", SqlDbType.Int).Value = Days;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = CreatedBy;
cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = CreatedDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = UpdatedBy;
cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = UpdatedDate;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
//------------*Methods Used For Forgot Password Implementation *------------//
#region Add verificationcode (Generated random number)
public void AddVerificationCode()
{
dbConnection dcon = new dbConnection();
try
{
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[AddVerificationCode]";
cmd.Parameters.Add("@VerificationCode", SqlDbType.NVarChar, 20).Value = verificationCode;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar, 255).Value = Email;
SqlParameter Output = new SqlParameter();
Output.DbType = DbType.Int32;
Output.ParameterName = "@Status";
Output.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Output);
cmd.ExecuteNonQuery();
//if (Output.Value.ToString() == "")
//{
// //not successfull
// var page = HttpContext.Current.CurrentHandler as Page;
// eObj.InsertionNotSuccessMessage(page);
//}
//else
//{
// //successfull
// var page = HttpContext.Current.CurrentHandler as Page;
// eObj.InsertionSuccessMessage(page);
//}
}
catch (Exception ex)
{
//var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void AddNewCategory()
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[InsertCategories]";
cmd.Parameters.Add("@CategoryID", SqlDbType.UniqueIdentifier).Value = CategoryID;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = ClinicID;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = CreatedBy;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = CategoryName;
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int Outputval = (int)cmd.Parameters["@Status"].Value;
cmd.ExecuteNonQuery();
if (Outputval == 1)
{
//Success
}
else
{
if (Outputval == 0)
{
//Already exists!
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
/// <summary>
/// VIEW MEDCINES IF SEARCH ITEM IS NULL ....OTHERWISE SEARCH
///
/// </summary>
/// <param name="String"></param>
/// <returns></returns>
public DataSet SearchMedicineStock(string String )//In case of view : Empty string has to be passed
{
dbConnection dcon = null;
DataSet ds = null;
SqlDataAdapter sda = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[SearchMedicineStock]";
if (String == String.Empty)
{
cmd.Parameters.Add("@String", SqlDbType.NVarChar, 255).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@String", SqlDbType.NVarChar, 255).Value = String;
}
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
sda = new SqlDataAdapter();
cmd.ExecuteNonQuery();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public string GetRoleIDOfDoctor()
{
string DoctorRoleID = string.Empty;
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[GetRoleIDOFDoctor]";
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = ClinicID;
object ID = cmd.ExecuteScalar();
if (ID != null)
{
DoctorRoleID = ID.ToString();
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
return DoctorRoleID;
}
public void InsertMedicines()
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[InsertMedicines]";
cmd.Parameters.Add("@MedicineID", SqlDbType.UniqueIdentifier).Value = MedicineID;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@CategoryID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(CategoryID);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = Name;
cmd.Parameters.Add("@Unit", SqlDbType.NVarChar, 15).Value = Unit;
// cmd.Parameters.Add("@Qty", SqlDbType.Real).Value = Qty; INITIAL QUANTITY WILL BE ZERO
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = CreatedBy;
cmd.Parameters.Add("@ReOrderQty", SqlDbType.Real).Value = Convert.ToInt32( ReOrderQty);
cmd.Parameters.Add("@MedCode", SqlDbType.NVarChar, 20).Value = MedCode;
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int Outputval = (int)cmd.Parameters["@Status"].Value;
cmd.ExecuteNonQuery();
if (Outputval == 1)
{
//Success
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.InsertionSuccessMessage(page);
}
else
{
if(Outputval == 0)
{
//Already exists!
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
eObj.ErrorData(ex, page);
//throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void DeleteMedicines(string MedicineID)
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[DeleteMedicines]";
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@MedicineID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(MedicineID);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void UpdateGroup(string GroupID)
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[UpdateGroup]";
cmd.Parameters.Add("@GroupID", SqlDbType.UniqueIdentifier).Value = GroupID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = Name;
//logo image
cmd.Parameters.Add("@UpdatedBy", SqlDbType.VarBinary).Value = Logo;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 255).Value = UpdatedBy;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void UpdateClinics()
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[UpdateClinics]";
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value =ClinicID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = Name;
cmd.Parameters.Add("@Location", SqlDbType.NVarChar, 255).Value = Location;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar, 255).Value = Address;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar, 255).Value = Phone;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 255).Value = UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = UpdatedDate;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public DataSet GetMedCodeUnitCategory(string name)
{
dbConnection dcon = null;
DataSet ds = null;
SqlDataAdapter sda = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[GetMedCodeCategoryUnit]";
cmd.Parameters.Add("@Medname", SqlDbType.NVarChar, 255).Value = name;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
sda = new SqlDataAdapter();
cmd.ExecuteNonQuery();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void InsertReceiptHeader()
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[InsertReceiptHeader]";
cmd.Parameters.Add("@ReceiptID", SqlDbType.UniqueIdentifier).Value = ReceiptID;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@RefNo1", SqlDbType.NVarChar, 255).Value = RefNo1;
cmd.Parameters.Add("@RefNo2", SqlDbType.NVarChar, 255).Value = RefNo2;
cmd.Parameters.Add("@Date", SqlDbType.NVarChar, 50).Value = Date;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = CreatedBy;
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int Outputval = (int)cmd.Parameters["@Status"].Value;
if (Outputval == 1)
{
//Success
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.InsertionSuccessMessage(page);
}
else
{
if (Outputval == 0)
{
//Already exists!
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void GetVisits()
{
if (VisitID == Guid.Empty)
{
throw new Exception("VisitID Is Empty!!");
}
dbConnection dcon = null;
try
{
DateTime now = DateTime.Now;
DataTable GridVisits = null;
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandText = "GetVisitDetails";
cmd.Parameters.Add("@VisitID", SqlDbType.UniqueIdentifier).Value = VisitID;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
GridVisits = new DataTable();
adapter.Fill(GridVisits);
if(GridVisits.Rows.Count>0)
{
DataRow dr = GridVisits.Rows[0];
Height =float.Parse(dr["Height"].ToString());
Weight = float.Parse(dr["Weight"].ToString());
Symptoms = dr["Symptoms"].ToString();
Cardiovascular = dr["Cardiovascular"].ToString();
Nervoussystem = dr["Nervoussystem"].ToString();
Musculoskeletal = dr["Musculoskeletal"].ToString();
Palloe = dr["Palloe"].ToString();
Icterus = dr["Icterus"].ToString();
Clubbing = dr["Clubbing"].ToString();
Cyanasis = dr["Cyanasis"].ToString();
Bowel = dr["Bowel"].ToString();
Appettie = dr["Appettie"].ToString();
Micturation = dr["Micturation"].ToString();
Sleep = dr["Sleep"].ToString();
Diagnosys = dr["Diagnosys"].ToString();
Remarks = dr["Remarks"].ToString();
Pulse = dr["Pulse"].ToString();
Bp = dr["Bp"].ToString();
Tounge = dr["Tounge"].ToString();
Heart = dr["Heart"].ToString();
LymphGen = dr["LymphGen"].ToString();
LymphClinic = dr["LymphClinic"].ToString();
RespRate = dr["RespRate"].ToString();
Others = dr["Others"].ToString();
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
eObj.ErrorData(ex, page);
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void AddFile()
{
dbConnection dcon = new dbConnection();
try
{
dcon.GetDBConnection();
SqlCommand pud = new SqlCommand();
pud.Connection = dcon.SQLCon;
pud.CommandType = System.Data.CommandType.StoredProcedure;
pud.CommandText = "[InsertNewFile]";
pud.Parameters.Add("@FileID", SqlDbType.UniqueIdentifier).Value = FileID;
pud.Parameters.Add("@PatientID", SqlDbType.UniqueIdentifier).Value = PatientID;
pud.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = ClinicID;
pud.Parameters.Add("@FileDate", SqlDbType.DateTime).Value = DateTime.Now;
pud.Parameters.Add("@CreatedBY", SqlDbType.NVarChar, 255).Value = "Thomson";
pud.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now;
pud.Parameters.Add("@UpdatedBY", SqlDbType.NVarChar, 255).Value = "Thomson";
pud.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = DateTime.Now;
pud.Parameters.Add("@FileNumber", SqlDbType.NVarChar, 50).Value = FileNumber;
//pud.Parameters.Add("@image", SqlDbType.VarBinary).Value = image;
SqlParameter Output = new SqlParameter();
Output.DbType = DbType.Int32;
Output.ParameterName = "@Status";
Output.Direction = ParameterDirection.Output;
pud.Parameters.Add(Output);
pud.ExecuteNonQuery();
if (Output.Value.ToString() == "")
{
//not successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.InsertionNotSuccessMessage(page);
}
else
{
//successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.InsertionSuccessMessage(page);
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void InsertPrescriptionHeaderDetails()
{
dbConnection dcon = null;
try
{
Guid PrescID = new Guid();
DateTime now = DateTime.Now;
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[InsertPrescriptionHeaderDetails]";
cmd.Parameters.Add("@PrescID", SqlDbType.UniqueIdentifier).Value = PrescID;
cmd.Parameters.Add("@DoctorID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(DoctorID);
cmd.Parameters.Add("@VisitID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(VisitID);
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@Date", SqlDbType.NVarChar, 50).Value = now.ToString("yyyy-MM-dd");
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = CreatedBy;
cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = CreatedDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value =UpdatedBy;
cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = UpdatedDate;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void InsertIssueDetails()
{
dbConnection dcon = null;
//string medID = GetMedcineIDByMedicineName(MedicineName);
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[InsertIssueDetails]";
cmd.Parameters.Add("@UniqueID", SqlDbType.UniqueIdentifier).Value = UniqueID;
cmd.Parameters.Add("@IssueID", SqlDbType.UniqueIdentifier).Value = IssueID;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@MedicineName", SqlDbType.NVarChar, 255).Value = MedicineName;
//cmd.Parameters.Add("@MedicineID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(medID);
cmd.Parameters.Add("@Qty", SqlDbType.Real).Value = Qty;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = CreatedBy;
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@QtyInStock", SqlDbType.Real);
//cmd.Parameters["@QtyInStock"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int Outputval = (int)cmd.Parameters["@Status"].Value;
//int QtyInstock = Convert.ToInt32(cmd.Parameters["@QtyInStock"].Value);
if (Outputval == 1)
{
//Success
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.InsertionSuccessMessage(page);
}
else
{
if (Outputval == 2)
{
//Out of stock
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.OutOfStockMessage(page);
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void InsertClinics()
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[InsertClinics]";
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = ClinicID;
cmd.Parameters.Add("@GroupID", SqlDbType.UniqueIdentifier).Value = GroupID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = Name;
cmd.Parameters.Add("@Location", SqlDbType.NVarChar, 255).Value = Location;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar, 255).Value = Address;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar, 255).Value = Phone;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 255).Value = CreatedBy;
SqlParameter Output = new SqlParameter();
Output.DbType = DbType.Int32;
Output.ParameterName = "@Status";
Output.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Output);
cmd.ExecuteNonQuery();
if (Output.Value.ToString() == "")
{
//not successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.InsertionNotSuccessMessage(page);
}
else
{
//successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.InsertionSuccessMessage(page);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void UpdateIssueDetails(string UniqueID)
{
dbConnection dcon = null;
try
{
DateTime now = DateTime.Now;
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[UpdateIssueDetails]";
cmd.Parameters.Add("@UniqueID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(UniqueID);
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
//cmd.Parameters.Add("@MedicineID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(MedicineID);
cmd.Parameters.Add("@Qty", SqlDbType.Real).Value = Qty;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 255).Value = UpdatedBy;
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int Outputval = (int)cmd.Parameters["@Status"].Value;
if (Outputval == 1)
{
//Success
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.UpdationSuccessMessage(page);
}
else
{
if (Outputval == 2)
{
//Out of stock
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.OutOfStockMessage(page);
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public string GetQtyInStock(string MedName)
{
string Qty = string.Empty;
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[GetQtyInStock]";
cmd.Parameters.Add("@MedName", SqlDbType.NVarChar, 255).Value =MedName;
object qtyInIssueDT = cmd.ExecuteScalar();
if (qtyInIssueDT != null)
{
Qty = qtyInIssueDT.ToString();
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
return Qty;
}
public void UpdateMedicines(string MedicineID )
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[UpdateMedicines]";
cmd.Parameters.Add("@MedicineID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(MedicineID);
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@CateoryID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(CategoryID);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = Name;
cmd.Parameters.Add("@Unit", SqlDbType.NVarChar, 15).Value = Unit;
cmd.Parameters.Add("@Qty", SqlDbType.Real).Value = Qty;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 255).Value = UpdatedBy;
cmd.Parameters.Add("@ReOrderQty", SqlDbType.Real).Value = ReOrderQty;
cmd.Parameters.Add("@MedCode", SqlDbType.NVarChar, 20).Value = MedCode;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public string Generate_Issue_Number()
{
string sDate = DateTime.Now.ToString();
DateTime datevalue = (Convert.ToDateTime(sDate.ToString()));
string mn = datevalue.Month.ToString();
string yy = datevalue.Year.ToString();
string dd = datevalue.Day.ToString();
string NUM;
dbConnection dcon = null;
try
{
DateTime now = DateTime.Now;
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[GetTopIssueNO]";
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
SqlParameter OutparmItemId = cmd.Parameters.Add("@String", SqlDbType.NVarChar,50);
OutparmItemId.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
NUM = OutparmItemId.Value.ToString();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
if (NUM != "")
{
//trim here
int x = Convert.ToInt32(NUM.Substring(NUM.IndexOf('/') + 1));
x = x + 1;
x.ToString();
string IssueNO = yy + '-' + mn + '-' + dd + '/' + x;
return IssueNO;
}
else
{
int x = 1;
string IssueNO = yy + '-' + mn + '-' + dd + '/' + x;
return IssueNO;
}
}
public DataSet ViewOutofStockMedicines()
{
dbConnection dcon = null;
DataSet ds = null;
SqlDataAdapter sda = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[ViewOutofStockMedicines]";
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
sda = new SqlDataAdapter();
cmd.ExecuteNonQuery();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void UpdateIssueHeader(string IssueID)
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[UpdateIssueHeader]";
cmd.Parameters.Add("@IssueID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(IssueID);
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@IssuedTo", SqlDbType.NVarChar, 255).Value = IssuedTo;
cmd.Parameters.Add("@Date", SqlDbType.NVarChar, 50).Value = Date;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 255).Value = UpdatedBy;
//cmd.Parameters.Add("@IssueNO", SqlDbType.NVarChar, 50).Value = IssueNO;
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int Outputval = (int)cmd.Parameters["@Status"].Value;
if (Outputval == 1)
{
//Success
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.UpdationSuccessMessage(page);
}
else
{
if (Outputval == 0)
{
//---------* Already exists! *----------//
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.AlreadyExistsMessage(page);
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void UpdateuserByUserID()
{
dbConnection dcon = new dbConnection();
try
{
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[UpdateUserByUserID]";
cmd.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier).Value = UserID;
cmd.Parameters.Add("@LoginName", SqlDbType.NVarChar, 255).Value = loginName;
cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar, 255).Value = firstName;
cmd.Parameters.Add("@LastName", SqlDbType.NVarChar, 255).Value = lastName;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 40).Value = passWord;
cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = isActive;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = ClinicID;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar, 255).Value = Email;
cmd.Parameters.Add("@PhoneNo", SqlDbType.NVarChar, 30).Value = PhoneNo;
cmd.Parameters.Add("@UpdatedBY", SqlDbType.NVarChar, 255).Value = updatedBy;
SqlParameter Output = new SqlParameter();
Output.DbType = DbType.Int32;
Output.ParameterName = "@Status";
Output.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Output);
cmd.ExecuteNonQuery();
if (Output.Value.ToString() == "")
{
//not successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.UpdationNotSuccessMessage(page);
}
else
{
//successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.UpdationSuccessMessage(page);
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="IssueID"></param>
public void DeleteIssueHeader(string IssueID)
{
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[DeleteIssueHeader]";
cmd.Parameters.Add("@IssueID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(IssueID);
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int Outputval = (int)cmd.Parameters["@Status"].Value;
if (Outputval == 1)
{
//Success
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.DeleteSuccessMessage(page);
}
else
{
if (Outputval == 0)
{
//Failure
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.DeletionFailureMessage(page);
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public int CheckUserIsDoctor()
{
int count = 0;
dbConnection dcon = new dbConnection();
try
{
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[CheckUserIsDoctor]";
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = firstName;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = ClinicID;
object cnt = cmd.ExecuteScalar();
if (cnt != null)
{
count = Convert.ToInt32(cnt);
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
return count;
}
public DataSet GetIssueDetailsByIssueNO(String IssueNo)
{
dbConnection dcon = null;
DataSet ds = null;
SqlDataAdapter sda = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[GetIssueDetailsByIssueNo]";
cmd.Parameters.Add("@IssueNo", SqlDbType.NVarChar, 255).Value = IssueNo;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = Guid.Parse(ClinicID);
sda = new SqlDataAdapter();
cmd.ExecuteNonQuery();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds,"Medicines");
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public void ResetPassword(Guid UserID)
{
dbConnection dcon = new dbConnection();
try
{
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "ResetPassword";
cmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = UserID;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 40).Value = passWord;
SqlParameter Output = new SqlParameter();
Output.DbType = DbType.Int32;
Output.ParameterName = "@Status";
Output.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Output);
cmd.ExecuteNonQuery();
if (Output.Value.ToString() == "")
{
//not successfull
//var page = HttpContext.Current.CurrentHandler as Page;
//eObj.UpdationNotSuccessMessage(page);
}
else
{
//successfull
//var page = HttpContext.Current.CurrentHandler as Page;
// eObj.UpdationSuccessMessage(page);
}
}
catch (Exception ex)
{
//var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public string GetMedcineIDByMedicineName(string MedicineName)
{
string MedicineID = string.Empty;
dbConnection dcon = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[GetMedcineIDByMedicineName]";
cmd.Parameters.Add("@MedicineName", SqlDbType.NVarChar, 255).Value = MedicineName;
object ID = cmd.ExecuteScalar();
if (ID != null)
{
MedicineID = ID.ToString();
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
//eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
return MedicineID;
}
public void AssignRole()
{
dbConnection dcon = new dbConnection();
try
{
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[InsertUserInRoles]";
cmd.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier).Value = UserID;
cmd.Parameters.Add("@RoleID", SqlDbType.UniqueIdentifier).Value = RoleID;
cmd.Parameters.Add("@ClinicID", SqlDbType.UniqueIdentifier).Value = ClinicID;
cmd.Parameters.Add("@Createdby", SqlDbType.NVarChar, 255).Value = CreatedBy;
SqlParameter Output = new SqlParameter();
Output.DbType = DbType.Int32;
Output.ParameterName = "@Status";
Output.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Output);
cmd.ExecuteNonQuery();
if (Output.Value.ToString() == "")
{
//not successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.InsertionNotSuccessMessage(page);
}
else
{
//successfull
var page = HttpContext.Current.CurrentHandler as Page;
eObj.InsertionSuccessMessage(page);
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
eObj.ErrorData(ex, page);
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
public DataSet ViewPrescriptionDetails()
{
dbConnection dcon = null;
DataSet ds = null;
SqlDataAdapter sda = null;
try
{
dcon = new dbConnection();
dcon.GetDBConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = dcon.SQLCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[ViewPrescriptionDetails]";
//
sda = new SqlDataAdapter();
cmd.ExecuteNonQuery();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dcon.SQLCon != null)
{
dcon.DisconectDB();
}
}
}
