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