protected void gvSetting_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// DropDownList ddlsatkeholdertypeeditor = (DropDownList)gvSetting.Rows[e.RowIndex].FindControl("ddlstakeholderTypeListeditor");
DropDownList ddltiresizeeditor = (DropDownList)gvSetting.Rows[e.RowIndex].FindControl("ddlTireSizeListeditor");
TextBox txteffectdate = (TextBox)gvSetting.Rows[e.RowIndex].FindControl("txteffectivedateeditor");
TextBox txtexpireddate = (TextBox)gvSetting.Rows[e.RowIndex].FindControl("txtexpirationdateeditor");
TextBox txtdollarvalue = (TextBox)gvSetting.Rows[e.RowIndex].FindControl("txtDollarValueeditor");
PTEStandards objPTE = new PTEStandards();
//objPTE.OrganizationId = UserOrganizationId;
objPTE.StateId = Conversion.ParseInt(ddlStewardship.SelectedItem.Value);;
objPTE.PteStandardId = Convert.ToInt32(gvSetting.DataKeys[e.RowIndex].Values[0].ToString());
// objPTE.OrganizationSubTypeId = Convert.ToInt32(ddlsatkeholdertypeeditor.SelectedValue);
objPTE.SizeId = Convert.ToInt32(ddltiresizeeditor.SelectedValue);
objPTE.EffectiveDate = Convert.ToDateTime(txteffectdate.Text, System.Globalization.CultureInfo.InvariantCulture);
objPTE.ExpirationDate = Convert.ToDateTime(txtexpireddate.Text, System.Globalization.CultureInfo.InvariantCulture);
objPTE.DollarValue = float.Parse(txtdollarvalue.Text);
objPTE.UpdatedDate = DateTime.Now;
objPTE.UpdatedByUserId = UserInfo.GetCurrentUserInfo().UserId;
PTEStandards.UpdateSetting(objPTE);
gvSetting.EditIndex = -1;
lblErrorMessage.Visible = true;
lblErrorMessage.CssClass = "custom-absolute-alert alert-success";
lblErrorMessage.Text = "Record Updated Successfully";
ScriptManager.RegisterStartupScript(this, GetType(), "fadeOut", "fadeOut();", true);
LoadData();
}
public void LoadData(int pagenum = -1)
{
try
{
pageSize = Conversion.ParseInt(ddlPageSize.SelectedValue);
gvSetting.PageSize = pageSize;
int stateid;
if (Session["ss"] != null)
{
stateid = Conversion.ParseInt(Session["ss"]);
}
else
{
stateid = Conversion.ParseInt(ddlStewardship.SelectedValue);
}
if (stateid == 0)
{
gvSetting.DataSource = null;
}
else
{
DataSet ds = null;
if (pagenum > 0)
{
ds = PTEStandards.getSetting(LanguageId, stateid, pagenum, pageSize, out totalRows);
}
else
{
ds = PTEStandards.getSetting(LanguageId, stateid, CurPageNum, pageSize, out totalRows);
}
gvSetting.DataSource = ds;
}
gvSetting.DataBind();
GridPaging();
this.TotalItems = totalRows;
if (gvSetting.Rows.Count == 0)
{
pnlAddPTE.Visible = true;
}
else
{
pnlAddPTE.Visible = false;
}
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "PTE.loadGridAndHeaderText", ex);
}
}
protected void lnkbtnAddSetting_Click(object sender, EventArgs e)
{
PTEStandards objPTE = new PTEStandards();
//objPTE.OrganizationId = UserOrganizationId;
objPTE.StateId = Conversion.ParseInt(ddlStewardship.SelectedItem.Value);
// objPTE.OrganizationSubTypeId = Convert.ToInt32(ddlstakeholderTypeListfooter.SelectedValue);
objPTE.SizeId = Convert.ToInt32(ddlTireSizeListfooter.SelectedValue);
objPTE.EffectiveDate = Convert.ToDateTime(txteffectivedatefooter.Text, System.Globalization.CultureInfo.InvariantCulture);
objPTE.ExpirationDate = Convert.ToDateTime(txtexpirationdatefooter.Text, System.Globalization.CultureInfo.InvariantCulture);
objPTE.DollarValue = float.Parse(txtDollarValuefooter.Text);
objPTE.LanguageId = LanguageId;
objPTE.CreatedDate = DateTime.Now;
objPTE.CreatedByUserId = UserInfo.GetCurrentUserInfo().UserId;
PTEStandards.AddSetting(objPTE);
LoadData();
}
protected void gvSetting_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
pteID = Convert.ToInt32(e.CommandArgument);
lblErrorMessage.Visible = false;
}
else if (e.CommandName == "Delete")
{
lblErrorMessage.Visible = false;
PTEStandards.DeleteSetting(Convert.ToInt32(e.CommandArgument), DateTime.Now, UserInfo.GetCurrentUserInfo().UserId);
LoadData();
}
else if (e.CommandName == "AddMore")
{
// LinkButton lnkbtnAddMore = gvSetting.FooterRow.FindControl("lnkbtnAddMore") as LinkButton;
LinkButton lnkbtnAddMoreSetting = gvSetting.FooterRow.FindControl("lnkbtnAddMore") as LinkButton;
LinkButton lnkbtnAddSetting = gvSetting.FooterRow.FindControl("lnkbtnAddSetting") as LinkButton;
LinkButton lnkbtnCancelSetting = gvSetting.FooterRow.FindControl("lnkbtnCancelSetting") as LinkButton;
lnkbtnAddSetting.Visible = true;
lnkbtnAddMoreSetting.Visible = false;
lnkbtnCancelSetting.Visible = true;
// DropDownList dllstakeholdertypefooter = gvSetting.FooterRow.FindControl("ddlstakeholderTypeListfooter") as DropDownList;
DropDownList dlltiresizefooter = gvSetting.FooterRow.FindControl("ddlTireSizeListfooter") as DropDownList;
TextBox txtEffectiveDate = gvSetting.FooterRow.FindControl("txteffectivedatefooter") as TextBox;
TextBox txtExpirtaionDate = gvSetting.FooterRow.FindControl("txtexpirationdatefooter") as TextBox;
TextBox txtDollarValue = gvSetting.FooterRow.FindControl("txtDollarValuefooter") as TextBox;
// dllstakeholdertypefooter.Visible = true;
dlltiresizefooter.Visible = true;
txtEffectiveDate.Visible = true;
txtExpirtaionDate.Visible = true;
txtDollarValue.Visible = true;
lblErrorMessage.Visible = false;
ScriptManager.RegisterStartupScript(this, GetType(), "AddDataPickerFooter", "SetDatePicket();", true);
}
else if (e.CommandName == "CancelSetting")
{
lblErrorMessage.Visible = false;
gvSetting.EditIndex = -1;
LoadData();
}
else if (e.CommandName == "Insert")
{
DropDownList dllstakeholdertypefooter = gvSetting.FooterRow.FindControl("ddlstakeholderTypeListfooter") as DropDownList;
DropDownList dlltiresizefooter = gvSetting.FooterRow.FindControl("ddlTireSizeListfooter") as DropDownList;
TextBox txtEffectiveDate = gvSetting.FooterRow.FindControl("txteffectivedatefooter") as TextBox;
TextBox txtExpirtaionDate = gvSetting.FooterRow.FindControl("txtexpirationdatefooter") as TextBox;
TextBox txtDollarValue = gvSetting.FooterRow.FindControl("txtDollarValuefooter") as TextBox;
PTEStandards objPTE = new PTEStandards();
//objPTE.OrganizationId = UserOrganizationId;
objPTE.StateId = Conversion.ParseInt(ddlStewardship.SelectedItem.Value);
// objPTE.OrganizationSubTypeId = Convert.ToInt32(dllstakeholdertypefooter.SelectedValue);
objPTE.SizeId = Convert.ToInt32(dlltiresizefooter.SelectedValue);
objPTE.EffectiveDate = Convert.ToDateTime(txtEffectiveDate.Text, System.Globalization.CultureInfo.InvariantCulture);
objPTE.ExpirationDate = Convert.ToDateTime(txtExpirtaionDate.Text, System.Globalization.CultureInfo.InvariantCulture);
objPTE.DollarValue = float.Parse(txtDollarValue.Text);
objPTE.LanguageId = LanguageId;
objPTE.CreatedDate = DateTime.Now;
objPTE.CreatedByUserId = UserInfo.GetCurrentUserInfo().UserId;
int checkBit = PTEStandards.AddSetting(objPTE);
if (checkBit == 0)
{
lblErrorMessage.Visible = true;
lblErrorMessage.CssClass = "custom-absolute-alert alert-danger";
lblErrorMessage.Text = "Record already Exists...";
ScriptManager.RegisterStartupScript(this, GetType(), "fadeOut", "fadeOut();", true);
}
else
{
lblErrorMessage.Visible = true;
lblErrorMessage.CssClass = "custom-absolute-alert alert-success";
lblErrorMessage.Text = "Record added successfully...";
ScriptManager.RegisterStartupScript(this, GetType(), "fadeOut", "fadeOut();", true);
}
LoadData();
}
}
