private void btn_Save(object sender, RoutedEventArgs e)
{
if (dg_AllExpenceHeads.SelectedItem != null || dg_AllExpenceSubHeads.SelectedItem != null || dg_AllExpenceSubHeads.SelectedItem != null || tb_Cost.Text != null)
{
try
{
tbl_ExpenceHead eh = (tbl_ExpenceHead)dg_AllExpenceHeads.SelectedItem;
tbl_ExpenceSubHead esh = (tbl_ExpenceSubHead)dg_AllExpenceSubHeads.SelectedItem;
string name = tb_Name.Text;
int cost = Convert.ToInt32(tb_Cost.Text);
tbl_Expence expence = new tbl_Expence();
expence.Comment = name;
expence.Amount = cost;
expence.ExpenseHead_Id = eh.Id;
expence.ExpenceSubHead_Id = esh.Id;
DateTime date = DateTime.Now;
expence.DatenTime = date;
Expence.insert(expence);
AutoClosingMessageBox.Show("Expence Added", "Success", 3000);
Close();
}
catch
{
AutoClosingMessageBox.Show("Some Error Occures", "Failed", 3000);
}
}
else
{
AutoClosingMessageBox.Show("Please Insert Data Properly", "Alert", 3000);
}
}
public static void insert(tbl_Expence e)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_Expence.Add(e);
db.SaveChanges();
}
public static void deleteById(int id)
{
RMSDBEntities db = DBContext.getInstance();
tbl_Expence e = db.tbl_Expence.Find(id);
db.tbl_Expence.Remove(e);
db.SaveChanges();
}
