private void UpdateDatabase()
{
int companyId = Int32.Parse(hdfCompanyId.Value);
DB.Open();
DB.BeginTransaction();
try
{
SizeInformation sizeInformation = new SizeInformation(sizeInformationTDS);
sizeInformation.Save(companyId);
DB.CommitTransaction();
// Store datasets
sizeInformationTDS.AcceptChanges();
Session["sizeInformationTDS"] = sizeInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
protected void grdSize_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("sizeDataEdit");
if (Page.IsValid)
{
string originalSize_ = e.Keys["Size_"].ToString();
int companyId = (int)e.Keys["COMPANY_ID"];
string newSize_ = ((TextBox)grdSize.Rows[e.RowIndex].Cells[2].FindControl("tbxSizeEdit")).Text.Trim();
if (originalSize_ != newSize_)
{
// Update data
SizeInformation model = new SizeInformation(sizeInformationTDS);
model.Update(originalSize_, newSize_, companyId);
}
// Store dataset
Session.Remove("sizeInformationNewDummy");
Session["sizeInformationTDS"] = sizeInformationTDS;
Session["sizeInformation"] = sizeInformationTDS.SizeInformation;
}
else
{
e.Cancel = true;
}
}
private void GrdSizeAdd()
{
if (ValidateSizeFooter())
{
Page.Validate("sizeDataNew");
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
string size_ = ((TextBox)grdSize.FooterRow.FindControl("tbxSizeNew")).Text.Trim();
bool newInDatabase = false;
SizeInformation model = new SizeInformation(sizeInformationTDS);
model.Insert(size_, companyId, false, newInDatabase);
Session.Remove("sizeInformationNewDummy");
Session["sizeInformationTDS"] = sizeInformationTDS;
Session["sizeInformation"] = sizeInformationTDS.SizeInformation;
grdSize.DataBind();
grdSize.PageIndex = grdSize.PageCount - 1;
}
}
}
protected void grdSize_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Page.Validate("sizeData");
if (Page.IsValid)
{
string size_ = e.Keys["Size_"].ToString();
int companyId = (int)e.Keys["COMPANY_ID"];
SizeInformation model = new SizeInformation(sizeInformationTDS);
// Delete size
model.Delete(size_, companyId);
// Store dataset
Session.Remove("sizeInformationNewDummy");
Session["sizeInformationTDS"] = sizeInformationTDS;
Session["sizeInformation"] = sizeInformationTDS.SizeInformation;
}
else
{
e.Cancel = true;
}
}