private clsRulesProps setInput()
{
clsRulesProps obj = new clsRulesProps();
obj.RuleName = txtRuleName.Text;
//obj.AgeFrom = Convert.ToInt32(ddlAgeFrom.SelectedItem.Text);
//obj.AgeTo = Convert.ToInt32(ddlAgeTo.SelectedItem.Text);
//obj.NCAge = ddlNCAge.SelectedItem.Text;
//obj.MileageFrom = Convert.ToInt32(ddlMileageFrom.SelectedItem.Value);
//obj.MileageTo = Convert.ToInt32(ddlMileageTo.SelectedItem.Value);
//obj.NCMileage = ddlNCMileage.SelectedItem.Text;
//obj.VehicleType = GetSelectedVehicleType();
//obj.NCBodyType = ddlNCBodyType.SelectedItem.Text;
//obj.FuelType = GetSFuelType();
//obj.NCFuelType = ddlNCFuelType.SelectedItem.Text;
//obj.EngineSizeFrom = Convert.ToInt32(ddlEngineSizeFrom.SelectedItem.Value);
//obj.EngineSizeTo = Convert.ToInt32(ddlEngineSizeTo.SelectedItem.Value);
//obj.NCEngineSize = ddlNCEngineSize.SelectedItem.Text;
//obj.Gearbox = ddlGearbox.SelectedItem.Text;
//obj.NCGearbox = ddlNCGearbox.SelectedItem.Text;
//obj.Doors = Convert.ToInt32(ddlDoors.SelectedItem.Text);
obj.CAPCleanFrom = Convert.ToDecimal(txtCAPValueFrom.Text);
obj.CAPCleanTo = Convert.ToDecimal(txtCAPValueTo.Text);
obj.WantToPay = ddlWantToPay.SelectedItem.Text;
obj.IsInPercentage = ddlIsInPercentage.SelectedItem.Text == "%" ? true : false;
obj.Payout = txtPayout.Text;
return(obj);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidateInput() == false)
{
//Page.Validate("AddCategory");
if (Page.IsValid == true)
{
//txtLink.Text = Server.HtmlEncode(txtLink.Text);
clsRulesProps obj = setInput();
if (!string.IsNullOrEmpty(lblMode.Text))
{
obj.IsActive = true;
obj.DeletedStatus = false;
obj.RuleId = Convert.ToInt32(lblMode.Text);
if (BAL_Rules.UpdateRules(obj) == true)
{
ShowMessage("Record Updated Susseccfully.");
FillGrid();
ClearInput();
lblMode.Text = string.Empty;
}
else
{
ShowMessage("Error in record updation.");
}
}
else
{
obj.IsActive = true;
obj.DeletedStatus = false;
if (BAL_Rules.InsertRules(obj, isUpdate: false) == true)
{
ShowMessage("Record Inserted Susseccfully.");
FillGrid();
ClearInput();
}
else
{
ShowMessage("Error in record insertion.");
}
}
}
else
{
ShowMessage("Some Required Field Missing");
}
}
}
public static bool InsertRules(clsRulesProps objRules, bool isUpdate = false)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
if (isUpdate)
{
// set the stored procedure name
comm.CommandText = "UpdateRules";
DbParameter pRuleId = comm.CreateParameter();
pRuleId.ParameterName = "@RuleId";
pRuleId.Value = objRules.RuleId;
pRuleId.DbType = DbType.Int32;
comm.Parameters.Add(pRuleId);
}
else
{
// set the stored procedure name
comm.CommandText = "InsertRules";
}
DbParameter pRuleName = comm.CreateParameter();
pRuleName.ParameterName = "@RuleName";
pRuleName.Value = objRules.RuleName;
pRuleName.DbType = DbType.String;
comm.Parameters.Add(pRuleName);
//DbParameter pAgeFrom = comm.CreateParameter();
//pAgeFrom.ParameterName = "@AgeFrom";
//pAgeFrom.Value = objRules.AgeFrom;
//pAgeFrom.DbType = DbType.Int32;
//comm.Parameters.Add(pAgeFrom);
//DbParameter pAgeTo = comm.CreateParameter();
//pAgeTo.ParameterName = "@AgeTo";
//pAgeTo.Value = objRules.AgeTo;
//pAgeTo.DbType = DbType.Int32;
//comm.Parameters.Add(pAgeTo);
//DbParameter pNCAge = comm.CreateParameter();
//pNCAge.ParameterName = "@NCAge";
//pNCAge.Value = objRules.NCAge;
//pNCAge.DbType = DbType.String;
//comm.Parameters.Add(pNCAge);
//DbParameter pMileageFrom = comm.CreateParameter();
//pMileageFrom.ParameterName = "@MileageFrom";
//pMileageFrom.Value = objRules.MileageFrom;
//pMileageFrom.DbType = DbType.Int32;
//comm.Parameters.Add(pMileageFrom);
//DbParameter pMileageTo = comm.CreateParameter();
//pMileageTo.ParameterName = "@MileageTo";
//pMileageTo.Value = objRules.MileageTo;
//pMileageTo.DbType = DbType.Int32;
//comm.Parameters.Add(pMileageTo);
//DbParameter pNCMileage = comm.CreateParameter();
//pNCMileage.ParameterName = "@NCMileage";
//pNCMileage.Value = objRules.NCMileage;
//pNCMileage.DbType = DbType.String;
//comm.Parameters.Add(pNCMileage);
//DbParameter pVehicleType = comm.CreateParameter();
//pVehicleType.ParameterName = "@VehicleType";
//pVehicleType.Value = objRules.VehicleType;
//pVehicleType.DbType = DbType.String;
//comm.Parameters.Add(pVehicleType);
//DbParameter pNCBodyType = comm.CreateParameter();
//pNCBodyType.ParameterName = "@NCBodyType";
//pNCBodyType.Value = objRules.NCBodyType;
//pNCBodyType.DbType = DbType.String;
//comm.Parameters.Add(pNCBodyType);
//DbParameter pFuelType = comm.CreateParameter();
//pFuelType.ParameterName = "@FuelType";
//pFuelType.Value = objRules.FuelType;
//pFuelType.DbType = DbType.String;
//comm.Parameters.Add(pFuelType);
//DbParameter pNCFuelType = comm.CreateParameter();
//pNCFuelType.ParameterName = "@NCFuelType";
//pNCFuelType.Value = objRules.NCFuelType;
//pNCFuelType.DbType = DbType.String;
//comm.Parameters.Add(pNCFuelType);
//DbParameter pEngineSizeFrom = comm.CreateParameter();
//pEngineSizeFrom.ParameterName = "@EngineSizeFrom";
//pEngineSizeFrom.Value = objRules.EngineSizeFrom;
//pEngineSizeFrom.DbType = DbType.Int32;
//comm.Parameters.Add(pEngineSizeFrom);
//DbParameter pEngineSizeTo = comm.CreateParameter();
//pEngineSizeTo.ParameterName = "@EngineSizeTo";
//pEngineSizeTo.Value = objRules.EngineSizeTo;
//pEngineSizeTo.DbType = DbType.Int32;
//comm.Parameters.Add(pEngineSizeTo);
//DbParameter pNCEngineSize = comm.CreateParameter();
//pNCEngineSize.ParameterName = "@NCEngineSize";
//pNCEngineSize.Value = objRules.NCEngineSize;
//pNCEngineSize.DbType = DbType.String;
//comm.Parameters.Add(pNCEngineSize);
//DbParameter pGearbox = comm.CreateParameter();
//pGearbox.ParameterName = "@Gearbox";
//pGearbox.Value = objRules.Gearbox;
//pGearbox.DbType = DbType.String;
//comm.Parameters.Add(pGearbox);
//DbParameter pNCGearbox = comm.CreateParameter();
//pNCGearbox.ParameterName = "@NCGearbox";
//pNCGearbox.Value = objRules.NCGearbox;
//pNCGearbox.DbType = DbType.String;
//comm.Parameters.Add(pNCGearbox);
//DbParameter pDoors = comm.CreateParameter();
//pDoors.ParameterName = "@Doors";
//pDoors.Value = objRules.Doors;
//pDoors.DbType = DbType.Int32;
//comm.Parameters.Add(pDoors);
DbParameter pCAPCleanFrom = comm.CreateParameter();
pCAPCleanFrom.ParameterName = "@CAPCleanFrom";
pCAPCleanFrom.Value = objRules.CAPCleanFrom;
pCAPCleanFrom.DbType = DbType.Decimal;
comm.Parameters.Add(pCAPCleanFrom);
DbParameter pCAPCleanTo = comm.CreateParameter();
pCAPCleanTo.ParameterName = "@CAPCleanTo";
pCAPCleanTo.Value = objRules.CAPCleanTo;
pCAPCleanTo.DbType = DbType.Decimal;
comm.Parameters.Add(pCAPCleanTo);
DbParameter pWantToPay = comm.CreateParameter();
pWantToPay.ParameterName = "@WantToPay";
pWantToPay.Value = objRules.WantToPay;
pWantToPay.DbType = DbType.String;
comm.Parameters.Add(pWantToPay);
DbParameter pIsInPercentage = comm.CreateParameter();
pIsInPercentage.ParameterName = "@IsInPercentage";
pIsInPercentage.Value = objRules.IsInPercentage;
pIsInPercentage.DbType = DbType.Boolean;
comm.Parameters.Add(pIsInPercentage);
DbParameter pPayout = comm.CreateParameter();
pPayout.ParameterName = "@Payout";
pPayout.Value = objRules.Payout;
pPayout.DbType = DbType.String;
comm.Parameters.Add(pPayout);
DbParameter pIsActive = comm.CreateParameter();
pIsActive.ParameterName = "@IsActive";
pIsActive.Value = objRules.IsActive;
pIsActive.DbType = DbType.Boolean;
comm.Parameters.Add(pIsActive);
DbParameter pDeletedStatus = comm.CreateParameter();
pDeletedStatus.ParameterName = "@DeletedStatus";
pDeletedStatus.Value = objRules.DeletedStatus;
pDeletedStatus.DbType = DbType.Boolean;
comm.Parameters.Add(pDeletedStatus);
if (gda.ExecuteNonQuery(comm) > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool UpdateRules(clsRulesProps objRules)
{
return(InsertRules(objRules, true));
}
