public async Task <ActionResult <EmergencyContact> > PostEmergencyContact(EmergencyContact emergencyContact)
{
_context.EmergencyContacts.Add(emergencyContact);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEmergencyContact", new { id = emergencyContact.Id }, emergencyContact));
}
public async Task <IActionResult> PutEmergencyContact(int id, EmergencyContact emergencyContact)
{
if (id != emergencyContact.EmergencyContactId)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Response {
Status = "Error", Message = "El ID que intenta actualizar no existe"
}));
}
try
{
await _emergencyContactDAO.UpdateAsync(emergencyContact);
return(Ok(new Response {
Status = "OK", Message = "Se ha actualizado correctamentee"
}));
}
catch (DbUpdateConcurrencyException)
{
if (!await _emergencyContactDAO.ExistAsync(id))
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Response {
Status = "Error", Message = "El ID que intenta actualizar no existe"
}));
}
else
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Response {
Status = "Error", Message = "favor de verificar los campos"
}));
}
}
}
public override void Add(object objetType)
{
if (objetType is Doctor)
{
Doctor doctor = (Doctor)objetType;
Student.Doctors.Add(doctor);
}
if (objetType is NextOfKin)
{
NextOfKin nextOfKin = (NextOfKin)objetType;
Student.NextOfKin.Add(nextOfKin);
}
if (objetType is EmergencyContact)
{
EmergencyContact emergencyContact = (EmergencyContact)objetType;
Student.EmergencyContacts.Add(emergencyContact);
}
if (objetType is MedicalCondition)
{
MedicalCondition medicalCondition = (MedicalCondition)objetType;
Student.MedicalConditions.Add(medicalCondition);
}
if (objetType is StudentNote)
{
StudentNote studentNote = (StudentNote)objetType;
Student.StudentNotes.Add(studentNote);
}
}
public ActionResult Create([Bind(Include = "ID,ContactID,EmployeeID,QualificationsID,Name,Password,Position,StaffType,EmailAddress,BranchName,ContactInformation,EmergencyContact")] Employee employee,
EmployeeContacts employeeContact, EmergencyContact emergencyContact, EmployeeQualifications qualify, Schedules schedule, string[] Qualifications, string ID, string Name)
{
if (ModelState.IsValid)
{
for (int i = 0; i < Qualifications.Length; i++)
{
string results = Qualifications[i];
qualify.Qualifications = results;
qualify.EmployeeID = ID;
db.EmployeeQualifications.Add(qualify);
db.SaveChanges();
}
employeeContact.EmployeeID = ID;
emergencyContact.EmployeeID = ID;
//schedule.EmpId = Convert.ToInt32(ID);
db.SaveChanges();
db.Employees.Add(employee);
db.EmployeeContacts.Add(employeeContact);
db.EmergencyContact.Add(emergencyContact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public async Task <EmergencyContactResponse> UpdateAsync(int id, EmergencyContact emergencyContact)
{
var existingEmergencyContact = await _emergencyContactRepository.FindByIdAsync(id);
if (existingEmergencyContact == null)
{
return(new EmergencyContactResponse("EmergencyContact not found"));
}
var bookingExists = await _emergencyContactRepository.BookingExists(emergencyContact.BookingID);
if (!bookingExists)
{
return(new EmergencyContactResponse($"Booking ID:{ emergencyContact.BookingID } does not exist"));
}
existingEmergencyContact.BookingID = emergencyContact.BookingID;
existingEmergencyContact.Name = emergencyContact.Name;
existingEmergencyContact.LastName = emergencyContact.LastName;
existingEmergencyContact.PhoneNumber = emergencyContact.PhoneNumber;
try
{
_emergencyContactRepository.Update(existingEmergencyContact);
await _unitOfWork.CompleteAsync();
return(new EmergencyContactResponse(existingEmergencyContact));
}
catch (Exception e)
{
//TODO - log the exception
return(new EmergencyContactResponse($"An error ocurred while updating the EmergencyContact: " +
$"{ e.Message } { e.InnerException?.Message }"));
}
}
public async Task <IActionResult> Edit(int id, [Bind("EmergencyContactId,PrimaryOrSecondaryContact,EmerContactFirstName,EmerContactLastName,RelationshipToPatient,EmerContactDayPhone,EmerContactEveningPhone,EmerContactCellPhone,EmerContactEmail,EmerContactStreetAddress,EmerContactCity,EmerContactStateProvince,EmerContactZip,EmerContactCountry")] EmergencyContact emergencyContact)
{
if (id != emergencyContact.EmergencyContactId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(emergencyContact);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmergencyContactExists(emergencyContact.EmergencyContactId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(emergencyContact));
}
public async Task <IActionResult> PutEmergencyContact([FromRoute] int id, [FromBody] EmergencyContact emergencyContact)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != emergencyContact.Id)
{
return(BadRequest());
}
_context.Entry(emergencyContact).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmergencyContactExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
protected void btnEmergDelete_Click(object sender, EventArgs e)
{
try
{
_presenter.CurrentAppUser.Employee.RemoveEmergencyContact(Convert.ToInt32(Session["emergContId"]));
EmergencyContact delEmergContact = _presenter.GetEmergencyContact(Convert.ToInt32(Session["emergContId"]));
if (delEmergContact != null)
{
_presenter.DeleteEmergencyContact(delEmergContact);
}
_presenter.SaveOrUpdateEmployee(_presenter.CurrentAppUser);
Session["emergContId"] = null;
//Clear the fields
clearEmergencyContacts();
BindEmergencyContacts();
btnEmergDelete.Enabled = false;
Master.ShowMessage(new AppMessage("Emergency Contact Information Is Successfully Deleted!", RMessageType.Info));
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "movetoemergency();", true);
}
catch (Exception ex)
{
Master.ShowMessage(new AppMessage("Error: While Deleting Emergency Contact!", RMessageType.Error));
ExceptionUtility.LogException(ex, ex.Source);
ExceptionUtility.NotifySystemOps(ex, _presenter.CurrentUser().FullName);
}
}
public int AddEmergencyContacts(EmergencyContact emergency)
{
try
{
string query = string.Empty;
using (IDbConnection connection = OpenConnection())
{
var param = new DynamicParameters();
if (emergency != null)
{
query = StoredProcedure.AddEmergencyContacts;
}
// param.Add("@Retval", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);
// param.Add("@Name", dbType: DbType.String);
// param.Add("@employeeid", dbType: DbType.String, re);
return(connection.Execute(query, emergency, commandType: CommandType.StoredProcedure));
}
}
catch (Exception ex)
{
return(0);
}
}
public ActionResult SubmitEmergencyContact(EmergencyContact contact)
{
Guid UserID = Guid.Parse(HttpContext.User.Identity.GetUserId());
using (UserContext db = new UserContext())
{
var data = db.Users
.Include(u => u.EmergencyContacts.Select(n => n.Name))
.Include(u => u.EmergencyContacts.Select(p => p.PhoneOne))
.Include(u => u.EmergencyContacts.Select(p => p.PhoneTwo))
.Where(u => u.UserID == UserID)
.FirstOrDefault <UserModel>();
if (data.EmergencyContacts == null)
{
data.EmergencyContacts = new List <EmergencyContact>();
}
contact.UserID = UserID;
contact.Name.UserID = UserID;
contact.PhoneOne.UserID = UserID;
contact.PhoneTwo.UserID = UserID;
data.EmergencyContacts.Add(contact);
db.SaveChanges();
return(GetEmergencyContactsPartial(data.EmergencyContacts));
}
}
public static bool addEmergencyContact(EmergencyContact ec)
{
DBConnector dbcon = new DBConnector();
//try
//{
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO emergency_contact (salutation, full_name, relation, nic_no, personal_address, official_address, personal_tp, official_tp, mobile_no, employee_no, int_ext, priority, employee_idemployee) VALUES (N'" + ec.salutation + "', N'" + ec.full_name + "', N'" + ec.relation + "', '" + ec.nic_no + "', N'" + ec.personal_address + "', N'" + ec.official_address + "', N'" + ec.personal_tp + "', N'" + ec.office_tp + "', N'" + ec.mobile_no + "', N'" + ec.employee_no + "', N'" + ec.int_ext + "', N'" + ec.priority + "', " + Employee.employee_id + ")";
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
dbcon.closeConnection();
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//dbcon.closeConnection();
//return false;
//}
}
public IHttpActionResult PutEmergencyContactMaster(EmergencyContact emergencycontact)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
EmergencyContact objGen = new EmergencyContact();
objGen = objEntity.EmergencyContacts.Find(emergencycontact.EmergencyID);
if (objGen != null)
{
objGen.EmergencyName = emergencycontact.EmergencyName;
objGen.EmergencyContactNumber = emergencycontact.EmergencyContactNumber;
objGen.EmergencyEmail = emergencycontact.EmergencyEmail;
objGen.EmergencyAddress = emergencycontact.EmergencyAddress;
}
int i = objEntity.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Ok(emergencycontact));
}
private void SaveEmergencyContact(object sender, EventArgs e)
{
if (btnDeleteEmergencyContact.Text == "Edit")
{
var exisitngEmergencyContact = emergencyContactRepository.GetByPatientId(patientId);
exisitngEmergencyContact.PatientId = Convert.ToInt32(txtPatientIdEmergencyContact.Text);
exisitngEmergencyContact.FirstName = txtEcFirstname.Text;
exisitngEmergencyContact.LastName = txtECLastName.Text;
exisitngEmergencyContact.ContactNumber = txtECContactNumber.Text;
if (emergencyContactRepository.Update(exisitngEmergencyContact) > 0)
{
MessageBox.Show("Updated Successfully");
}
}
else
{
var emergencyContact = new EmergencyContact();
emergencyContact.PatientId = Convert.ToInt32(txtPatientIdEmergencyContact.Text);
emergencyContact.FirstName = txtEcFirstname.Text;
emergencyContact.LastName = txtECLastName.Text;
emergencyContact.ContactNumber = txtECContactNumber.Text;
if (emergencyContactRepository.Add(emergencyContact) > 0)
{
MessageBox.Show("Saved Successfully.");
}
}
FillDataGridView();
}
public async Task <EmergencyContact> UpdateAsync(EmergencyContact emergencyContact)
{
this.context.emergencyContacts.Update(emergencyContact);
await SaveAllAsync(emergencyContact);
return(emergencyContact);
}
public async Task <EmergencyContact> CreateAsync(EmergencyContact emergencyContact)
{
await this.context.emergencyContacts.AddAsync(emergencyContact);
await SaveAllAsync(emergencyContact);
return(emergencyContact);
}
public void DeleteEmergencyContact(EmergencyContact contact, out string errorMessage)
{
errorMessage = String.Empty;
using (SqlConnection connection = new SqlConnection(LoginCredentials.ConnectionString))
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "dbo.EmergencyContactDelete";
cmd.Parameters.AddWithValue("@EmergencyContactID", contact.EmergencyContactID);
cmd.Connection = connection;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.ExecuteScalar();
}
}
catch (Exception e)
{
errorMessage = "Error while deleting Emergency Contact: " + e.Message;
}
finally
{
connection.Close();
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,PetId,FirstName,LastName,HomePhone,CellPhone,WorkPhone")] EmergencyContact emergencyContact)
{
if (id != emergencyContact.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(emergencyContact);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmergencyContactExists(emergencyContact.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(emergencyContact));
}
public IHttpActionResult PutEmergencyContact(int id, EmergencyContact emergencyContact)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != emergencyContact.EmergencyContacts_id)
{
return(BadRequest());
}
db.Entry(emergencyContact).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmergencyContactExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Edit(ContactEditModel theContact)
{
Reply reply = new Reply();
String json = "";
var userID = User.Identity.GetUserId(); //get user ID
UserEmergency userEmergency = new UserEmergency();
userEmergency.UserProfileId = userID;
userEmergency.EmergencyContactPhone = theContact.pre.EmergencyContactPhone;
userEmergency.ECname = theContact.pre.ECname;
UserEmergency newContact = new UserEmergency();
newContact.UserProfileId = userID;
newContact.EmergencyContactPhone = theContact.now.EmergencyContactPhone;
newContact.ECname = theContact.now.ECname;
if (ModelState.IsValid)
{
//Check does the phone exist if not store Contactphone to table EmergencyContacts
EmergencyContact thisContact = db.EmergencyContact.Find(newContact.EmergencyContactPhone);
if (thisContact == null)
{
createNewContact(newContact.EmergencyContactPhone);
}
//Check whether old userEmergency exist
var result = db.UserEmergency.Find(userEmergency.EmergencyContactPhone, userEmergency.UserProfileId);
if (result == null)
{
reply.result = "failed";
reply.errors = "Contact do not exist";
return(BadRequest(JsonConvert.SerializeObject(reply)));
}
var checkNew = db.UserEmergency.Find(newContact.EmergencyContactPhone, newContact.UserProfileId);
if (checkNew != null && newContact.EmergencyContactPhone != userEmergency.EmergencyContactPhone)
{
reply.result = "failed";
reply.errors = "The contact phone number already exist";
return(BadRequest(JsonConvert.SerializeObject(reply)));
}
db.UserEmergency.Remove(result);
db.UserEmergency.Add(newContact);
db.SaveChanges();
reply.result = "Edit success";
json = JsonConvert.SerializeObject(reply);
reply.result = "contact create, edit success";
json = JsonConvert.SerializeObject(reply);
return(Ok(json));
}
reply.result = "failed";
reply.errors = "Data Type not validate";
json = JsonConvert.SerializeObject(reply);
return(Ok(json));
}
public static EmergencyContact getEmergencyContact()
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM emergency_contact WHERE employee_idemployee=" + Employee.employee_id;
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
Console.Write(Employee.employee_id + "\n");
EmergencyContact ec = null;
if (reader.Read())
{
ec = new EmergencyContact();
ec.ec_id = int.Parse(reader["idemergency_contact"].ToString());
ec.full_name = reader["full_name"].ToString();
ec.int_ext = reader["int_ext"].ToString();
ec.mobile_no = reader["mobile_no"].ToString();
ec.nic_no = reader["nic_no"].ToString();
ec.office_tp = reader["official_tp"].ToString();
ec.official_address = reader["official_address"].ToString();
ec.personal_address = reader["personal_address"].ToString();
ec.personal_tp = reader["personal_tp"].ToString();
ec.priority = reader["priority"].ToString();
ec.relation = reader["relation"].ToString();
ec.salutation = reader["salutation"].ToString();
ec.employee_no = reader["employee_no"].ToString();
}
reader.Close();
dbcon.closeConnection();
return ec;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}
public ActionResult DeleteConfirmed(string id)
{
EmergencyContact emergencyContact = db.EmergencyContact.Where(x => x.EmployeeID == id).FirstOrDefault();
db.EmergencyContact.Remove(emergencyContact);
db.SaveChanges();
return(RedirectToAction("Index/" + emergencyContact.EmployeeID));
}
EmergencyContact ParseEmergencyContact(string contact)
{
EmergencyContact result = null;
result = JsonConvert.DeserializeObject <EmergencyContact>(contact);
return(result);
}
public ActionResult EditEmergencyContacts(Int64 EmployeeNumber, EmergencyContact updateemergency)
{
EmergencyContactsService empService = new EmergencyContactsService();
String message = empService.UpdateEmergencyContactsDetails(updateemergency);
return(RedirectToAction("GetAllEmployees", new { message }));
}
public ActionResult DeleteConfirmed(int id)
{
EmergencyContact emergencyContact = db.EmergencyContacts.Find(id);
db.EmergencyContacts.Remove(emergencyContact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// Delete Person by Id
public void DeleteEmContactById(int id)
{
using (MyDbContext db = new MyDbContext())
{
EmergencyContact emContactToGo = db.EmergencyContacts.Find(id);
db.EmergencyContacts.Remove(emContactToGo);
db.SaveChanges();
}
}
public ActionResult GetAddEmergencyContact()
{
EmergencyContact contact = new EmergencyContact();
contact.Name = new Name();
contact.PhoneOne = new Phone();
contact.PhoneTwo = new Phone();
return(PartialView("_AddEmergencyContact", contact));
}
// Add Person
public EmergencyContact AddNewEmContact(EmergencyContact person)
{
using (MyDbContext db = new MyDbContext())
{
person = db.EmergencyContacts.Add(person);
db.SaveChanges();
return(person);
}
}
public ActionResult Edit(EmergencyContact emergencyContact)
{
if (ModelState.IsValid)
{
emergencyContact = HRBusinessService.UpdateEmergencyContact(UserOrganisationId, emergencyContact);
return(RedirectToAction("Profile", "Personnel", new { id = emergencyContact.PersonnelId }));
}
return(View(emergencyContact));
}
public ActionResult Update(EmergencyContactModel vm)
{
ApiResult <EmergencyContact> apiResult;
if (ModelState.IsValid)
{
if (vm.Id > 0)
{
apiResult = TryExecute(() =>
{
var emergencyContact = new EmergencyContact
{
Name = vm.Name,
Relationship = vm.Relationship,
Phone = vm.Phone,
EmployeeId = vm.EmployeeId,
Mobile = vm.Mobile,
WorkPhone = vm.WorkPhone,
Address = vm.Address,
Email = vm.Email,
Id = vm.Id,
};
_emergencyContactRepository.Update(emergencyContact);
_unitOfWork.Commit();
return(emergencyContact);
}, "Emergency Contact updated sucessfully");
}
else
{
apiResult = TryExecute(() =>
{
var emergencyContact = new EmergencyContact
{
Name = vm.Name,
Relationship = vm.Relationship,
Phone = vm.Phone,
EmployeeId = vm.EmployeeId,
Mobile = vm.Mobile,
WorkPhone = vm.WorkPhone,
Address = vm.Address,
Email = vm.Email,
Id = vm.Id
};
_emergencyContactRepository.Create(emergencyContact);
_unitOfWork.Commit();
return(emergencyContact);
}, "Emergency Contact created sucessfully");
}
}
else
{
apiResult = ApiResultFromModelErrors <EmergencyContact>();
}
return(Json(apiResult, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "ID,Name,Surname,CellNum")] EmergencyContact emergencyContact)
{
if (ModelState.IsValid)
{
db.Entry(emergencyContact).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(emergencyContact));
}
public ActionResult CreateEmergencyContacts(EmergencyContact emergency)
{
EmergencyContactsService emergencyService = new EmergencyContactsService();
emergency.EmployeeNumber = (Int64)Session["empId"];
//Employee employee = new Employee();
emergencyService.SaveEmergencyContacts(emergency);
return(Json(emergency.EmployeeNumber));
}
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,StreetAddress,City,State,ZipCode,PhoneNumber")] EmergencyContact emergencyContact)
{
if (ModelState.IsValid)
{
db.Entry(emergencyContact).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(emergencyContact));
}
private void btnSave4_Click(object sender, EventArgs e)
{
//Save emergency contact details
EmergencyContact ec = new EmergencyContact();
ec.employee_no = emg_employee_no.Text;
ec.full_name = emg_full_name.Text;
ec.int_ext = emg_int_ext.Text;
ec.mobile_no = emg_mobile_no.Text;
ec.nic_no = emg_nic_no.Text;
ec.office_tp = emg_office_tp.Text;
ec.official_address = emg_official_address.Text;
ec.personal_address = emg_personal_address.Text;
ec.personal_tp = emg_personal_tp.Text;
ec.priority = emg_priority.Text;
ec.relation = emg_relation.Text;
ec.salutation = emg_salutation.Text;
bool status = EmergencyContactHandler.addEmergencyContact(ec);
if (status)
{
MessageBox.Show("Emergency contact added successfully...!");
btnSave5.Enabled = true;
}
else { MessageBox.Show("Failed to add emergency contact...!"); }
}
public void updateEmergencyContact()
{
EmergencyContact ec = new EmergencyContact();
ec.ec_id = this.ec_id;
ec.employee_no = this.emg_employee_no.Text;
ec.full_name = this.emg_full_name.Text;
ec.int_ext = this.emg_int_ext.Text;
ec.mobile_no = this.emg_mobile_no.Text;
ec.nic_no = this.emg_nic_no.Text;
ec.office_tp = this.emg_office_tp.Text;
ec.official_address = this.emg_official_address.Text;
ec.personal_address = this.emg_personal_address.Text;
ec.personal_tp = this.emg_personal_tp.Text;
ec.priority = this.emg_priority.Text;
ec.relation = this.emg_relation.Text;
ec.salutation = this.emg_salutation.Text;
bool state = EmergencyContactHandler.updateEmergencyContact(ec);
Console.Write(state + "\n");
}
public static bool updateEmergencyContact(EmergencyContact ec)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE emergency_contact SET salutation=N'" + ec.salutation + "', full_name=N'" + ec.full_name + "', relation=N'" + ec.relation + "', nic_no=N'" + ec.nic_no + "', personal_address=N'" + ec.personal_address + "', official_address=N'" + ec.official_address + "', personal_tp=N'" + ec.personal_tp + "', official_tp=N'" + ec.office_tp + "', mobile_no=N'" + ec.mobile_no + "', employee_no=N'" + ec.employee_no + "', int_ext=N'" + ec.int_ext + "', priority=N'" + ec.priority + "' WHERE employee_idemployee=" + Employee.employee_id + " AND idemergency_contact=" + ec.ec_id;
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
