public void SaveMainRow()
{
if (SelectedMainRow != null)
{
var saveRow = new TblBankDeposit();
saveRow.InjectFrom(SelectedMainRow);
if (saveRow.Status != null)
{
Client.ApproveBankDepositAsync(saveRow, (int)saveRow.Status, LoggedUserInfo.DatabasEname);
}
}
}
private void ApproveBankDeposit(TblBankDeposit newRow, int status, string company)
{
using (var context = new ccnewEntities(GetSqlConnectionString(company)))
{
var oldRow = (from e in context.TblBankDeposits
where e.Glserial == newRow.Glserial
select e).SingleOrDefault();
if (oldRow != null)
{
oldRow.Status = status;
// GenericUpdate(oldRow, newRow, context);
context.SaveChanges();
}
}
}
private int DeleteTblBankDeposit(TblBankDeposit row, string company)
{
using (var context = new ccnewEntities(GetSqlConnectionString(company)))
{
var oldRow = (from e in context.TblBankDeposits
where e.Glserial == row.Glserial
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
context.SaveChanges();
}
return(row.Glserial);
}
}
public void Delete()
{
var data = new TblBankDeposit();
data.InjectFrom(TransactionHeader);
if (AllowDelete)
{
Loading = true;
Client.DeleteTblBankDepositAsync(data, LoggedUserInfo.DatabasEname);
}
else
{
MessageBox.Show("You are Not Allowed to Delete");
}
}
public void UpdateAndInsert()
{
var valiationCollection = new List <ValidationResult>();
bool isvalid = Validator.TryValidateObject(TransactionHeader, new ValidationContext(TransactionHeader, null, null), valiationCollection, true);
if (isvalid)
{
var data = new TblBankDeposit();
data.InjectFrom(TransactionHeader);
bool save = TransactionHeader.Glserial == 0;
if (save)
{
if (AllowAdd)
{
Loading = true;
Client.UpdateOrInsertTblBankDepositAsync(data, LoggedUserInfo.DatabasEname);
}
else
{
MessageBox.Show(strings.AllowAddMsg);
}
}
else
{
if (AllowUpdate)
{
Loading = true;
Client.UpdateOrInsertTblBankDepositAsync(data, LoggedUserInfo.DatabasEname);
}
else
{
MessageBox.Show(strings.AllowUpdateMsg);
}
}
}
}
private TblBankDeposit UpdateOrInsertTblBankDeposit(TblBankDeposit newRow, string company)
{
using (var context = new ccnewEntities(GetSqlConnectionString(company)))
{
var oldRow = (from e in context.TblBankDeposits
where e.Glserial == newRow.Glserial
select e).SingleOrDefault();
if (oldRow != null)
{
// GenericUpdate(oldRow, newRow, context);
}
else
{
newRow.Iserial = Bankdigit(newRow.TblStore, true, company);
context.TblBankDeposits.AddObject(newRow);
}
context.SaveChanges();
return(newRow);
}
}
public DepositViewModel()
{
GetItemPermissions("BankDepositForm");
TransactionHeader = new TblDepositViewModel();
if (LoggedUserInfo.Store != null)
{
TransactionHeader.StorePerRow = new TblStore().InjectFrom(LoggedUserInfo.Store) as TblStore;
}
if (LoggedUserInfo.Store != null)
{
TransactionHeader.TblUser = LoggedUserInfo.Iserial;
}
MainRowList = new SortableCollectionView <TblBankDeposit>();
StoreList = new SortableCollectionView <TblStore>();
Client.SearchforsStoreNameCompleted += (m, k) =>
{
Loading = false;
StoreList = k.Result;
//OnSupplierCompleted();
};
Client.BankdigitCompleted += (w, n) =>
{
Loading = false;
TransactionHeader.Iserial = n.Result;
};
// Client.SearchBysStorEnameAsync(new ObservableCollection<int>(LoggedUserInfo.AllowedStores));
Client.SearchTblBankDepositCompleted += (y, v) =>
{
foreach (var row in v.Result)
{
Loading = false;
var newrow = new TblBankDeposit();
newrow.InjectFrom(row);
MainRowList.Add(newrow);
}
};
Client.SearchByStoreCodeCompleted += (x, y) =>
{
Loading = false;
TransactionHeader.StorePerRow = y.Result;
};
Client.UpdateOrInsertTblBankDepositCompleted += (s, x) =>
{
if (x.Error == null)
{
TransactionHeader.InjectFrom(x.Result);
MessageBox.Show("Saved Successfully");
Print();
}
else
{
MessageBox.Show(x.Error.Message);
}
// Loading = false;
//TransactionHeader.InjectFrom(x.Result);
};
Client.DeleteTblBankDepositCompleted += (w, k) =>
{
Loading = false;
TransactionHeader = new TblDepositViewModel();
};
}
