public frmStruckOffMemberReport()
{
InitializeComponent();
try
{
var NUBE = db.MASTERNUBEBRANCHes.OrderBy(x => x.NUBE_BRANCH_NAME).ToList();
cmbNubeBranch.ItemsSource = NUBE;
cmbNubeBranch.SelectedValuePath = "NUBE_BRANCH_CODE";
cmbNubeBranch.DisplayMemberPath = "NUBE_BRANCH_NAME";
var bank = db.MASTERBANKs.OrderBy(x => x.BANK_NAME).ToList();
cmbBank.ItemsSource = bank;
cmbBank.SelectedValuePath = "BANK_CODE";
cmbBank.DisplayMemberPath = "BANK_NAME";
this.KeyDown += new System.Windows.Input.KeyEventHandler(Window_KeyDown);
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
public static void EventHistory(string FormName = "", int Event = 0, string OldData = "", string NewData = "", string TblName = "", string Remarks = "")
{
try
{
EventHistory eh = new EventHistory();
eh.UserId = AppLib.iUserCode;
eh.FormName = FormName;
eh.Event = Event;
eh.UpdatedOn = DateTime.Now;
eh.BeforeData = OldData;
eh.ModifiedData = NewData;
eh.TableName = TblName;
eh.Remarks = Remarks;
db.EventHistories.Add(eh);
db.SaveChanges();
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
//User defined
private void LoadReport()
{
try
{
MemberReport.Reset();
DataTable dt = getData();
DataTable rt = getResignData();
if (dt.Rows.Count > 0)
{
//if (chkSimple.IsChecked == true)
//{
// dgvResigned.ItemsSource = dt.DefaultView;
//}
//else
//{
ReportDataSource masterData = new ReportDataSource("Resign", dt);
MemberReport.LocalReport.DataSources.Add(masterData);
ReportDataSource master = new ReportDataSource("ResignStatus", rt);
MemberReport.LocalReport.DataSources.Add(master);
MemberReport.LocalReport.ReportEmbeddedResource = "Nube.Reports.rptResign.rdlc";
ReportParameter RP = new ReportParameter("TotalMember", dt.Rows.Count.ToString());
MemberReport.LocalReport.SetParameters(RP);
MemberReport.RefreshReport();
LoadBankReport();
//}
}
else
{
MessageBox.Show("No Records Found!");
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
public void FormLoad(decimal id, DateTime doj, string bank, string branch, string monBF, string monSub, string Type)
{
try
{
InitializeComponent();
NoOfKey = 0;
txtMemberID.Text = id.ToString();
dtpDOJ.SelectedDate = doj.Date;
txtBankName.Text = bank;
txtBranchkName.Text = branch;
txtMonthlyBF.Text = monBF.ToString();
txtMonthlySub.Text = monSub.ToString();
txtType.Text = Type.ToString();
var mm = dbBFS.MASTERMEMBERs.FirstOrDefault(x => x.MEMBER_ID == id);
if (mm != null)
{
txtBankName.Text = mm.MASTERBANK.BANK_USERCODE.ToString();
txtMemberName.Text = mm.MEMBER_NAME;
var mmStatusLast = dbBFS.MemberMonthEndStatus.OrderByDescending(x => x.StatusMonth).FirstOrDefault(x => x.MEMBER_CODE == mm.MEMBER_CODE);
if (mmStatusLast != null)
{
txtLastPaymentDate.Text = string.Format("{0:MMM-yyyy}", mmStatusLast.LASTPAYMENTDATE);
var st = dbBFS.MASTERSTATUS.FirstOrDefault(x => x.STATUS_CODE == mmStatusLast.STATUS_CODE);
if (st != null)
{
txtStatus.Text = st.STATUS_NAME;
}
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
void UserRights()
{
try
{
userPrevilage = new UserPrevilage(this.btnBank.Tag.ToString());
if (userPrevilage.Show == true)
{
btnBank.IsEnabled = true;
}
else
{
btnBank.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnBranch.Tag.ToString());
if (userPrevilage.Show == true)
{
btnBranch.IsEnabled = true;
}
else
{
btnBranch.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnNUBEBranch.Tag.ToString());
if (userPrevilage.Show == true)
{
btnNUBEBranch.IsEnabled = true;
}
else
{
btnNUBEBranch.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnPersonTitle.Tag.ToString());
if (userPrevilage.Show == true)
{
btnPersonTitle.IsEnabled = true;
}
else
{
btnPersonTitle.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnSalutation.Tag.ToString());
if (userPrevilage.Show == true)
{
btnSalutation.IsEnabled = true;
}
else
{
btnSalutation.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnRelationSetup.Tag.ToString());
if (userPrevilage.Show == true)
{
btnRelationSetup.IsEnabled = true;
}
else
{
btnRelationSetup.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnReasonSetup.Tag.ToString());
if (userPrevilage.Show == true)
{
btnReasonSetup.IsEnabled = true;
}
else
{
btnReasonSetup.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnNameSetup.Tag.ToString());
if (userPrevilage.Show == true)
{
btnNameSetup.IsEnabled = true;
}
else
{
btnNameSetup.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnCity.Tag.ToString());
if (userPrevilage.Show == true)
{
btnCity.IsEnabled = true;
}
else
{
btnCity.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnStateSetup.Tag.ToString());
if (userPrevilage.Show == true)
{
btnStateSetup.IsEnabled = true;
}
else
{
btnStateSetup.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnMonthEndClosing.Tag.ToString());
if (userPrevilage.Show == true)
{
btnMonthEndClosing.IsEnabled = true;
}
else
{
btnMonthEndClosing.IsEnabled = false;
}
userPrevilage = new UserPrevilage(this.btnYearEndClosing.Tag.ToString());
if (userPrevilage.Show == true)
{
btnYearEndClosing.IsEnabled = true;
}
else
{
btnYearEndClosing.IsEnabled = false;
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
private void LoadReport()
{
try
{
MemberReport.Reset();
DataTable dt = new DataTable();
dt = getData();
if (dt.Rows.Count > 0)
{
string Total = dt.Rows.Count.ToString();
ReportDataSource masterData = new ReportDataSource("ActiveMember", dt);
MemberReport.LocalReport.DataSources.Add(masterData);
ReportDataSource Data = new ReportDataSource("DataSet1", dt);
MemberReport.LocalReport.DataSources.Add(Data);
MemberReport.LocalReport.ReportEmbeddedResource = "Nube.Reports.frmActiveMemberReport.rdlc";
ReportParameter[] NB = new ReportParameter[5];
if (!string.IsNullOrEmpty(cmbNubeBranch.Text))
{
NB[0] = new ReportParameter("NubeBranchName", "NUBE BRANCH - " + cmbNubeBranch.Text.ToString());
}
else
{
NB[0] = new ReportParameter("NubeBranchName", "");
}
if (!string.IsNullOrEmpty(cmbBank.Text))
{
NB[1] = new ReportParameter("BankName", "BANK - " + cmbBank.Text.ToString());
}
else
{
NB[1] = new ReportParameter("BankName", "");
}
if (!string.IsNullOrEmpty(cmbBranch.Text))
{
NB[2] = new ReportParameter("BranchName", "BANK BRANCH - " + cmbBranch.Text.ToString());
}
else
{
NB[2] = new ReportParameter("BranchName", "");
}
NB[3] = new ReportParameter("TotalMember", Total);
if (sForm_Name == "NewMemberReport")
{
NB[4] = new ReportParameter("Title", "NEW MEMBER REPORT");
}
else
{
NB[4] = new ReportParameter("Title", "ACTIVE MEMBER REPORT");
}
MemberReport.LocalReport.SetParameters(NB);
MemberReport.RefreshReport();
LoadBankReport(dt);
}
else
{
MessageBox.Show("No Records Found!");
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
private void BgWorker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
string DBPath = "";
string str = "";
var dt = (from x in db.Tran_Start where x.EntryDate == DateTime.Today.Date select x).FirstOrDefault();
if (dt == null)
{
var qry = (from x in db.MASTERNAMESETUPs select x).FirstOrDefault();
// ######### VERSION 1 BACKUP ##############
if (qry.NEWEXEPATH != null)
{
str = qry.NEWEXEPATH.ToString();
if (str.Contains(".") == true)
{
string[] path = qry.NEWEXEPATH.Split('.');
DBPath = path[0];
}
else
{
DBPath = qry.NEWEXEPATH.ToString();
}
try
{
using (SqlConnection con = new SqlConnection(AppLib.connStr))
{
string sBack = " BACKUP DATABASE " + qry.NEWREPORTSPATH + " \r" +
" TO DISK='" + DBPath.ToString() + string.Format("{0:ddMMMyyyy}", DateTime.Today) + ".bak'";
SqlCommand cmd = new SqlCommand(sBack, con);
cmd.Connection.Open();
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery();
sBack = " xp_cmdshell 'del " + DBPath.ToString() + string.Format("{0:ddMMMyyyy}", DateTime.Now.AddDays(-3)) + ".bak'";
cmd = new SqlCommand(sBack, con);
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
else
{
MessageBox.Show("Please Enter the Daily Backup Path Correctly!", "VERSION 1 Daily BackUp Error");
}
// ######### VERSION 2 BACKUP ##############
if (qry.BackUpPath != null)
{
str = qry.BackUpPath.ToString();
if (str.Contains(".") == true)
{
string[] path = qry.BackUpPath.Split('.');
DBPath = path[0];
}
else
{
DBPath = qry.BackUpPath.ToString();
}
try
{
using (SqlConnection con = new SqlConnection(AppLib.connStr))
{
string sBack = " BACKUP DATABASE " + con.Database + " \r" +
" TO DISK='" + DBPath.ToString() + string.Format("{0:ddMMMyyyy}", DateTime.Today) + ".bak'";
SqlCommand cmd = new SqlCommand(sBack, con);
cmd.Connection.Open();
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery();
sBack = " xp_cmdshell 'del " + DBPath.ToString() + string.Format("{0:ddMMMyyyy}", DateTime.Now.AddDays(-3)) + ".bak'";
cmd = new SqlCommand(sBack, con);
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
else
{
MessageBox.Show("Please Enter the Daily Backup Path Correctly!", "VERSION 2 Daily BackUp Error");
}
var TS = (from x in db.Tran_Start where x.Id == 1 select x).FirstOrDefault();
if (TS != null)
{
TS.EntryDate = DateTime.Now.Date;
TS.UserId = AppLib.iUserCode;
TS.UpdatedTime = DateTime.Now;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
private void txtMemberID_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.Enter && !string.IsNullOrEmpty(txtMemberID.Text))
{
decimal dMemberId = Convert.ToDecimal(txtMemberID.Text);
var mm = (from x in dbBFS.TVMASTERMEMBERs where x.MEMBER_ID == dMemberId select x).FirstOrDefault();
if (mm != null)
{
dgvDetails.ItemsSource = null;
txtBankName.Text = mm.BANK_USERCODE;
txtBranchkName.Text = mm.BRANCHNAME;
dtpDOJ.SelectedDate = mm.DATEOFJOINING;
txtType.Text = mm.MEMBERTYPE_NAME;
txtMonthlyBF.Text = mm.MONTHLYBF.ToString();
txtMonthlySub.Text = mm.MONTHLYSUBSCRIPTION.ToString();
txtMemberName.Text = mm.MEMBER_NAME.ToString();
txtStatus.Text = mm.MEMBERSTATUS.ToString();
txtLastPaymentDate.Text = string.Format("{0:MMM-yyyy}", mm.LASTPAYMENT_DATE);
using (SqlConnection con = new SqlConnection(AppLib.connStr))
{
progressBar1.Minimum = 1;
progressBar1.Maximum = 10;
progressBar1.Visibility = Visibility.Visible;
con.Open();
progressBar1.Value = 2;
System.Windows.Forms.Application.DoEvents();
SqlCommand cmd = new SqlCommand("SPMEMBERHISTORY", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MEMBER_CODE", mm.MEMBER_CODE));
progressBar1.Value = 5;
System.Windows.Forms.Application.DoEvents();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.SelectCommand.CommandTimeout = 0;
DataTable dt = new DataTable();
adp.Fill(dt);
progressBar1.Value = 7;
System.Windows.Forms.Application.DoEvents();
if (dt.Rows.Count > 0)
{
progressBar1.Value = 9;
System.Windows.Forms.Application.DoEvents();
dgvDetails.ItemsSource = dt.DefaultView;
}
else
{
MessageBox.Show("No Data Found");
}
progressBar1.Value = 10;
System.Windows.Forms.Application.DoEvents();
progressBar1.Visibility = Visibility.Hidden;
}
}
else
{
txtBankName.Text = "";
txtBranchkName.Text = "";
dtpDOJ.Text = "";
txtType.Text = "";
txtMonthlyBF.Text = "";
txtMonthlySub.Text = "";
txtMemberName.Text = "";
txtStatus.Text = "";
txtLastPaymentDate.Text = "";
MessageBox.Show("No Data Found", "Invalid Membership");
progressBar1.Visibility = Visibility.Hidden;
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
progressBar1.Visibility = Visibility.Hidden;
}
}
