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)); }