private void btnSave_Click(object sender, EventArgs e)
{
revenue _revenue = new revenue();
if (IsEdit == true)
{
_revenue = _db.GetRevenueById(this.RecordId, databaseId);
}
_revenue.Users = Convert.ToInt32(txtUsers.Text);
_revenue.PriceFixedUntil = rdPriceFixedUnitl.Value;
_revenue.RevenueAmount = Convert.ToDecimal(txtRevenue.Text);
_revenue.customerid = CustomerId;
_revenue.Year = Convert.ToInt16(cboYear.Text);
_revenue.isActive = true;
_revenue.CreatedDate = DateTime.Now;
_revenue.databaseID = databaseId;
if (IsEdit == false)
{
_db.AddToRevenue(_revenue);
_db.SaveChanges();
MessageBox.Show("Revenue Saved", "Revenue has been Created ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
_db.SaveRevenue(_revenue);
_db.SaveChanges();
MessageBox.Show("Revenue Saved", "Revenue has been updated ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.Close();
}
public void SaveRevenue(revenue _reve)
{
try
{
using (var ctx = new customerDbEntities())
{
ctx.revenues.Add(_reve);
ctx.Entry(_reve).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public void addExpense(double amt, string lbl)
{
revenue newExpense = new revenue();
newExpense.amount = amt;
newExpense.label = lbl;
expenses.Add(newExpense);
}
public void addIncome(double amt, string lbl)
{
revenue newIncome = new revenue();
newIncome.amount = amt;
newIncome.label = lbl;
incomes.Add(newIncome);
}
public revenue GetRevenueById(int id, int databaseId)
{
revenue q = new revenue();
using (var myContext = new customerDbEntities())
{
q = myContext.revenues.Where(w => w.id == id && w.databaseID == databaseId).FirstOrDefault();
}
return(q);
}
private void btnDeleteRevenue_Click(object sender, EventArgs e)
{
revenue _deleteRevenue = new revenue();
_deleteRevenue = CustomerDb.GetRevenueById(Revenueid, DatabaseId);
DialogResult dialogResult = MessageBox.Show(this, "Are you sure you wish to Delete Revenue ", "Delete Revenue", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
CustomerDb.DeleteRevenue(_deleteRevenue);
BindRevenue(CustomerId);
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
BindRevenue(CustomerId);
}
private void frmRevenue_Load(object sender, EventArgs e)
{
if (IsEdit)
{
revenue _revenue = new revenue();
_revenue = _db.GetRevenueById(this.RecordId, databaseId);
txtUsers.Text = _revenue.Users.ToString();
txtRevenue.Text = _revenue.RevenueAmount.ToString();
cboYear.SelectedText = _revenue.Year.ToString();
if (_revenue.PriceFixedUntil != null)
{
rdPriceFixedUnitl.Value = (DateTime)_revenue.PriceFixedUntil;
}
}
cboYear.DataSource = Enumerable.Range(2015, DateTime.Today.Year).ToList();
}
public void AddToRevenue(revenue newReve)
{
using (var myContext = new customerDbEntities())
{
myContext.revenues.Add(newReve);
try
{
myContext.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Console.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
private void txtrevenuecode_LostFocus(object sender, RoutedEventArgs e)
{
try
{
revenue rev = new revenue();
string a = "Update", b = Convert.ToString(Save.Content);
if (b == a)
{
rev.REVENUE_CODE = txtrevenuecode.Text;
rev.UPDATE_BY = login.u;
rev.UPDATE_DATE = DateTime.Today;
rev.Retrive();
txtname.Text = rev.NAME;
COMBOBOX2.Text = rev.MISCELLANOUS;
COMBOBOX3.Text = rev.PRINT_VOUCHER;
txttaxstructure.Text = rev.TAX_STRUCTURE;
txtmistaxstructure.Text = rev.MIS_TAX_STRUCTURE;
COMBOBOX4.Text = rev.STATUS;
}
}
catch (Exception) { }
}
private void Save_Click(object sender, RoutedEventArgs e)
{
try
{
if (error != 0 || txtrevenuecode.Text == "" || txtname.Text == "" || txttaxstructure.Text == "" || txtmistaxstructure.Text == "")
{
// pop1.IsOpen = true;
if (txtrevenuecode.Text == "")
{
txtrevenuecode.Text = "";
}
if (txtname.Text == "")
{
txtname.Text = "";
}
if (txttaxstructure.Text == "")
{
txttaxstructure.Text = "";
}
if (txtmistaxstructure.Text == "")
{
txtmistaxstructure.Text = "";
}
}
else
{
revenue rev = new revenue();
rev.REVENUE_CODE = txtrevenuecode.Text;
rev.NAME = txtname.Text;
rev.MISCELLANOUS = COMBOBOX2.Text;
rev.PRINT_VOUCHER = COMBOBOX3.Text;
rev.TAX_STRUCTURE = txttaxstructure.Text;
rev.MIS_TAX_STRUCTURE = txtmistaxstructure.Text;
rev.STATUS = COMBOBOX4.Text;
// ss rr ii u ii 11/15/2017
//rev.USER_NAME = login.u;
rev.INSERT_BY = login.u;
rev.INSERT_DATE = DateTime.Today;
// add.IsEnabled = true;
// Modify.IsEnabled = true;
// Save.IsEnabled = false;
// clear.IsEnabled = false;
string a1 = "Save", b1 = Convert.ToString(Save.Content);
if (b1 == a1)
{
//Save.Content = "Save";
//insert.Content = "Inserted Sucessfully";
//pop2.IsOpen = true;
rev.Insert();
DataTable dt = rev.fill_revenuegrid();
dgrevenue.ItemsSource = dt.DefaultView;
//MessageBox.Show("inserted sucessfully");
popup_insert.IsOpen = true;
}
string a = "Update", b = Convert.ToString(Save.Content);
if (b == a)
{
//insert.Content = "Updated Sucessfully";
//pop2.IsOpen = true;
rev.UPDATE();
DataTable dt = rev.fill_revenuegrid();
dgrevenue.ItemsSource = dt.DefaultView;
//MessageBox.Show("updated sucessfully");
popup_update.IsOpen = true;
}
clearing();
this.NavigationService.Refresh();
txtrevenuecode.IsEnabled = false;
txttaxstructure.IsEnabled = false;
txtname.IsEnabled = false;
txtmistaxstructure.IsEnabled = false;
COMBOBOX2.IsEnabled = false;
COMBOBOX3.IsEnabled = false;
COMBOBOX4.IsEnabled = false;
Save.Content = "Save";
// add.Background = new SolidColorBrush(Color.FromRgb(53, 71, 102));
// Modify.Background = new SolidColorBrush(Color.FromRgb(53, 71, 102));
}
}
catch (Exception)
{
MessageBox.Show("please Enter correct values");
}
}
