public bool AddType(ITypes type) { bool success = false; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Type_Insert); db.AddInParameter(dbCommand, "@sTypeName", DbType.String, type.TypeName); db.AddOutParameter(dbCommand, "@iTypeId", DbType.Int32, 4); if (db.ExecuteNonQuery(dbCommand) > 0) { int newItemID = (int)db.GetParameterValue(dbCommand, "@iTypeId"); if (newItemID > 0) { success = true; type.TypeId = newItemID; } } } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public bool AddType(Type type)"); throw ex; } return success; }
protected void btnTypeSave_Click(object sender, EventArgs e) { try { Boolean save = true; ITypes type = new ITypes(); type.TypeName = txtType.Text.Trim(); if (type.Save()) { // // Types // DataSet dsTypes = (new TypesDAO()).GetAllTypes(); if (dsTypes == null || dsTypes.Tables.Count == 0) { ddlType.Items.Add(new ListItem("--No Data Found--", "-1")); } else { Master.BindDropdown("TypeName", "TypeId", dsTypes, ddlType); ddlType.Items.Add(new ListItem("--Please Select--", "-1")); ddlType.SelectedValue = type.TypeId.ToString(); } ddlType.Visible = true; RequiredFieldValidator10.Enabled = false; txtType.Visible = false; btnTypeSave.Visible = false; btnAddType.Visible = true; } } catch (Exception ex) { ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "protected void btnTypeSave_Click(object sender, EventArgs e)"); if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty) Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false); else Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false); } }