private void dgrdChequeBook_SelectionChanged(object sender, EventArgs e)
{
if (dgrdChequeBook.SelectedRows.Count != 0)
{
SelectedChequeID = Convert.ToInt32(dgrdChequeBook.SelectedRows[0].Cells[0].Value);
_chequebook = ChequeBookList.Find(a => a.ChequeBookID == SelectedChequeID);
if (_chequebook != null)
{
ShowGUI(_chequebook);
}
// financialyear = SelectedFinancialYear;
}
}
public static List<ChequeBook> GetAllCheques()
{
List<ChequeBook> ChequeBookList = new List<ChequeBook>();
NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
var _ChequeBook = from Cheque in newAppsCnn.Acc_ChequeBook select Cheque;
foreach (var chequebook in _ChequeBook)
{
ChequeBook chkbook = new ChequeBook();
chkbook.ChequeBookID = chequebook.ChequeBookID;
chkbook.CheuqeBookName_Ara = chequebook.CheuqeBookName_Ara;
chkbook.CheuqeBookName_Eng = chequebook.CheuqeBookName_Eng;
chkbook.ChequeStartNo = chequebook.ChequeStartNo;
chkbook.CHequeEndno = chequebook.CHequeEndno;
chkbook.IsDisable = chequebook.IsDisable;
chkbook.ChequeCurrancyId = chequebook.ChequeCurrancyId;
chkbook.BankAccountId = chequebook.BankAccountId;
ChequeBookList.Add(chkbook);
}
return ChequeBookList;
}
public static List<ChequeBook> GetAllAccounts()
{
List<ChequeBook> ChequeBookList = new List<ChequeBook>();
NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
var _BankAccounts = from Cheque in newAppsCnn.Acc_Accounts.Where(a => a.AccountCategoryId == 1) select Cheque;
foreach (var account in _BankAccounts)
{
ChequeBook bankaccount = new ChequeBook();
bankaccount.AccountName_Ar = account.AccountName_Ar;
bankaccount.AccountName_En = account.AccountName_Eng;
bankaccount.AccountId = account.AccountID;
ChequeBookList.Add(bankaccount);
}
return ChequeBookList;
}
private Acc_ChequeBook BuildDBRecord(Acc_ChequeBook _Acc_ChequeBook, ChequeBook _ChequeBook)
{
if (_ChequeBook.ChequeBookID != -1)
{
_Acc_ChequeBook.ChequeBookID = _ChequeBook.ChequeBookID;
}
_Acc_ChequeBook.CheuqeBookName_Ara = _ChequeBook.CheuqeBookName_Ara;
_Acc_ChequeBook.CheuqeBookName_Eng = _ChequeBook.CheuqeBookName_Eng;
_Acc_ChequeBook.ChequeStartNo = _ChequeBook.ChequeStartNo;
_Acc_ChequeBook.CHequeEndno = _ChequeBook.CHequeEndno;
_Acc_ChequeBook.IsDisable = _ChequeBook.IsDisable;
_Acc_ChequeBook.BankAccountId = _ChequeBook.BankAccountId;
_Acc_ChequeBook.ChequeCurrancyId = _ChequeBook.ChequeCurrancyId;
return _Acc_ChequeBook;
}
public DataSaveResult Save(ChequeBook _ChequeBook)
{
try
{
Acc_ChequeBook Acc_ChequeBook;
NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
Acc_ChequeBook = newAppsCnn.Acc_ChequeBook.Where(a => a.ChequeBookID == _ChequeBook.ChequeBookID).FirstOrDefault();
if (Acc_ChequeBook != null)
{
BuildDBRecord(Acc_ChequeBook, _ChequeBook);
}
else
{
Acc_ChequeBook = new Acc_ChequeBook();
Acc_ChequeBook = BuildDBRecord(Acc_ChequeBook, _ChequeBook);
newAppsCnn.Acc_ChequeBook.Add(Acc_ChequeBook);
}
newAppsCnn.SaveChanges();
// Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Acc_VouchersType", this);
return new DataSaveResult() { SaveStatus = true };
}
catch (Exception ex)
{
return new DataSaveResult() { SaveStatus = false };
}
}
private void ShowGUI(ChequeBook _ChequeBook)
{
if (!string.IsNullOrEmpty(_ChequeBook.CheuqeBookName_Ara))
{
txtArabicName.Text = _ChequeBook.CheuqeBookName_Ara;
}
if (!string.IsNullOrEmpty(_ChequeBook.CheuqeBookName_Eng))
{
txtEnglishName.Text = _ChequeBook.CheuqeBookName_Eng;
}
cbxCurrency.SelectedValue = _ChequeBook.ChequeCurrancyId;
if (!string.IsNullOrEmpty(_ChequeBook.BankAccountId))
{
cbxBanckAccounts.SelectedValue = _ChequeBook.BankAccountId;
}
chkIsDisabled.Checked = _ChequeBook.IsDisable;
numStart.Value = Convert.ToDecimal(_ChequeBook.ChequeStartNo);
numEnd.Value = Convert.ToDecimal(_ChequeBook.CHequeEndno);
}
private void GetDataFromGUI()
{
_chequebook = new ChequeBook();
_chequebook.ChequeBookID = SelectedChequeID;
_chequebook.CheuqeBookName_Ara = txtArabicName.Text;
_chequebook.CheuqeBookName_Eng = txtEnglishName.Text;
_chequebook.ChequeCurrancyId = Convert.ToInt32(cbxCurrency.SelectedValue);
_chequebook.IsDisable = chkIsDisabled.Checked;
_chequebook.BankAccountId = cbxBanckAccounts.SelectedValue.ToString();
_chequebook.ChequeStartNo = Convert.ToInt32(numEnd.Value);
_chequebook.CHequeEndno = Convert.ToInt32(numEnd.Value);
}
private void frmChequeBook_Save(object sender, ref bool _status)
{
ChequeBook cheque = new ChequeBook();
GetDataFromGUI();
DataSaveResult saveResult = cheque.Save(_chequebook);
if (saveResult.SaveStatus == false)
{
_status = false;
}
else
{
ChequeBookList = ChequeBook.GetAllCheques();
LoadDataGrid(ChequeBookList);
}
dgrdChequeBook.Enabled = true;
dgrdChequeBook.Rows[SelectedRow].Selected = true;
dgrdChequeBook_SelectionChanged(dgrdChequeBook, new EventArgs());
}
private void frmChequeBook_Delete(object sender, ref bool _status)
{
_chequebook = new ChequeBook();
if (SelectedChequeID == -1)
{
_status = false;
return;
}
DataDeleteResult result = _chequebook.Delete(SelectedChequeID);
_status = result.DeleteStatus;
if (result.DeleteStatus == false)
{
MessageBox.Show(result.ErrorMessage);
}
else
{
ChequeBookList = ChequeBook.GetAllCheques();
LoadDataGrid(ChequeBookList);
dgrdChequeBook.Rows[0].Selected = true;
}
}