public SearchChequeViewModel()
{
if (!IsDesignTime)
{
Glclient = new GlServiceClient();
MainRowList = new SortableCollectionView <TblBankCheque>();
SelectedMainRow = new TblBankCheque();
Glclient.CreateChequeCompleted += (s, sv) => GetMaindata();
Glclient.GetTblBankChequeCompleted += (s, sv) =>
{
foreach (var row in sv.Result)
{
MainRowList.Add(row);
}
if (Bank != 0 && ValuesObjects != null && (!MainRowList.Any() && ValuesObjects.ContainsKey("Cheque0")))
{
var res = MessageBox.Show("This Cheque is Not Found Do You Want To Create It ?", "Create Cheque",
MessageBoxButton.OKCancel);
if (res == MessageBoxResult.OK)
{
Glclient.CreateChequeAsync(Bank, (long)ValuesObjects.FirstOrDefault(w => w.Key == "Cheque0").Value, 1, LoggedUserInfo.DatabasEname);
}
}
Loading = false;
FullCount = sv.fullCount;
};
}
}
private List <TblBankCheque> CreateCheque(int tblBank, long from, int to, string company)
{
var ints = new List <TblBankCheque>();
using (var entity = new ccnewEntities(GetSqlConnectionString(company)))
{
var bank = entity.TblBanks.FirstOrDefault(w => w.Iserial == tblBank);
long difference = (from + to) - from;
for (int i = 0; i < difference; i++)
{
var newCheque = new TblBankCheque
{
TblCurrency = bank.TblCurrency,
Cheque = i + from,
Amount = 0,
TblGlChequeStatus = 4,
TblBank = tblBank,
TransDate = DateTime.Now,
};
entity.TblBankCheques.AddObject(newCheque);
entity.SaveChanges();
ints.Add(newCheque);
}
}
return(ints);
}
