private payment setLoanPaymentDetails()
{
try
{
payment _payment = new payment();
_payment.ID = IDHandller.generateID("payment");
_payment.PAYMENT_ID = IDHandller.generateCode("payment");
_payment.AMOUNT = Convert.ToDecimal(AmountTextBox.Text);
_payment.DATE_TIME = Convert.ToDateTime(PayDatePicker.Text);
_payment.PAIDBY = PayedByTextBox.Text;
_payment.REMARK = RemarkTextBox.Text;
_payment.FK_LOAN_ID = Session.SelectedLoan.ID;
_payment.STATUS = true;
_payment.INSERT_DATETIME = System.DateTime.Now;
_payment.INSERT_USER_ID = Session.LoggedEmployee.ID;
return(_payment);
}
catch
{
return(null);
}
}
private loan_type getLoanTypeData()
{
try
{
loan_type _loanType = new loan_type();
_loanType.ID = IDHandller.generateID("loan_type");
_loanType.LOAN_TYPE_ID = LoanTypeCodeTextBox.Text;
_loanType.STATUS = true;
_loanType.INSERT_USER_ID = Session.LoggedEmployee.ID;
_loanType.INSERT_DATETIME = System.DateTime.Now;
_loanType.AMOUNT = Convert.ToDecimal(LoanAmountTextBox.Text);
_loanType.INSTALLMENT = Convert.ToDecimal(InstallmentTextBox.Text);
_loanType.DAYS = Convert.ToInt32(DaysTextBox.Text);
_loanType.FULLNAME = ShortNameTextBox.Text;
_loanType.REMARK = RemarkTextBox.Text;
return(_loanType);
}
catch
{
return(null);
}
}
private void createSMS()
{
sm _nsms = new sm();
try
{
_nsms.ID = IDHandller.generateID("sms");
_nsms.PHONE_NUMBER = PhoneNumberTextBox.Text;
_nsms.CONTENT = SMSContentTextBox.Text;
_nsms.TYPE = "send";
_nsms.SENDING_STATUS = true;
_nsms.STATUS = true;
_nsms.INSERT_USER_ID = Session.LoggedEmployee.ID;
_nsms.INSERT_DATETIME = System.DateTime.Now;
_nsms.FK_EMPLOYEE_ID = Session.LoggedEmployee.ID;
_nsms.FK_CUSTOMER_ID = SelectedCustomer.ID;
SMS = _nsms;
}
catch
{
SMS = null;
}
}
private void createSMS()
{
sm _nsms = new sm();
try
{
_nsms.ID = IDHandller.generateID("sms");
_nsms.PHONE_NUMBER = SelectedCustomer.PHONE_HP1;
_nsms.CONTENT = "Dear " + LetterHandller.Uppercase(SelectedCustomer.FULLNAME) + ", We confirm loan of Rs." + AmountTextBox.Text + " has been granted." + Environment.NewLine + Messages.TTL_MSG;
_nsms.TYPE = "send";
_nsms.SENDING_STATUS = true;
_nsms.STATUS = true;
_nsms.INSERT_USER_ID = Session.LoggedEmployee.ID;
_nsms.INSERT_DATETIME = System.DateTime.Now;
_nsms.FK_EMPLOYEE_ID = Session.LoggedEmployee.ID;
_nsms.FK_CUSTOMER_ID = SelectedCustomer.ID;
SMS = _nsms;
}
catch
{
SMS = null;
}
}
public customer GetCustomerDetails(object sender, RoutedEventArgs e)
{
try
{
if (this.mode == Mode.NEW)
{
_customer.ID = IDHandller.generateID("customer");
_customer.INSERT_DATETIME = DateTime.Now;
_customer.INSERT_USER_ID = Session.LoggedEmployee.ID;
}
_customer.CUSTOMER_ID = Convert.ToInt16(CusCodeTextBox.Text);
_customer.GENDER = getGender();
_customer.ISACTIVE = true;
_customer.FK_AREA_ID = ((area)getAreaCodeComboxSelectedArea()).ID;
_customer.STATUS = true;
_customer.UPDATE_DATETIME = DateTime.Now;
_customer.UPDATE_USER_ID = Session.LoggedEmployee.ID;
return(_customer);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
public employee GetEmployeeDetails()
{
try
{
employee employee = new employee();
if (Session.SelectedEmployee != null)
{
employee.ID = Session.SelectedEmployee.ID;
}
else
{
employee.ID = IDHandller.generateID("employee");
}
employee.EMP_ID = EmpCodeTextBox.Text;
employee.FIRST_NAME = EmpFNameTextBox.Text;
employee.LAST_NAME = EmpLNameTextBox.Text;
employee.ID_TYPE = setIDType(IDTypeComboBox.Text);
employee.ID_NUM = IDNumberTextBox.Text;
employee.DOB = Convert.ToDateTime(EmpBirthDayPicker.SelectedDate);
employee.GENDER = getGender();
employee.ADDRESS = EmpAddressTextBox.Text;
employee.PHONE_HP1 = EmpHandPhone1TextBox.Text;
employee.PHONE_HP2 = EmpHandPhone2TextBox.Text;
employee.PHONE_RECIDENCE = EmpRecedencePhoneTextBox.Text;
employee.EMAIL = EmpEmailTextBox.Text;
employee.RELIGION = EmpReligionTextBox.Text;
employee.CIVIL_STATUS = EmpCivilStateTextBox.Text;
employee.NATIONALITY = EmpNationalityTextBox.Text;
employee.PROFPIC = _imageData;
employee.ACCOUNT_TYPE = AccountTypeComboBox.Text;
employee.PASSWORD = PasswordTextBox.Password;
employee.USERNAME = UserNameTextBox.Text;
employee.ISRESIGN = false;
employee.STATUS = true;
employee.INSERT_DATETIME = DateTime.Now;
employee.INSERT_USER_ID = Session.LoggedEmployee.ID;
employee.UPDATE_DATETIME = DateTime.Now;
employee.UPDATE_USER_ID = Session.LoggedEmployee.ID;
return(employee);
}
catch (Exception)
{
return(null);
}
}
private area GetAreaDetails()
{
try
{
_area.ID = IDHandller.generateID("area");
_area.STATUS = true;
_area.INSERT_DATETIME = DateTime.Now;
_area.INSERT_USER_ID = Session.LoggedEmployee.ID;
_area.UPDATE_DATETIME = DateTime.Now;
_area.UPDATE_USER_ID = Session.LoggedEmployee.ID;
return(_area);
}
catch (Exception)
{
return(null);
}
}
private loan getLoanData()
{
try
{
loan _loan = new loan();
if (_viewmode.Equals(Mode.NEW))
{
_loan.ID = IDHandller.generateID("loan");
_loan.STATUS = true;
_loan.INSERT_USER_ID = Session.LoggedEmployee.ID;
_loan.INSERT_DATETIME = System.DateTime.Now;
}
else if (_viewmode.Equals(Mode.EDIT))
{
_loan.ID = IDHandller.generateID("loan");
_loan.STATUS = true;
_loan.UPDATE_USER_ID = Session.LoggedEmployee.ID;
_loan.UPDATE_DATETIME = System.DateTime.Now;
}
_loan.FK_EMPLOYEE_ID = SelectedEmployee.ID;
_loan.FK_CUSTOMER_ID = SelectedCustomer.ID;
_loan.FK_LOAN_TYPE_ID = SelectedLoan_Type.ID;
_loan.FK_BRANCH_ID = "1";
_loan.LOAN_ID = LoanCodeTextBox.Text;
_loan.AMOUNT = Convert.ToDecimal(AmountTextBox.Text);
_loan.INSTALLMENT = Convert.ToDecimal(InstalmentTextBox.Text);
_loan.START_DATE = Convert.ToDateTime(StartDateDatePicker.SelectedDate);
_loan.END_DATE = Convert.ToDateTime(EndDateDatePicker.SelectedDate);
_loan.REMARK = RemarkTextBox.Text;
_loan.LOAN_STATUS = true;
return(_loan);
}
catch
{
return(null);
}
}
private employee_cash getEmployee_CashReturn()
{
employee_cash emp_cash = new employee_cash();
emp_cash.ID = IDHandller.generateID("employee_cash");
emp_cash.TYPE = type;
emp_cash.AMOUNT = Amount;
emp_cash.TRANSACTION_DATE_TIME = BorrowDateTime;
emp_cash.REMARK = Remark;
emp_cash.STATUS = true;
emp_cash.INSERT_DATETIME = DateTime.Now;
emp_cash.INSERT_USER_ID = Session.LoggedEmployee.ID;
emp_cash.UPDATE_DATETIME = DateTime.Now;
emp_cash.UPDATE_USER_ID = Session.LoggedEmployee.ID;
emp_cash.FK_EMPLOYEE_ID = Session.SelectedEmployee.ID;
return(emp_cash);
}
private void EmpCodeGenButton_Click(object sender, RoutedEventArgs e)
{
EmpCodeTextBox.Text = IDHandller.generateCode("employee");
}
private void LoanTypeCodeGenButton_Click(object sender, RoutedEventArgs e)
{
LoanTypeCodeTextBox.Text = IDHandller.generateCode("loan_type");
}
