public static Dictionary <int, Item> GetAllItems() { Dictionary <int, Item> lclsItems = new Dictionary <int, Item>(); DataTable dtItems = MDatabaseUtilities.CreateDataTable("Select * from TItems", Hidden.ExternalConnection); foreach (DataRow drRow in dtItems.Rows) { Item clsNewItem = new Item { intID = (int)drRow["intItemID"], strName = (string)drRow["strName"], strDescription = (string)drRow["strDescription"], strNotes = (string)drRow["strNotes"], strType = (string)drRow["strType"], strScreenshotLocation = (string)drRow["strScreenshotLocation"], intSubmitterID = (int)drRow["intSubmitterID"], blnIsBaseResource = (bool)drRow["blnIsBaseResource"], blnIsConsumable = (bool)drRow["blnIsConsumable"], intInfluenceBuyValue = (int)drRow["intInfluenceBuyValue"], intMaxLockerStackSize = (int)drRow["intMaxLockerStackSize"], intInfluenceSellValue = (int)drRow["intInfluenceSellValue"], decWeight = (decimal)drRow["decWeight"], intMaxInventoryStackSize = (int)drRow["intMaxInventoryStackSize"], intStatusID = (int)drRow["intStatusID"] }; lclsItems.Add(clsNewItem.intID, clsNewItem); } return(lclsItems); }
public static Dictionary <int, ModFile> GetAllModFiles() { Dictionary <int, ModFile> lclsModFiles = new Dictionary <int, ModFile>(); DataTable dtModFiles = MDatabaseUtilities.CreateDataTable("Select * from TModFiles where intStatusID <> 4 order by strName", Hidden.ExternalConnection); foreach (DataRow drRow in dtModFiles.Rows) { ModFile clsNewModFile = new ModFile { intID = (int)drRow["intModFileID"], intModID = (int)drRow["intModID"], strName = (string)drRow["strName"], strDescription = (string)drRow["strDescription"], strLocation = (string)drRow["strLocation"], strVersion = (string)drRow["strVersion"], intStatusID = (int)drRow["intStatusID"], intSubmitterID = (int)drRow["intSubmitterID"] }; lclsModFiles.Add(clsNewModFile.intID, clsNewModFile); } return(lclsModFiles); }
public static Dictionary <int, Base> GetAllBases() { Dictionary <int, Base> dicBases = new Dictionary <int, Base>(); DataTable dtBases = MDatabaseUtilities.CreateDataTable("Select * from TBases where intStatusID <> 4", Hidden.ExternalConnection); foreach (DataRow drRow in dtBases.Rows) { Base clsNewBase = new Base { intID = (int)drRow["intBaseID"], strName = (string)drRow["strName"], clsMap = AllData.Maps[(int)drRow["intMapID"]], intSmallExternalEmptyCount = (int)drRow["intSmallExternalEmptyCount"], intSmallInternalEmptyCount = (int)drRow["intSmallInternalEmptyCount"], intParkingCount = (int)drRow["intParkingCount"], clsSize = AllData.Sizes[(int)drRow["intSizeID"]], intInfluenceCost = (int)drRow["intInfluenceCost"], intSurvivorsRequired = (int)drRow["intSurvivorsRequired"], intLargeEmptyCount = (int)drRow["intLargeEmptyCount"], strLocationScreenshotLocation = (string)drRow["strLocationScreenshotLocation"], strSlotsScreenshotLocation = (string)drRow["strSlotsScreenshotLocation"], intStatusID = (int)drRow["intStatusID"], intSubmitterID = (int)drRow["intSubmitterID"] }; dicBases.Add(clsNewBase.intID, clsNewBase); } return(dicBases); }
public static Submitter GetSubmitterFromFBID(string strFBID, string strName) { NLog.LogManager.GetCurrentClassLogger().Debug("Name:" + strName); if (strName == null) { strName = "NAME ERROR"; } Submitter clsReturn = new Submitter(); MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intFBID", strFBID)); lclsParameters.Add(new CStoredProcedureParameter("@strName", strName)); int intSubmitterID = MDatabaseUtilities.ExecuteStoredProcedure("uspGetSubmitterByFBID", lclsParameters.ToArray()); DataTable dt = MDatabaseUtilities.CreateDataTable("SELECT * FROM TSubmitters WHERE intSubmitterID = " + intSubmitterID); clsReturn.intID = intSubmitterID; clsReturn.strFBID = strFBID; clsReturn.strName = (string)dt.Rows[0]["strName"]; clsReturn.intScore = (int)dt.Rows[0]["intScore"]; clsReturn.intStatusID = (int)dt.Rows[0]["intStatusID"]; return(clsReturn); }
public static Dictionary <int, HeroBonus> GetAllHeroBonuses() { Dictionary <int, HeroBonus> lclsHeroBonuss = new Dictionary <int, HeroBonus>(); DataTable dtHeroBonuss = MDatabaseUtilities.CreateDataTable("Select * from THeroBonuses", Hidden.ExternalConnection); foreach (DataRow drRow in dtHeroBonuss.Rows) { HeroBonus clsNewHeroBonus = new HeroBonus { intID = (int)drRow["intHeroBonusID"], strName = (string)drRow["strName"], strEffects = (string)drRow["strEffects"], strDescription = (string)drRow["strDescription"], strGameID = (string)drRow["strGameID"], strNotes = (string)drRow["strNotes"], strScreenshotLocation = (string)drRow["strScreenshotLocation"], intSubmitterID = (int)drRow["intSubmitterID"] }; lclsHeroBonuss.Add(clsNewHeroBonus.intID, clsNewHeroBonus); } return(lclsHeroBonuss); }
protected void btnSave_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); //lclsParameters.Add(new CStoredProcedureParameter("@intItemID", int.Parse(Request.QueryString["ID"]))); //lclsParameters.Add(new CStoredProcedureParameter("@intItemTypeID", Numerics.Val(cmbItemType.SelectedValue))); //lclsParameters.Add(new CStoredProcedureParameter("@intAmmoTypeID", Numerics.Val(cmbAmmoType.SelectedValue))); //lclsParameters.Add(new CStoredProcedureParameter("@strName", txtName.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strDescription", txtDescription.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strNotes", txtNotes.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strScreenshotLocation", txtScreenshot.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strVisual", txtVisual.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strAudio", txtAudio.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strMagMod", txtMagMod.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strSightMod", txtSightMod.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strGameID", txtGameID.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@strDefaultMod", txtDefaultMod.Text)); //lclsParameters.Add(new CStoredProcedureParameter("@intDurability", Numerics.Val(txtDurability.Text))); //lclsParameters.Add(new CStoredProcedureParameter("@intCapacity", Numerics.Val(txtCapacity.Text))); //lclsParameters.Add(new CStoredProcedureParameter("@intBuyPrice", Numerics.Val(txtBuyPrice.Text))); //lclsParameters.Add(new CStoredProcedureParameter("@intSellPrice", Numerics.Val(txtSellPrice.Text))); //lclsParameters.Add(new CStoredProcedureParameter("@intSalvage", Numerics.Val(txtSalvageValue.Text))); //lclsParameters.Add(new CStoredProcedureParameter("@decWeight", Numerics.Val(txtWeight.Text))); //lclsParameters.Add(new CStoredProcedureParameter("@blnCanFireSingle", chkSingle.Checked)); //lclsParameters.Add(new CStoredProcedureParameter("@blnCanFireBurst", chkBurst.Checked)); //lclsParameters.Add(new CStoredProcedureParameter("@blnCanFireAuto", chkAuto.Checked)); //lclsParameters.Add(new CStoredProcedureParameter("@blnAcceptsAttachments", chkAcceptsAttachments.Checked)); //lclsParameters.Add(new CStoredProcedureParameter("@blnOneIsTheChamber", chkOneInTheChamber.Checked)); //lclsParameters.Add(new CStoredProcedureParameter("@blnHasSight", chkHasSight.Checked)); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); MDatabaseUtilities.ExecuteStoredProcedure("uspUpsertItem", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; Response.Redirect("Items.aspx"); }
public static Dictionary <int, PrebuiltFacility> GetAllPrebuiltFacilities() { Dictionary <int, PrebuiltFacility> lclsPrebuiltFacilities = new Dictionary <int, PrebuiltFacility>(); DataTable dtPrebuiltFacilities = MDatabaseUtilities.CreateDataTable("Select * from [TBaseFacilityPrebuilts] where intStatusID <> 4 order by strName", Hidden.ExternalConnection); foreach (DataRow drRow in dtPrebuiltFacilities.Rows) { PrebuiltFacility clsNewPrebuiltFacility = new PrebuiltFacility { intID = (int)drRow["intPrebuiltFacilityID"], intBaseID = (int)drRow["intBaseID"], clsFacility = AllData.Facilities[(int)drRow["intFacilityID"]], strName = (string)drRow["strName"], strDescription = (string)drRow["strDescription"], strNotes = (string)drRow["strNotes"], strScreenshotLocation = (string)drRow["strScreenshotLocation"], intSubmitterID = (int)drRow["intSubmitterID"], intStatusID = (int)drRow["intStatusID"], intEffectiveLevel = (int)drRow["intEffectiveLevel"], blnIsDestroyable = (bool)drRow["blnIsDestroyable"] }; lclsPrebuiltFacilities.Add(clsNewPrebuiltFacility.intID, clsNewPrebuiltFacility); } return(lclsPrebuiltFacilities); }
protected void btnDelete_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intFacilityID", int.Parse(Request.QueryString["ID"]))); MDatabaseUtilities.ExecuteStoredProcedure("uspDeleteFacility", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; Response.Redirect("Facilities.aspx"); }
protected void btnFlag_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intFlagSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", clsItem.intSubmitterID)); lclsParameters.Add(new CStoredProcedureParameter("@strItemData", UExtensionLibrary.Serialization.Serialization.Serialize(clsItem))); MDatabaseUtilities.ExecuteStoredProcedure("uspAddFlagRecord", lclsParameters.ToArray()); //Classes.AllData.IsDirty = true; Response.Redirect("Items.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intTraitEffectID", int.Parse(Request.QueryString["EID"]))); lclsParameters.Add(new CStoredProcedureParameter("@intEffectTypeID", int.Parse(cmbEffectType.SelectedValue))); lclsParameters.Add(new CStoredProcedureParameter("@intTraitID", int.Parse(Request.QueryString["TID"]))); lclsParameters.Add(new CStoredProcedureParameter("@blnIsGlobal", chkIsGlobal.Checked)); lclsParameters.Add(new CStoredProcedureParameter("@strValue", txtValue.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); MDatabaseUtilities.ExecuteStoredProcedure("uspUpsertTraitEffect", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; Response.Redirect("ModifyTraits.aspx?ID=" + Request.QueryString["TID"]); }
protected void btnSave_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intTraitID", int.Parse(Request.QueryString["ID"]))); lclsParameters.Add(new CStoredProcedureParameter("@strName", txtName.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strDescription", txtDescription.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strNotes", txtNotes.Text)); lclsParameters.Add(new CStoredProcedureParameter("@ScreenshotLocation", txtScreenshot.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intHeroBonusID", UExtensionLibrary.Numerics.Numerics.Val(cmbLinkedHeroBonus.SelectedValue))); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); MDatabaseUtilities.ExecuteStoredProcedure("uspUpsertTrait", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; Response.Redirect("Traits.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intFacilityID", int.Parse(Request.QueryString["ID"]))); lclsParameters.Add(new CStoredProcedureParameter("@strName", txtName.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strDescription", txtDescription.Text)); lclsParameters.Add(new CStoredProcedureParameter("@blnCanBePlacedOutdoors", chkCanBePlacedOutdoors.Checked)); lclsParameters.Add(new CStoredProcedureParameter("@blnCanBePlacedIndoors", chkCanBePlacedIndoors.Checked)); lclsParameters.Add(new CStoredProcedureParameter("@intSizeID", Numerics.Val(cmbSize.SelectedValue))); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); MDatabaseUtilities.ExecuteStoredProcedure("uspUpsertFacility", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; Response.Redirect("Facilities.aspx"); }
public static Dictionary <int, AmmoType> GetAllAmmoTypes() { Dictionary <int, AmmoType> dicAmmoTypes = new Dictionary <int, AmmoType>(); DataTable dtAmmoTypes = MDatabaseUtilities.CreateDataTable("Select * from TAmmoTypes", Hidden.ExternalConnection); foreach (DataRow drRow in dtAmmoTypes.Rows) { AmmoType clsNewAmmoType = new AmmoType { intID = (int)drRow["intAmmoTypeID"], strName = (string)drRow["strName"] }; dicAmmoTypes.Add(clsNewAmmoType.intID, clsNewAmmoType); } return(dicAmmoTypes); }
public static Dictionary <int, EffectType> GetAllEffectTypes() { Dictionary <int, EffectType> lclsEffectType = new Dictionary <int, EffectType>(); DataTable dtEffectType = MDatabaseUtilities.CreateDataTable("Select * from TEffectTypes Order By strName", Hidden.ExternalConnection); foreach (DataRow drRow in dtEffectType.Rows) { EffectType clsNewEffectType = new EffectType(); clsNewEffectType.intID = (int)drRow["intEffectTypeID"]; clsNewEffectType.strName = (string)drRow["strName"]; clsNewEffectType.strDescription = (string)drRow["strDescription"]; clsNewEffectType.strShortName = (string)drRow["strShortName"]; clsNewEffectType.enuType = (DataType)drRow["intDataTypeID"]; lclsEffectType.Add(clsNewEffectType.intID, clsNewEffectType); } return(lclsEffectType); }
public static Dictionary <int, Map> GetAllMaps() { Dictionary <int, Map> dicMaps = new Dictionary <int, Map>(); DataTable dtMaps = MDatabaseUtilities.CreateDataTable("Select * from TMaps ", Hidden.ExternalConnection); foreach (DataRow drRow in dtMaps.Rows) { Map clsNewMap = new Map { intID = (int)drRow["intMapID"], strName = (string)drRow["strName"] }; dicMaps.Add(clsNewMap.intID, clsNewMap); } return(dicMaps); }
public static Dictionary <int, Size> GetAllSizes() { Dictionary <int, Size> dicSizes = new Dictionary <int, Size>(); DataTable dtSizes = MDatabaseUtilities.CreateDataTable("Select * from TSizes ", Hidden.ExternalConnection); foreach (DataRow drRow in dtSizes.Rows) { Size clsNewSize = new Size { intID = (int)drRow["intSizeID"], strName = (string)drRow["strName"], }; dicSizes.Add(clsNewSize.intID, clsNewSize); } return(dicSizes); }
public static void AddAllTraitEffectsToTraits() { DataTable dtTraitEffects = MDatabaseUtilities.CreateDataTable("Select * from TTraitEffects WHERE intStatusID <> 4", Hidden.ExternalConnection); foreach (DataRow drRow in dtTraitEffects.Rows) { Trait clsTrait = AllData.Traits[(int)drRow["intTraitID"]]; TraitEffect clsNewTraitEffect = new TraitEffect(); clsNewTraitEffect.blnIsGlobal = (bool)drRow["blnIsGlobal"]; clsNewTraitEffect.intTraitEffectID = (int)drRow["intTraitEffectID"]; clsNewTraitEffect.intSubmitterID = (int)drRow["intSubmitterID"]; clsNewTraitEffect.strValue = (string)drRow["strValue"]; clsNewTraitEffect.clsType = AllData.EffectTypes[(int)drRow["intTraitEffectTypeID"]]; clsTrait.Effects.Add(clsNewTraitEffect.intTraitEffectID, clsNewTraitEffect); } }
protected void rptFiles_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Delete") { Classes.ModFile clsModFile = clsMod.lclsModFiles[int.Parse(e.CommandArgument.ToString())]; MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intModFileID", int.Parse(e.CommandArgument.ToString()))); MDatabaseUtilities.ExecuteStoredProcedure("uspDeleteModFile", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; FileInfo fiFile = new FileInfo(clsModFile.strLocation); if (fiFile.Exists) { fiFile.Delete(); } } else if (e.CommandName == "Save") { ModFile clsModFile = clsMod.lclsModFiles[clsMod.lclsModFiles.Keys.ToArray()[(e.Item.ItemIndex)]]; MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; string strFileLocation = clsModFile.strLocation; if (clsModFile.strVersion != ((System.Web.UI.WebControls.TextBox)e.Item.Controls[1]).Text) { FileInfo fiModFile = new FileInfo(clsModFile.strLocation); #if DEBUG strFileLocation = @"C:\Dev\ModFiles\" + txtName.Text + @"\" + ((System.Web.UI.WebControls.TextBox)e.Item.Controls[1]).Text + @"\" + clsModFile.strName; #else strFileLocation = @"C:\inetpub\wwwroot\SOD\ModFiles\" + txtName.Text + @"\" + ((System.Web.UI.WebControls.TextBox)e.Item.Controls[1]).Text + @"\" + clsModFile.strName; #endif FileInfo fiToLocation = new FileInfo(strFileLocation); fiToLocation.Directory.Create(); fiModFile.MoveTo(strFileLocation); } List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intModFileID", clsModFile.intID)); lclsParameters.Add(new CStoredProcedureParameter("@strDescription", ((System.Web.UI.WebControls.TextBox)e.Item.Controls[3]).Text)); lclsParameters.Add(new CStoredProcedureParameter("@strVersion", ((System.Web.UI.WebControls.TextBox)e.Item.Controls[1]).Text)); lclsParameters.Add(new CStoredProcedureParameter("@strLocation", strFileLocation)); MDatabaseUtilities.ExecuteStoredProcedure("uspUpdateModFile", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; } }
protected void btnSave_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intPrebuiltFacilityID", int.Parse(Request.QueryString["PID"]))); lclsParameters.Add(new CStoredProcedureParameter("@intBaseID", Numerics.Val(cmbBase.SelectedValue))); lclsParameters.Add(new CStoredProcedureParameter("@intFacilityID", Numerics.Val(cmbFacility.SelectedValue))); lclsParameters.Add(new CStoredProcedureParameter("@strName", txtName.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strDescription", txtDescription.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intEffectiveLevel", Numerics.Val(txtEffectiveLevel.Text))); lclsParameters.Add(new CStoredProcedureParameter("@blnIsDestroyable", txtIsDestroyable.Checked)); lclsParameters.Add(new CStoredProcedureParameter("@strNotes", txtNotes.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strScreenshotLocation", txtScreenshotLocation.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); MDatabaseUtilities.ExecuteStoredProcedure("uspUpsertPrebuiltFacility", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; Response.Redirect("ModifyBase.aspx?ID=" + Request.QueryString["BID"]); }
protected void btnSave_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@strName", txtName.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strDescription", txtDescription.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strScreenshotLocation", txtScreenshot.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); int intModID = MDatabaseUtilities.ExecuteStoredProcedure("uspAddMod", lclsParameters.ToArray()); if (intModID > 0) { foreach (HttpPostedFile hpfFile in fuModFiles.PostedFiles) { #if DEBUG string strFileLocation = @"C:\Dev\ModFiles\" + txtName.Text + @"\" + txtFileVersion.Text + @"\" + hpfFile.FileName; #else string strFileLocation = @"C:\inetpub\wwwroot\SOD\ModFiles\" + txtName.Text + @"\" + txtFileVersion.Text + @"\" + hpfFile.FileName; #endif FileInfo fiFile = new FileInfo(strFileLocation); fiFile.Directory.Create(); hpfFile.SaveAs(strFileLocation); lclsParameters.Clear(); lclsParameters.Add(new CStoredProcedureParameter("@intModID", intModID)); lclsParameters.Add(new CStoredProcedureParameter("@strName", hpfFile.FileName)); lclsParameters.Add(new CStoredProcedureParameter("@strVersion", txtFileVersion.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strLocation", strFileLocation)); lclsParameters.Add(new CStoredProcedureParameter("@strDescription", txtFileDescription.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); MDatabaseUtilities.ExecuteStoredProcedure("uspAddModFile", lclsParameters.ToArray()); } } Classes.AllData.IsDirty = true; Response.Redirect("Mods.aspx"); }
public static Dictionary <int, Gun> GetAllGuns() { Dictionary <int, Gun> dicGuns = new Dictionary <int, Gun>(); DataTable dtGuns = MDatabaseUtilities.CreateDataTable("Select * from TGuns", Hidden.ExternalConnection); foreach (DataRow drRow in dtGuns.Rows) { Gun clsNewGun = new Gun { intID = (int)drRow["intGunID"], strName = (string)drRow["strName"], strDescription = (string)drRow["strDescription"], strScreenshotLocation = (string)drRow["strScreenshotLocation"], strNotes = (string)drRow["strNotes"], strVisual = (string)drRow["strVisual"], strAudio = (string)drRow["strAudio"], strMagMod = (string)drRow["strMagMod"], strSightMod = (string)drRow["strSightMod"], strDefaultMod = (string)drRow["strDefaultMod"], strGameID = (string)drRow["strGameID"], clsGunType = AllData.GunTypes[(int)drRow["intGunTypeID"]], clsAmmoType = AllData.AmmoTypes[(int)drRow["intAmmoTypeID"]], decWeight = (decimal)drRow["decWeight"], intCapacity = (int)drRow["intCapacity"], intDurabilityInRounds = (int)drRow["intDurabilityInRounds"], blnCanFireSingle = (bool)drRow["blnCanFireSingle"], blnCanFireBurst = (bool)drRow["blnCanFireBurst"], blnCanFireAuto = (bool)drRow["blnCanFireAuto"], blnAcceptsAttachments = (bool)drRow["blnAcceptsAttachments"], blnOneInTheChamber = (bool)drRow["blnOneInTheChamber"], blnHasSight = (bool)drRow["blnHasSight"], intBuyPrice = (int)drRow["intBuyPrice"], intSellPrice = (int)drRow["intSellPrice"], intSalvage = (int)drRow["intSalvage"], blnRequiresModding = (bool)drRow["blnRequiresModding"], intSubmitterID = (int)drRow["intSubmitterID"] }; dicGuns.Add(clsNewGun.intID, clsNewGun); } return(dicGuns); }
public static Dictionary <int, Melee> GetAllMelees() { Dictionary <int, Melee> dicMelees = new Dictionary <int, Melee>(); DataTable dtMelees = MDatabaseUtilities.CreateDataTable("Select * from TMelees ", Hidden.ExternalConnection); foreach (DataRow drRow in dtMelees.Rows) { Melee clsNewMelee = new Melee { intID = (int)drRow["intMeleeID"], strName = (string)drRow["strName"], clsMeleeType = AllData.MeleeTypes[(int)drRow["intMeleeTypeID"]], decWeight = (decimal)drRow["decWeight"], strScreenshotLocation = (string)drRow["strScreenshotLocation"], intStatusID = (int)drRow["intStatusID"], intSubmitterID = (int)drRow["intSubmitterID"] }; dicMelees.Add(clsNewMelee.intID, clsNewMelee); } return(dicMelees); }
protected void rptFiles_ItemCommand(object source, RepeaterCommandEventArgs e) { Classes.ModFile clsModFile = clsMod.lclsModFiles[int.Parse(e.CommandArgument.ToString())]; MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intModID", clsModFile.intModID)); MDatabaseUtilities.ExecuteStoredProcedure("uspIncrementModScore", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; string header = "attachment; filename=" + clsModFile.strName; Response.Clear(); FileInfo fiFile = new FileInfo(clsModFile.strLocation); Response.ContentType = "application/octet-stream"; Response.AppendHeader("Content-Length", fiFile.Length.ToString()); Response.AppendHeader("Content-Disposition", header); Response.WriteFile(clsModFile.strLocation); Response.End(); }
protected void btnDelete_Click(object sender, EventArgs e) { Mod clsMod = AllData.Mods[int.Parse(Request.QueryString["ID"])]; MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intModID", int.Parse(Request.QueryString["ID"]))); MDatabaseUtilities.ExecuteStoredProcedure("uspDeleteMod", lclsParameters.ToArray()); foreach (ModFile clsModFile in clsMod.lclsModFiles.Values) { FileInfo fiFile = new FileInfo(clsModFile.strLocation); if (fiFile.Exists) { fiFile.Delete(); } } Classes.AllData.IsDirty = true; Response.Redirect("Mods.aspx"); }
public static Dictionary <int, Facility> GetAllFacilities() { Dictionary <int, Facility> dicFacilities = new Dictionary <int, Facility>(); DataTable dtFacilities = MDatabaseUtilities.CreateDataTable("Select * from TFacilities where intStatusID <> 4", Hidden.ExternalConnection); foreach (DataRow drRow in dtFacilities.Rows) { Facility clsNewFacility = new Facility { intID = (int)drRow["intFacilityID"], strName = (string)drRow["strName"], strDescription = (string)drRow["strDescription"], blnCanBePlacedIndoors = (bool)drRow["blnCanBePlacedIndoors"], blnCanBePlacedOutdoors = (bool)drRow["blnCanBePlacedOutdoors"], intStatusID = (int)drRow["intStatusID"], intSubmitterID = (int)drRow["intSubmitterID"], clsSize = AllData.Sizes[(int)drRow["intSizeID"]] }; dicFacilities.Add(clsNewFacility.intID, clsNewFacility); } return(dicFacilities); }
protected void btnSave_Click(object sender, EventArgs e) { MDatabaseUtilities.strCurrentConnectionString = Hidden.ExternalConnection; List <CStoredProcedureParameter> lclsParameters = new List <CStoredProcedureParameter>(); lclsParameters.Add(new CStoredProcedureParameter("@intBasesID", int.Parse(Request.QueryString["ID"]))); lclsParameters.Add(new CStoredProcedureParameter("@strName", txtName.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intMapID", Numerics.Val(cmbMap.SelectedValue))); lclsParameters.Add(new CStoredProcedureParameter("@intSmallExternalEmptyCount", txtSmallExternalEmptyCount.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intSmallInternalEmptyCount", txtSmallInternalEmptyCount.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intParkingCount", txtParkingCount.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intSizeID", Numerics.Val(cmbSize.SelectedValue))); lclsParameters.Add(new CStoredProcedureParameter("@intInfluenceCost", txtInfluenceCost.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intSurvivorsRequired", txtSurvivorsRequired.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intLargeEmptyCount", txtLargeEmptyCount.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strLocationScreenshotLocation", txtLocationScreenshotLocation.Text)); lclsParameters.Add(new CStoredProcedureParameter("@strSlotsScreenshotLocation", txtSlotsScreenshotLocation.Text)); lclsParameters.Add(new CStoredProcedureParameter("@intStatusID", 3)); lclsParameters.Add(new CStoredProcedureParameter("@intSubmitterID", ((Classes.Submitter)Session["Submitter"]).intID)); MDatabaseUtilities.ExecuteStoredProcedure("uspUpsertBase", lclsParameters.ToArray()); Classes.AllData.IsDirty = true; Response.Redirect("Bases.aspx"); }
public static Dictionary <int, Trait> GetAllTraits() { Dictionary <int, Trait> lclsTraits = new Dictionary <int, Trait>(); DataTable dtTraits = MDatabaseUtilities.CreateDataTable("Select * from TTraits where intStatusID <> 4 order by strName", Hidden.ExternalConnection); foreach (DataRow drRow in dtTraits.Rows) { Trait clsNewTrait = new Trait { intID = (int)drRow["intTraitID"], strName = (string)drRow["strName"], strDescription = (string)drRow["strDescription"], strNotes = (string)drRow["strNotes"], strScreenshotLocation = (string)drRow["strScreenshotLocation"], clsHeroBonus = AllData.HeroBonuses[(int)drRow["intHeroBonusID"]], intSubmitterID = (int)drRow["intSubmitterID"] }; lclsTraits.Add(clsNewTrait.intID, clsNewTrait); } return(lclsTraits); }
public static Dictionary <int, Mod> GetAllMods() { Dictionary <int, Mod> lclsMods = new Dictionary <int, Mod>(); DataTable dtMods = MDatabaseUtilities.CreateDataTable("Select * from TMods where intStatusID <> 4 order by intScore desc", Hidden.ExternalConnection); foreach (DataRow drRow in dtMods.Rows) { Mod clsNewMod = new Mod { intID = (int)drRow["intModID"], strName = (string)drRow["strName"], strDescription = ((string)drRow["strDescription"]), intScore = (int)drRow["intScore"], intStatusID = (int)drRow["intStatusID"], intSubmitterID = (int)drRow["intSubmitterID"], strScreenshotLocation = (string)drRow["strScreenshotLocation"] }; lclsMods.Add(clsNewMod.intID, clsNewMod); } return(lclsMods); }