public static void UpdateSetting(PTEStandards objPTE)
{
List <SqlParameter> prm = new List <SqlParameter>();
try
{
using (DbManager DB = DbManager.GetDbManager())
{
prm.Add(DB.MakeInParam("@PTEStandardId", SqlDbType.Int, 4, objPTE.PteStandardId));
prm.Add(DB.MakeInParam("@StateId", SqlDbType.Int, 4, objPTE.StateId));
prm.Add(DB.MakeInParam("@SizeId", SqlDbType.Int, 4, objPTE.SizeId));
prm.Add(DB.MakeInParam("@EffectiveDate", SqlDbType.DateTime, 8, objPTE.EffectiveDate));
prm.Add(DB.MakeInParam("@ExpirationDate", SqlDbType.DateTime, 8, objPTE.ExpirationDate));
prm.Add(DB.MakeInParam("@DollarValue", SqlDbType.Float, 8, objPTE.DollarValue));
prm.Add(DB.MakeInParam("@UpdatedDate", SqlDbType.DateTime, 8, objPTE.UpdatedDate));
prm.Add(DB.MakeInParam("@UpdatedByUserId", SqlDbType.Int, 4, objPTE.UpdatedByUserId));
DB.RunProc("up_PTEStandard_Edit", prm.ToArray());
}
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "PTEStandard.UpdateSetting", ex);
}
}
public static int AddSetting(PTEStandards objPTE)
{
int checkBit;
List <SqlParameter> prm = new List <SqlParameter>();
try
{
using (DbManager DB = DbManager.GetDbManager())
{
prm.Add(DB.MakeInParam("@StateId", SqlDbType.Int, 4, objPTE.StateId));
prm.Add(DB.MakeInParam("@SizeId", SqlDbType.Int, 0, objPTE.SizeId));
prm.Add(DB.MakeInParam("@EffectiveDate", SqlDbType.DateTime, 0, objPTE.EffectiveDate));
prm.Add(DB.MakeInParam("@ExpirationDate", SqlDbType.DateTime, 0, objPTE.ExpirationDate));
prm.Add(DB.MakeInParam("@DollarValue", SqlDbType.Float, 0, objPTE.DollarValue));
prm.Add(DB.MakeInParam("@LanguageId", SqlDbType.Int, 0, objPTE.LanguageId));
prm.Add(DB.MakeInParam("@CreatedDate", SqlDbType.DateTime, 0, objPTE.CreatedDate));
prm.Add(DB.MakeInParam("@CreatedByUserId", SqlDbType.Int, 0, objPTE.CreatedByUserId));
// prm.Add(DB.MakeReturnParam(SqlDbType.Int, 0));
//prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 0, objPTE.OrganizationId));
prm.Add(DB.MakeOutParam("@bit", SqlDbType.Int, 4));
checkBit = DB.RunProc("up_PTEStandards_add", prm.ToArray());
checkBit = Conversion.ParseInt(prm.Last <SqlParameter>().Value);
}
}
catch (Exception ex)
{
checkBit = 0;
new SqlLog().InsertSqlLog(0, "PTEStandards.AddSetting", ex);
}
return(checkBit);
}
public static void UpdateSetting(PTEStandards objPTE)
{
List<SqlParameter> prm = new List<SqlParameter>();
try
{
using (DbManager DB = DbManager.GetDbManager())
{
prm.Add(DB.MakeInParam("@PTEStandardId", SqlDbType.Int, 4, objPTE.PteStandardId));
prm.Add(DB.MakeInParam("@StateId", SqlDbType.Int, 4, objPTE.StateId));
prm.Add(DB.MakeInParam("@SizeId", SqlDbType.Int, 4, objPTE.SizeId));
prm.Add(DB.MakeInParam("@EffectiveDate", SqlDbType.DateTime, 8, objPTE.EffectiveDate));
prm.Add(DB.MakeInParam("@ExpirationDate", SqlDbType.DateTime, 8, objPTE.ExpirationDate));
prm.Add(DB.MakeInParam("@DollarValue", SqlDbType.Float, 8, objPTE.DollarValue));
prm.Add(DB.MakeInParam("@UpdatedDate", SqlDbType.DateTime, 8, objPTE.UpdatedDate));
prm.Add(DB.MakeInParam("@UpdatedByUserId", SqlDbType.Int, 4, objPTE.UpdatedByUserId));
DB.RunProc("up_PTEStandard_Edit", prm.ToArray());
}
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "PTEStandard.UpdateSetting", ex);
}
}
public static int AddSetting(PTEStandards objPTE)
{
int checkBit;
List<SqlParameter> prm = new List<SqlParameter>();
try
{
using (DbManager DB = DbManager.GetDbManager())
{
prm.Add(DB.MakeInParam("@StateId", SqlDbType.Int, 4, objPTE.StateId));
prm.Add(DB.MakeInParam("@SizeId", SqlDbType.Int, 0, objPTE.SizeId));
prm.Add(DB.MakeInParam("@EffectiveDate", SqlDbType.DateTime, 0, objPTE.EffectiveDate));
prm.Add(DB.MakeInParam("@ExpirationDate", SqlDbType.DateTime, 0, objPTE.ExpirationDate));
prm.Add(DB.MakeInParam("@DollarValue", SqlDbType.Float, 0, objPTE.DollarValue));
prm.Add(DB.MakeInParam("@LanguageId", SqlDbType.Int, 0, objPTE.LanguageId));
prm.Add(DB.MakeInParam("@CreatedDate", SqlDbType.DateTime, 0, objPTE.CreatedDate));
prm.Add(DB.MakeInParam("@CreatedByUserId", SqlDbType.Int, 0, objPTE.CreatedByUserId));
// prm.Add(DB.MakeReturnParam(SqlDbType.Int, 0));
//prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 0, objPTE.OrganizationId));
prm.Add(DB.MakeOutParam("@bit", SqlDbType.Int, 4));
checkBit = DB.RunProc("up_PTEStandards_add", prm.ToArray());
checkBit = Conversion.ParseInt(prm.Last<SqlParameter>().Value);
}
}
catch (Exception ex)
{
checkBit = 0;
new SqlLog().InsertSqlLog(0, "PTEStandards.AddSetting", ex);
}
return checkBit;
}
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_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();
}
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();
}
}
