public static void insert(tbl_ExpenceSubHead esh)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_ExpenceSubHead.Add(esh);
db.SaveChanges();
}
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 delete(tbl_ExpenceSubHead esh)
{
RMSDBEntities db = DBContext.getInstance();
Expence.deleteBySubExpenceHeadId(esh.Id);
db.tbl_ExpenceSubHead.Remove(esh);
db.SaveChanges();
}
public static void update(tbl_ExpenceSubHead esh)
{
RMSDBEntities db = DBContext.getInstance();
db.Entry(esh).State = EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
}
private void btn_UpdateExpenceSubHead(object sender, RoutedEventArgs e)
{
if (dg_AllExpenceSubHeads.SelectedItem != null)
{
SubHeadHeadNameModel mm = (SubHeadHeadNameModel)dg_AllExpenceSubHeads.SelectedItem;
tbl_ExpenceSubHead esh = ExpenceSubHead.getById(mm.Id);
var dialog = new Form_InputDialog(mm.Name);
if (dialog.ShowDialog() == true)
{
esh.Name = dialog.ResponseText;
ExpenceSubHead.update(esh);
AutoClosingMessageBox.Show("Expence Sub-Head Updated", "Success", 3000);
initFormOperations();
}
}
}
private void btn_DeleteExpenceSubHead(object sender, RoutedEventArgs e)
{
if (dg_AllExpenceSubHeads.SelectedItem != null)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Your step will delete all Expences Related to this Sub-Head.", "Delete Confirmation", System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
SubHeadHeadNameModel mm = (SubHeadHeadNameModel)dg_AllExpenceSubHeads.SelectedItem;
tbl_ExpenceSubHead esh = ExpenceSubHead.getById(mm.Id);
ExpenceSubHead.delete(esh);
AutoClosingMessageBox.Show("Expence Sub-Head Deleted", "Deleted", 3000);
initFormOperations();
}
}
else
{
AutoClosingMessageBox.Show("Select A Item", "Alert", 3000);
}
}
private void btn_SaveSubHead(object sender, RoutedEventArgs e)
{
if (tb_ExpenceSubHead.Text != "")
{
if (cb_AllExpenceHeads.SelectedItem != null)
{
tbl_ExpenceSubHead esh = new tbl_ExpenceSubHead();
esh.Name = tb_ExpenceSubHead.Text;
esh.ExpenseHead_Id = (int)cb_AllExpenceHeads.SelectedValue;
ExpenceSubHead.insert(esh);
AutoClosingMessageBox.Show("Sub Head Added", "Success", 3000);
initFormOperations();
}
else
{
AutoClosingMessageBox.Show("Select a Head", "Alert", 3000);
}
}
else
{
AutoClosingMessageBox.Show("Please Enter Name", "Alert", 3000);
}
}
