internal void SaveMainRow() { if (SelectedMainRow.SalesAmount > 0 && SelectedMainRow.Qty > 0) { tblCalliopeStoresDailySale newRow = new tblCalliopeStoresDailySale() { SalesAmount = SelectedMainRow.SalesAmount, TblStore = SelectedMainRow.TblStore, TransDate = (DateTime)SelectedMainRow.TransDate, Qty = SelectedMainRow.Qty, }; lkpClient.SaveStoreDailySalesAsync(LoggedUserInfo.Iserial, LoggedUserInfo.DatabasEname, newRow); lkpClient.SaveStoreDailySalesCompleted += (s, sv) => { if (sv.Result != null && sv.Result.Iserial > 0) { MessageBox.Show("Data Saved Successfully"); } }; } else { MessageBox.Show("Invalid Qty or Amount "); } }
public tblCalliopeStoresDailySale SaveStoreDailySales(int user, string company, tblCalliopeStoresDailySale newrow) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { //if(newrow.Iserial == 0) //{ newrow.CreatedBy = user; newrow.CreationDate = DateTime.Now; context.tblCalliopeStoresDailySales.AddObject(newrow); //} //else //{ // var oldRow = context.tblCalliopeStoresDailySales.FirstOrDefault(x => x.Iserial == newrow.Iserial); // oldRow.SalesAmount = newrow.SalesAmount; // oldRow.LastUpdatedBy = user; // oldRow.LastUpdatedDate = DateTime.Now; // context.tblCalliopeStoresDailySales.AddObject(newrow); //} context.SaveChanges(); var res = context.tblCalliopeStoresDailySales.FirstOrDefault(x => x.Iserial == newrow.Iserial); return(res); } }