private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
RevenueAddProjectRevenue revenueAddProjectRevenue = new RevenueAddProjectRevenue(revenueAddTDS);
revenueAddProjectRevenue.Save(companyId);
DB.CommitTransaction();
// Store datasets
revenueAddTDS.AcceptChanges();
Session["revenueAddTDS"] = revenueAddTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void GrdRevenueDetailAdd()
{
if (FooterValidate())
{
Page.Validate("DataNew");
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
DateTime date = (DateTime)((RadDatePicker)grdRevenue.FooterRow.FindControl("tkrdpDateFooter")).SelectedDate;
int clientId = Int32.Parse(((DropDownList)grdRevenue.FooterRow.FindControl("ddlClientFooter")).SelectedValue);
string client = ((DropDownList)grdRevenue.FooterRow.FindControl("ddlClientFooter")).SelectedItem.Text;
int projectId = Int32.Parse(((DropDownList)grdRevenue.FooterRow.FindControl("ddlProjectFooter")).SelectedValue);
string project = ((DropDownList)grdRevenue.FooterRow.FindControl("ddlProjectFooter")).SelectedItem.Text;
decimal revenue = decimal.Round(decimal.Parse(((TextBox)grdRevenue.FooterRow.FindControl("tbxRevenueFooter")).Text), 2);
string comment = ((TextBox)grdRevenue.FooterRow.FindControl("tbxCommentFooter")).Text;
bool deleted = false;
bool inDatabase = false;
// Insert Data
RevenueAddProjectRevenue revenueAddProjectRevenue = new RevenueAddProjectRevenue(revenueAddTDS);
revenueAddProjectRevenue.Insert(projectId, date, revenue, comment, deleted, companyId, inDatabase, client, project, clientId);
// Store dataset
Session["revenueAddTDS"] = revenueAddTDS;
Session.Remove("projectRevenueDummy");
projectRevenue = revenueAddTDS.ProjectRevenue;
Session["projectRevenue"] = revenueAddTDS.ProjectRevenue;
grdRevenue.DataBind();
grdRevenue.PageIndex = grdRevenue.PageCount - 1;
}
}
}
protected void grdRevenue_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("DataEdit");
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int projectId = Int32.Parse(((Label)grdRevenue.Rows[e.RowIndex].Cells[0].FindControl("lblProjectIdEdit")).Text);
int refId = Int32.Parse(((Label)grdRevenue.Rows[e.RowIndex].Cells[1].FindControl("lblRefIdEdit")).Text);
DateTime date = (DateTime)((RadDatePicker)grdRevenue.Rows[e.RowIndex].Cells[4].FindControl("tkrdpDateEdit")).SelectedDate;
decimal revenue = decimal.Round(decimal.Parse(((TextBox)grdRevenue.Rows[e.RowIndex].Cells[5].FindControl("tbxRevenueEdit")).Text), 2);
string comment = ((TextBox)grdRevenue.Rows[e.RowIndex].Cells[6].FindControl("tbxCommentEdit")).Text;
bool deleted = false;
// Update Data
RevenueAddProjectRevenue subcontractorAddProjectRevenueCosts = new RevenueAddProjectRevenue(revenueAddTDS);
subcontractorAddProjectRevenueCosts.Update(projectId, refId, date, revenue, comment, deleted, companyId);
// Store dataset
Session["revenueAddTDS"] = revenueAddTDS;
Session.Remove("projectRevenueDummy");
projectRevenue = revenueAddTDS.ProjectRevenue;
Session["projectRevenue"] = revenueAddTDS.ProjectRevenue;
}
else
{
e.Cancel = true;
}
}
private string GetSummary()
{
int companyId = Int32.Parse(hdfCompanyId.Value);
RevenueAddProjectRevenue revenueAddProjectRevenue = new RevenueAddProjectRevenue(revenueAddTDS);
return revenueAddProjectRevenue.GetSummary(companyId, "\n");
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP1 - DATA
//
// ////////////////////////////////////////////////////////////////////////
// STEP1 - DATA - EVENTS
//
protected void grdRevenue_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Revenue Gridview, if the gridview is edition mode
if (grdRevenue.EditIndex >= 0)
{
grdRevenue.UpdateRow(grdRevenue.EditIndex, true);
}
// Delete Revenue
int projectId = (int)e.Keys["ProjectID"];
int refId = (int)e.Keys["RefID"];
// Delete Revenue
RevenueAddProjectRevenue revenueAddProjectRevenue = new RevenueAddProjectRevenue(revenueAddTDS);
revenueAddProjectRevenue.Delete(projectId, refId);
// Store dataset
Session["revenueAddTDS"] = revenueAddTDS;
Session.Remove("projectRevenueDummy");
projectRevenue = revenueAddTDS.ProjectRevenue;
Session["projectRevenue"] = revenueAddTDS.ProjectRevenue;
}
