internal static int UpdatePublicHoliday()
{
n = 0;
try
{
daPublicHoliday = new TblPublicHolidayTableAdapter();
dtPublicHoliday = new DsLiveOutlook.TblPublicHolidayDataTable();
daPublicHoliday.FillByID(dtPublicHoliday, PublicHolidayInfo.Day, PublicHolidayInfo.Month);
drwPublicHoliday = dtPublicHoliday[0];
drwPublicHoliday.BeginEdit();
drwPublicHoliday.Day = PublicHolidayInfo.NewDay;
drwPublicHoliday.Month = PublicHolidayInfo.NewMonth;
drwPublicHoliday.EndEdit();
n = daPublicHoliday.Update(dtPublicHoliday);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
private void LiveSaveInfo()
{
if (LiveFormIsValid())
{
myR = new RoleInfo();
myR.RoleID = txtRoleID.Text.Trim();
myR.Description = txtDescription.Text.Trim();
if (EditFlag)
{
myR.RoleID = lblID.Text.Trim();
myR.NewRoleID = txtRoleID.Text.Trim();
if ((Interactive.LInfoConfirm("Are you sure you want to Edit ?", "") == DialogResult.Yes))
{
if (myR.Edit())
{
Interactive.LInfo("Information saved successfully", "");
LiveLoad();
}
}
}
else
{
if (myR.Add())
{
Interactive.LInfo("Information saved successfully", "");
LiveLoad();
}
}
}
else
{
Interactive.LInfoError(err, string.Empty);
}
}
internal static int AddPublicHoliday()
{
n = 0;
try
{
daPublicHoliday = new TblPublicHolidayTableAdapter();
dtPublicHoliday = new DsLiveOutlook.TblPublicHolidayDataTable();
drwPublicHoliday = dtPublicHoliday.NewTblPublicHolidayRow();
drwPublicHoliday.Day = PublicHolidayInfo.Day;
drwPublicHoliday.Month = PublicHolidayInfo.Month;
dtPublicHoliday.AddTblPublicHolidayRow(drwPublicHoliday);
n = daPublicHoliday.Update(dtPublicHoliday);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static int UpdateReserve()
{
n = 0;
try
{
daReserve = new TblReserveTableAdapter();
dtReserve = new DsLiveOutlook.TblReserveDataTable();
daReserve.FillByID(dtReserve, ReserveInfo.Day, ReserveInfo.Month, ReserveInfo.Year);
drwReserve = dtReserve[0];
drwReserve.BeginEdit();
drwReserve.Day = ReserveInfo.NewDay;
drwReserve.Month = ReserveInfo.NewMonth;
drwReserve.Year = ReserveInfo.NewYear;
drwReserve.MaxAppointments = ReserveInfo.MaxAppointments;
drwReserve.EndEdit();
n = daReserve.Update(dtReserve);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static int AddReserve()
{
n = 0;
try
{
daReserve = new TblReserveTableAdapter();
dtReserve = new DsLiveOutlook.TblReserveDataTable();
drwReserve = dtReserve.NewTblReserveRow();
drwReserve.Day = ReserveInfo.Day;
drwReserve.Month = ReserveInfo.Month;
drwReserve.Year = ReserveInfo.Year;
drwReserve.MaxAppointments = ReserveInfo.MaxAppointments;
dtReserve.AddTblReserveRow(drwReserve);
n = daReserve.Update(dtReserve);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static int AddFacility()
{
n = 0;
try
{
daFacility = new TblFacilityTableAdapter();
dtFacility = new DsLiveOutlook.TblFacilityDataTable();
drwFacility = dtFacility.NewTblFacilityRow();
drwFacility.Fcode = FacilityInfo.FCode.Trim().ToUpper();
drwFacility.Facility = FacilityInfo.FName.Trim().ToUpper();
dtFacility.AddTblFacilityRow(drwFacility);
n = daFacility.Update(dtFacility);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static int UpdateSettings()
{
n = 0;
try
{
daSettings = new TblSettingsTableAdapter();
dtSettings = new DsLiveOutlook.TblSettingsDataTable();
daSettings.FillByID(dtSettings, SettingsInfo.ADay);
drwSettings = dtSettings[0];
drwSettings.BeginEdit();
drwSettings.MaxAppointments = SettingsInfo.MaxAppointments;
drwSettings.EndEdit();
n = daSettings.Update(dtSettings);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static int UpdateFacility()
{
n = 0;
try
{
daFacility = new TblFacilityTableAdapter();
dtFacility = new DsLiveOutlook.TblFacilityDataTable();
daFacility.FillByID(dtFacility, FacilityInfo.FCode);
drwFacility = dtFacility[0];
drwFacility.BeginEdit();
drwFacility.Fcode = FacilityInfo.NewFCode.Trim().ToUpper();
drwFacility.Facility = FacilityInfo.FName.Trim().ToUpper();
drwFacility.EndEdit();
n = daFacility.Update(dtFacility);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
public static void BackupData()
{
Interactive.STATUS = "Backing up Data... ";
bw.ReportProgress(9);
try
{
string x = DateTime.Now.ToString("ddMMMyyy-HHmmss").ToUpper();
string bak = DirBak + x;
SqlCommand cmd;
string strBAK = "BACKUP DATABASE " + DbName + " TO Disk='" + bak + DbName + ".bak'";
Temp = new SqlConnection();
Temp.ConnectionString = Settings.Default.dbMasterConnectionString;
if (Temp.State == ConnectionState.Closed)
{
Temp.Open();
}
cmd = new SqlCommand(strBAK, Temp);
cmd.ExecuteNonQuery();
bw.ReportProgress(11);
}
catch (Exception ex)
{
Interactive.LInfoError("Could not Back up data\n" + ex.Message, "Application Failure");
//Application.Exit();
}
finally
{
Temp.Dispose();
}
bw.ReportProgress(12);
}
private void LiveSaveInfo()
{
if (LiveFormIsValid())
{
myU = new UserInfo();
myU.UserID = UserInfo.LiveUserID;
myU.Password = txtOldPassword.Text.Trim();
if (myU.IsLoginUser())
{
myU.Password = txtConfirmPassword.Text.Trim();
if (myU.EditPassword())
{
Interactive.LInfo("Your password has been changed", "Change password");
LiveClearControls();
this.Close();
}
}
else
{
Interactive.LInfoError("Old password is wrong", "Change password");
txtOldPassword.SelectAll();
}
}
else
{
Interactive.LInfoError(err, string.Empty);
}
}
public void TestConnection(bool interactive)
{
try
{
Temp = new SqlConnection();
Temp.ConnectionString = Settings.Default.dbOutlookConnectionString;
if (Temp.State == ConnectionState.Closed)
{
Temp.Open();
}
if (Temp.State == ConnectionState.Open)
{
Temp.Close();
}
bw.ReportProgress(9);
}
catch (Exception ex)
{
Interactive.LInfoError("Database connection failed\n" + ex, "Application Fail");
Application.Exit();
}
finally
{
Temp.Dispose();
}
}
internal static int UpdateClassification()
{
n = 0;
try
{
daClassification = new TblClassificationTableAdapter();
dtClassification = new DsLiveOutlook.TblClassificationDataTable();
daClassification.FillByID(dtClassification, ClassificationInfo.ID, ClassificationInfo.AClass);
drwClassification = dtClassification[0];
drwClassification.BeginEdit();
drwClassification.ID = ClassificationInfo.NewID.Trim();
drwClassification.Display = ClassificationInfo.Display.Trim();
drwClassification.Value = ClassificationInfo.Value;
drwClassification.EndEdit();
n = daClassification.Update(dtClassification);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static int AddClassification()
{
n = 0;
try
{
daClassification = new TblClassificationTableAdapter();
dtClassification = new DsLiveOutlook.TblClassificationDataTable();
drwClassification = dtClassification.NewTblClassificationRow();
drwClassification.ID = ClassificationInfo.ID.Trim();
drwClassification.Class = ClassificationInfo.AClass.Trim();
drwClassification.Display = ClassificationInfo.Display.Trim();
drwClassification.Value = ClassificationInfo.Value;
dtClassification.AddTblClassificationRow(drwClassification);
n = daClassification.Update(dtClassification);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static int AddAppointment()
{
n = 0;
try
{
daAppointment = new TblAppointmentTableAdapter();
dtAppointment = new DsLiveOutlook.TblAppointmentDataTable();
drwAppointment = dtAppointment.NewTblAppointmentRow();
drwAppointment.RegNo = AppointmentInfo.RegNo.Trim();
drwAppointment.Appointment = AppointmentInfo.Appointment;
drwAppointment.Period = AppointmentInfo.Period;
drwAppointment.PeriodName = AppointmentInfo.PeriodName;
drwAppointment.SeenBy = AppointmentInfo.SeenBy.Trim().ToUpper();
drwAppointment.VisitDate = AppointmentInfo.VisitDate;
drwAppointment.VisitStatus = AppointmentInfo.VisitStatus;
drwAppointment.AStatus = AppointmentInfo.AStatus;
dtAppointment.AddTblAppointmentRow(drwAppointment);
n = daAppointment.Update(dtAppointment);
daAppointment.UpdateDates();
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal void UpdateStatus(UserInfo r)
{
try
{
da = new tblUserTableAdapter();
da.UpdateOnlineStatus(r.Online, r.UserID);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Update Record");
}
}
internal int Delete(LivelogInfo r)
{
try
{
da = new tblLivelogTableAdapter();
n = da.Delete(r.LogID);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Insert Record");
}
return(n);
}
public string GetVersion()
{
try
{
daLive = new TblLiveTableAdapter();
strVer = daLive.GetVersion(LiveStart.LiveProduct).ToString();
}
catch (Exception ex)
{
Interactive.LInfoError("Could not Get version\n" + ex.Message, "Application Failure");
}
return(strVer);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (gbPass.Enabled)
{
int cmp = string.Compare(txtPass.Text.Trim(), txtConfirmPass.Text.Trim());
if (cmp != 0)
{
Interactive.LInfoError("Passwords do not match", "Users");
return;
}
}
LiveSaveInfo();
}
internal int Update(LivelogInfo r)
{
try
{
da = new tblLivelogTableAdapter();
n = da.Update(r.LogDate, r.RecordUID, r.TableName, r.UserID, r.Action, r.SystemUser, r.Computer, r.LogID);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Insert Record");
}
return(n);
}
private void SaveInfo()
{
if (FormIsValid())
{
myE = new EnrollmentInfo();
EnrollmentInfo.RegNo = txtRegNo.Text;
EnrollmentInfo.Names = txtName.Text;
EnrollmentInfo.Age = Convert.ToInt32(txtAge.Value);
EnrollmentInfo.AgeUnit = rbYr.Checked ? "Y" : "m";
EnrollmentInfo.Sex = rbM.Checked ? "M" : "F";
EnrollmentInfo.RegDate = dtpRegDate.Value;
EnrollmentInfo.Residence = txtResidence.Text;
try { EnrollmentInfo.ReferredBy = cmbReferredBy.SelectedValue.ToString(); }
catch { };
try { EnrollmentInfo.ReferredTo = cmbReferredTo.SelectedValue.ToString(); }
catch { };
EnrollmentInfo.Fcode = strFcode;
try { EnrollmentInfo.Category = cmbCategory.SelectedValue.ToString(); }
catch { };
EnrollmentInfo.ContactInfo = txtContact.Text;
try { EnrollmentInfo.Outcome = cmbOutcome.SelectedValue.ToString(); }
catch { };
if (EditFlag)
{
EnrollmentInfo.RegNo = lblRegNo.Text;
EnrollmentInfo.NewRegNo = txtRegNo.Text;
if ((Interactive.LInfoConfirm("Are you sure you want to Edit ?", "Enrollment") == DialogResult.Yes))
{
if (myE.EditEnrollment())
{
Load500Enrollments();
}
}
}
else
{
if (myE.NewEnrollment())
{
Load500Enrollments();
}
}
}
else
{
Interactive.LInfoError(err, "Enrollment");
}
}
internal int UpdatePassword(UserInfo r)
{
try
{
da = new tblUserTableAdapter();
n = da.UpdatePassword(r.Password, r.UserID);
LivelogInfo.InsertLog(DateTime.Now, UserInfo.LiveUserID, "Users", UserInfo.LiveUserID, "changed password", UserInfo.SysUserID, UserInfo.Computer);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Insert Record");
}
return(n);
}
internal int OnlineUserCount()
{
n = 0;
try
{
da = new tblUserTableAdapter();
n = Convert.ToInt32(da.UsersOnline());
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Check User");
}
return(n);
}
internal DsSecurity.tblUserDataTable ViewAllByID(string uid)
{
try
{
da = new tblUserTableAdapter();
dt = new DsSecurity.tblUserDataTable();
da.FillByUserID(dt, uid);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "View Record");
}
return(dt);
}
internal static int Capacity()
{
n = 0;
try
{
daAppointment = new TblAppointmentTableAdapter();
n = Convert.ToInt32(daAppointment.GetNoOfAppointments(Convert.ToDateTime(AppointmentInfo.Appointment.ToString("yyyy/MM/dd"))));
}
catch (Exception ex)
{
Interactive.LInfoError("Could not load Appointment Information\n" + ex.Message, "Database connection failure");
}
return(n + 1);
}
internal int Insert(UserInfo r)
{
try
{
da = new tblUserTableAdapter();
n = da.Insert(r.UserID, r.Password, r.IsActive, r.RoleID, r.FullName);
LivelogInfo.InsertLog(DateTime.Now, r.UserID, "User", UserInfo.LiveUserID, "added new record", UserInfo.SysUserID, UserInfo.Computer);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Insert Record");
}
return(n);
}
internal DsSecurity.tblRoleDataTable ViewAll()
{
try
{
da = new tblRoleTableAdapter();
dt = new DsSecurity.tblRoleDataTable();
da.Fill(dt);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "View Record");
}
return(dt);
}
internal int Delete(RoleInfo r)
{
try
{
da = new tblRoleTableAdapter();
n = da.Delete(r.RoleID);
LivelogInfo.InsertLog(DateTime.Now, r.RoleID, "Role", UserInfo.LiveUserID, "deleted record", UserInfo.SysUserID, UserInfo.Computer);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Insert Record");
}
return(n);
}
internal static int DeleteFacility()
{
n = 0;
try
{
daFacility = new TblFacilityTableAdapter();
n = daFacility.Delete1(FacilityInfo.FCode);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not Deleted!");
return(n);
}
}
internal static int DeleteReserve()
{
n = 0;
try
{
daReserve = new TblReserveTableAdapter();
n = daReserve.Delete1(ReserveInfo.Day, ReserveInfo.Month, ReserveInfo.Year);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not Deleted!");
return(n);
}
}
internal static int DeletePublicHoliday()
{
n = 0;
try
{
daPublicHoliday = new TblPublicHolidayTableAdapter();
n = daPublicHoliday.Delete1(PublicHolidayInfo.Day, PublicHolidayInfo.Month);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not Deleted!");
return(n);
}
}