protected void grdInsuranceCompaniesCostsByClientProject_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("DataEditInsuranceCompaniesByClientProject");
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int refId = Int32.Parse(((Label)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("lblRefIdEditInsuranceCompaniesByClientProject")).Text);
DateTime date = (DateTime)((RadDatePicker)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("tkrdpDateEditInsuranceCompaniesByClientProject")).SelectedDate;
int insuranceCompanyId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("ddlInsuranceCompaniesEditInsuranceCompaniesByClientProject")).Text);
string name = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("ddlInsuranceCompaniesEditInsuranceCompaniesByClientProject")).SelectedItem.Text;
int projectId = Int32.Parse(((Label)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("lblProjectIdEditInsuranceCompaniesByClientProject")).Text);
decimal rate = decimal.Round(decimal.Parse(((TextBox)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("tbxRateEditInsuranceCompaniesByClientProject")).Text), 2);
decimal rateCad = 0;
decimal rateUsd = 0;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
rateCad = rate;
}
else
{
rateUsd = rate;
}
string comment = ((TextBox)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("tbxCommentEditInsuranceCompaniesByClientProject")).Text;
bool deleted = false;
// Update Data
ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS);
actualCostsAddInsuranceCompaniesCosts.Update(projectId, refId, insuranceCompanyId, date, rateCad, rateUsd, comment, deleted, companyId, name);
// Store dataset
Session.Remove("insuranceCompaniesCostsByClientProjectDummy");
Session["actualCostsAddTDS"] = actualCostsAddTDS;
Session["insuranceCompaniesCosts"] = actualCostsAddTDS.InsuranceCompaniesCosts;
insuranceCompaniesCosts = actualCostsAddTDS.InsuranceCompaniesCosts;
}
else
{
e.Cancel = true;
}
}
protected void grdInsuranceCompaniesCostsByClientProject_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// InsuranceCompanies Gridview, if the gridview is edition mode
if (grdInsuranceCompaniesCostsByClientProject.EditIndex >= 0)
{
grdInsuranceCompaniesCostsByClientProject.UpdateRow(grdInsuranceCompaniesCostsByClientProject.EditIndex, true);
}
// Delete InsuranceCompanies
int projectId = (int)e.Keys["ProjectID"];
int refId = (int)e.Keys["RefID"];
// Delete costs details
ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS);
actualCostsAddInsuranceCompaniesCosts.Delete(projectId, refId);
// Store dataset
Session.Remove("insuranceCompaniesCostsByClientProjectDummy");
Session["actualCostsAddTDS"] = actualCostsAddTDS;
Session["insuranceCompaniesCosts"] = actualCostsAddTDS.InsuranceCompaniesCosts;
insuranceCompaniesCosts = actualCostsAddTDS.InsuranceCompaniesCosts;
}
private void grdInsuranceCompaniesCostsByClientProjectDetailAdd()
{
if (FooterValidateInsuranceCompaniesByClientProject())
{
Page.Validate("DataNewInsuranceCompaniesByClientProject");
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
DateTime date = (DateTime)((RadDatePicker)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("tkrdpDateFooterInsuranceCompaniesByClientProject")).SelectedDate;
int insuranceCompanyId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlInsuranceCompaniesFooterInsuranceCompaniesByClientProject")).Text);
string name = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlInsuranceCompaniesFooterInsuranceCompaniesByClientProject")).SelectedItem.Text;
int clientId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlClientFooterInsuranceCompaniesByClientProject")).SelectedValue);
string client = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlClientFooterInsuranceCompaniesByClientProject")).SelectedItem.Text;
int projectId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlProjectFooterInsuranceCompaniesByClientProject")).SelectedValue);
string project = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlProjectFooterInsuranceCompaniesByClientProject")).SelectedItem.Text;
decimal rate = decimal.Round(decimal.Parse(((TextBox)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("tbxRateFooterInsuranceCompaniesByClientProject")).Text), 2);
string comment = ((TextBox)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("tbxCommentFooterInsuranceCompaniesByClientProject")).Text;
bool deleted = false;
bool inDatabase = false;
decimal rateCad = 0;
decimal rateUsd = 0;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
rateCad = rate;
rateUsd = rate;
}
else
{
rateCad = rate;
rateUsd = rate;
}
// Insert Data
ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS);
actualCostsAddInsuranceCompaniesCosts.Insert(projectId, insuranceCompanyId, date, rateCad, rateUsd, comment, deleted, companyId, inDatabase, name, client, project, clientId);
// Store dataset
Session.Remove("insuranceCompaniesCostsByClientProjectDummy");
Session["actualCostsAddTDS"] = actualCostsAddTDS;
Session["insuranceCompaniesCosts"] = actualCostsAddTDS.InsuranceCompaniesCosts;
insuranceCompaniesCosts = actualCostsAddTDS.InsuranceCompaniesCosts;
grdInsuranceCompaniesCostsByClientProject.DataBind();
grdInsuranceCompaniesCostsByClientProject.PageIndex = grdInsuranceCompaniesCostsByClientProject.PageCount - 1;
}
}
}
protected void AddInsuranceCompaniesCostsNewEmptyFix(GridView grdInsuranceCompaniesCostsByClientProject)
{
if (grdInsuranceCompaniesCostsByClientProject.Rows.Count == 0)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
ActualCostsAddTDS.InsuranceCompaniesCostsDataTable dt = new ActualCostsAddTDS.InsuranceCompaniesCostsDataTable();
dt.AddInsuranceCompaniesCostsRow(-1, -1, DateTime.Now, -1, -1, "", false, companyId, false, "", 0, "", "", 1);
Session["insuranceCompaniesCostsByClientProjectDummy"] = dt;
grdInsuranceCompaniesCostsByClientProject.DataBind();
}
// normally executes at all postbacks
if (grdInsuranceCompaniesCostsByClientProject.Rows.Count == 1)
{
ActualCostsAddTDS.InsuranceCompaniesCostsDataTable dt = (ActualCostsAddTDS.InsuranceCompaniesCostsDataTable)Session["insuranceCompaniesCostsByClientProjectDummy"];
if (dt != null)
{
grdInsuranceCompaniesCostsByClientProject.Rows[0].Visible = false;
grdInsuranceCompaniesCostsByClientProject.Rows[0].Controls.Clear();
}
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP6 - INSURANCE COMPANIES COST BY CLIENT AND PROJECT - PUBLIC METHODS
//
public ActualCostsAddTDS.InsuranceCompaniesCostsDataTable GetInsuranceCompaniesDetailInsuranceCompaniesByClientProject()
{
insuranceCompaniesCosts = (ActualCostsAddTDS.InsuranceCompaniesCostsDataTable)Session["insuranceCompaniesCostsByClientProjectDummy"];
if (insuranceCompaniesCosts == null)
{
insuranceCompaniesCosts = ((ActualCostsAddTDS.InsuranceCompaniesCostsDataTable)Session["insuranceCompaniesCosts"]);
}
return insuranceCompaniesCosts;
}
