public static void insert(tbl_ExpenceHead eh)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_ExpenceHead.Add(eh);
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 update(tbl_ExpenceHead eh)
{
RMSDBEntities db = DBContext.getInstance();
db.Entry(eh).State = EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
}
public static void delete(tbl_ExpenceHead eh)
{
RMSDBEntities db = DBContext.getInstance();
ExpenceSubHead.deleteByExpenceHeadId(eh.Id);
Expence.deleteByExpenceHeadId(eh.Id);
db.tbl_ExpenceHead.Remove(eh);
db.SaveChanges();
}
private void dg_AllExpenceHeads_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
dg_AllExpenceSubHeads.Items.Clear();
tbl_ExpenceHead eh = (tbl_ExpenceHead)dg_AllExpenceHeads.SelectedItem;
foreach (tbl_ExpenceSubHead esh in ExpenceSubHead.getAllByExpenceHeadId(eh.Id))
{
dg_AllExpenceSubHeads.Items.Add(esh);
}
}
private void btn_SaveHead(object sender, RoutedEventArgs e)
{
if (tb_ExpenceHead.Text != "")
{
tbl_ExpenceHead eh = new tbl_ExpenceHead();
eh.Name = tb_ExpenceHead.Text;
ExpenceHead.insert(eh);
AutoClosingMessageBox.Show("Head Added", "Success", 3000);
initFormOperations();
}
else
{
AutoClosingMessageBox.Show("Please Enter Name", "Alert", 3000);
}
}
public static List <SubHeadHeadNameModel> getAllMappedToSubHeadHeadNameModel()
{
List <SubHeadHeadNameModel> list = new List <SubHeadHeadNameModel>();
foreach (tbl_ExpenceSubHead esh in getAll())
{
SubHeadHeadNameModel mm = new SubHeadHeadNameModel();
mm.Id = esh.Id;
mm.Head_Id = (int)esh.ExpenseHead_Id;
mm.Name = esh.Name;
tbl_ExpenceHead eh = ExpenceHead.getById(mm.Head_Id);
mm.HeadName = eh.Name;
list.Add(mm);
}
return(list);
}
private void btn_DeleteExpenceHead(object sender, RoutedEventArgs e)
{
if (dg_AllExpenceHeads.SelectedItem != null)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Your step will delete all Sub-Heads,Expences related to this Head.", "Delete Confirmation", System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
tbl_ExpenceHead eh = (tbl_ExpenceHead)dg_AllExpenceHeads.SelectedItem;
ExpenceHead.delete(eh);
AutoClosingMessageBox.Show("Expence Head Deleted", "Deleted", 3000);
initFormOperations();
}
}
else
{
AutoClosingMessageBox.Show("Select A Item", "Alert", 3000);
}
}
private void btn_UpdateExpenceHead(object sender, RoutedEventArgs e)
{
if (dg_AllExpenceHeads.SelectedItem != null)
{
tbl_ExpenceHead eh = (tbl_ExpenceHead)dg_AllExpenceHeads.SelectedItem;
var dialog = new Form_InputDialog(eh.Name);
if (dialog.ShowDialog() == true)
{
eh.Name = dialog.ResponseText;
ExpenceHead.update(eh);
AutoClosingMessageBox.Show("Expence Head Updated", "Success", 3000);
initFormOperations();
}
}
else
{
AutoClosingMessageBox.Show("Select A Item", "Alert", 3000);
}
}