public static int Update(VaccinationQueue o, int id)
 {
     try
     {
         string query       = @"UPDATE ""VACCINATION_QUEUE"" SET ""ID"" = " + o.Id + @", ""BARCODE_ID"" = '" + o.BarcodeId + @"', ""HEALTH_FACILITY_ID"" = " + o.HealthFacilityId + @", ""DATE"" = " + o.Date + @", ""USER_ID"" = " + o.UserId + @"WHERE ""ID"" = " + id;
         int    rowAffected = DBManager.ExecuteNonQueryCommand(query, CommandType.Text, null);
         Log.InsertEntity(2, "Success", id.ToString(), "VaccinationQueue", "Update");
         return(rowAffected);
     }
     catch (Exception ex)
     {
         Log.InsertEntity("VaccinationQueue", "Update", 2, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
     }
     return(-1);
 }
 public static int Insert(VaccinationQueue o)
 {
     try
     {
         string query = @"INSERT INTO ""VACCINATION_QUEUE"" (""BARCODE_ID"", ""HEALTH_FACILITY_ID"", ""DATE"", ""USER_ID"") VALUES ('" + o.BarcodeId + @"', " + o.HealthFacilityId + @", '" + o.Date + @"', " + o.UserId + @") returning ""ID"" ";
         object id    = DBManager.ExecuteScalarCommand(query, CommandType.Text, null);
         Log.InsertEntity(1, "Success", id.ToString(), "VaccinationQueue", "Insert");
         return(int.Parse(id.ToString()));
     }
     catch (Exception ex)
     {
         Log.InsertEntity("VaccinationQueue", "Insert", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
     }
     return(-1);
 }
 public static VaccinationQueue GetVaccinationQueueAsObject(DataTable dt)
 {
     foreach (DataRow row in dt.Rows)
     {
         try
         {
             VaccinationQueue o = new VaccinationQueue();
             o.Id               = Helper.ConvertToInt(row["ID"]);
             o.BarcodeId        = row["BARCODE_ID"].ToString();
             o.HealthFacilityId = Helper.ConvertToInt(row["HEALTH_FACILITY_ID"]);
             o.UserId           = Helper.ConvertToInt(row["USER_ID"]);
             o.Date             = Helper.ConvertToDate(row["DATE"]);
             return(o);
         }
         catch (Exception ex)
         {
             Log.InsertEntity("VaccinationQueue", "GetVaccinationQueueAsObject", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
             throw ex;
         }
     }
     return(null);
 }