private List <CardType> fillCardTypeList()
{
CardTypeBusiness _CardTypeBusiness = new CardTypeBusiness();
CardTypeList _CardTypeList = _CardTypeBusiness.SelectRows(null, null, null);
return(_CardTypeList);
}
private void Clearbtn_Click(object sender, EventArgs e)
{
CardID.Clear();
Alias.Text = "0";
CardFormats.SelectedIndex = -1;
SetCodeLst.SelectedIndex = -1;
OtherSetCodeLst.SelectedIndex = -1;
Level.SelectedIndex = -1;
Race.SelectedIndex = -1;
CardAttribute.SelectedIndex = -1;
ATK.Text = "0";
DEF.Text = "0";
CardName.Clear();
CardDescription.Clear();
EffectList.Items.Clear();
for (int i = 0; i < CardTypeList.Items.Count; i++)
{
CardTypeList.SetItemCheckState(i, CheckState.Unchecked);
}
for (int i = 0; i < CategoryList.Items.Count; i++)
{
CategoryList.SetItemCheckState(i, CheckState.Unchecked);
}
m_loadedCard = 0;
CardImg.Image = Resources.unknown;
m_loadedImage = "";
}
/// <summary>
/// To GET ALL CardType
/// </summary>
/// <returns></returns>
public CardTypeList GETALLCardType()
{
// used in Master page
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = " USP_MST_GETALLCardType";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CardTypeBO objCardType = null;
CardTypeList CardType = new CardTypeList();
while (dr.Read())
{
objCardType = new CardTypeBO();
objCardType.CardTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CardTypeID")));
objCardType.CardTypeName = dr.GetString(dr.GetOrdinal("CARDNAME"));
objCardType.Isdeleted = dr.GetString(dr.GetOrdinal("IsDeleted"));
CardType.Add(objCardType);
}
dr.Close();
return(CardType);
}
/// <summary>
/// get the data based on ID
/// </summary>
/// <param name="CardTypeID"></param>
/// <returns></returns>
public CardTypeBO GetCardTypeById(int CardTypeID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETSELECTCardType";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CardTypeID_", CardTypeID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CardTypeBO CardTypeObj = null;
CardTypeList Users = new CardTypeList();
CardTypeObj = new CardTypeBO();
while (dr.Read())
{
if (ColumnExists(dr, "CARDNAME") && !dr.IsDBNull(dr.GetOrdinal("CARDNAME")))
{
CardTypeObj.CardTypeName = dr.GetString(dr.GetOrdinal("CARDNAME"));
}
if (ColumnExists(dr, "CardTypeID") && !dr.IsDBNull(dr.GetOrdinal("CardTypeID")))
{
CardTypeObj.CardTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CardTypeID")));
}
}
dr.Close();
return(CardTypeObj);
}
public int SaveRows(DbTransaction pTran, CardTypeList CardTypeList, bool CreateTransaction)
{
int intRows = 0;
DbTransaction objTran = pTran;
Exception exception = null;
try
{
if (pTran == null && CreateTransaction == true)
{
objTran = CardTypeData.CreateTransaction();
}
intRows = CardTypeData.SaveRows(objTran, CardTypeList);
if (pTran == null && objTran != null && CreateTransaction == true)
{
CardTypeData.CommitTransaction(objTran, true);
objTran = null;
}
}
catch (Exception EX)
{
exception = EX;
if (pTran == null && objTran != null && CreateTransaction == true)
{
CardTypeData.RollbackTransaction(objTran, true);
objTran = null;
}
}
finally
{
}
return(intRows);
}
public CardTypeList SelectRows(DbTransaction pTran, System.Int32?Id, System.String name, System.String nameAr)
{
CardTypeList CardTypeList = new CardTypeList();
Exception exception = null;
DbParameter[] Parameters = new DbParameter[3];
Parameters[0] = _getIdParameter(Id, ParameterDirection.Input);
Parameters[1] = _getnameParameter(name, ParameterDirection.Input);
Parameters[2] = _getnameArParameter(nameAr, ParameterDirection.Input);
DbDataReader Dr = ExecuteReader(pTran, "[Lookups].[SelectCardType]", Parameters);
try
{
if (Dr != null)
{
while (Dr.Read())
{
CardType CardType = new CardType();
if (Dr["Id"] != DBNull.Value)
{
CardType.Id = (System.Int32)Dr["Id"];
}
if (Dr["name"] != DBNull.Value)
{
CardType.name = (System.String)Dr["name"];
}
if (Dr["nameAr"] != DBNull.Value)
{
CardType.nameAr = (System.String)Dr["nameAr"];
}
CardTypeList.FillRow(CardType);
CardType = null;
}
}
}
catch (Exception Ex)
{
exception = Ex;
}
finally
{
if (Dr != null)
{
if (Dr.IsClosed == false)
{
Dr.Close();
}
Dr = null;
}
}
return(CardTypeList);
}
private void Clearbtn_Click(object sender, EventArgs e)
{
CardID.Clear();
Alias.Text = "0";
CardFormats.SelectedIndex = -1;
SetCodeOne.SelectedIndex = -1;
SetCodeTwo.SelectedIndex = -1;
SetCodeThree.SelectedIndex = -1;
SetCodeFour.SelectedIndex = -1;
Level.SelectedIndex = -1;
RScale.SelectedIndex = 0;
LScale.SelectedIndex = 0;
Race.SelectedIndex = -1;
CardAttribute.SelectedIndex = -1;
ATK.Text = "0";
DEF.Text = "0";
CardName.Clear();
CardDescription.Clear();
EffectList.Items.Clear();
for (int i = 0; i < CardTypeList.Items.Count; i++)
{
CardTypeList.SetItemCheckState(i, CheckState.Unchecked);
}
for (int i = 0; i < CategoryList.Items.Count; i++)
{
CategoryList.SetItemCheckState(i, CheckState.Unchecked);
}
foreach (CheckBox chkBox in linkMarkers.Values)
{
chkBox.Checked = false;
}
linkMarkerPanel.Enabled = false;
m_loadedCard = 0;
CardImg.Image = Resources.unknown;
}
public int SaveRows(DbTransaction pTran, CardTypeList CardTypeList)
{
int intRows = 0;
for (int i = 0; i < CardTypeList.Count; i++)
{
switch (CardTypeList[i].CommonState)
{
case CommonState.Added:
intRows += InsertRow(pTran, CardTypeList[i]);
break;
case CommonState.Modified:
intRows += UpdateRow(pTran, CardTypeList[i]);
break;
case CommonState.Deleted:
intRows += DeleteRow(pTran, CardTypeList[i]);
break;
}
}
return(intRows);
}
private int GetTypeCode()
{
int code = 0;
if (CardTypeList.GetItemCheckState(0) == CheckState.Checked)
{
code += (int)CardType.Monster;
}
if (CardTypeList.GetItemCheckState(1) == CheckState.Checked)
{
code += (int)CardType.Spell;
}
if (CardTypeList.GetItemCheckState(2) == CheckState.Checked)
{
code += (int)CardType.Trap;
}
if (CardTypeList.GetItemCheckState(3) == CheckState.Checked)
{
code += (int)CardType.Normal;
}
if (CardTypeList.GetItemCheckState(4) == CheckState.Checked)
{
code += (int)CardType.Effect;
}
if (CardTypeList.GetItemCheckState(5) == CheckState.Checked)
{
code += (int)CardType.Fusion;
}
if (CardTypeList.GetItemCheckState(6) == CheckState.Checked)
{
code += (int)CardType.Ritual;
}
if (CardTypeList.GetItemCheckState(7) == CheckState.Checked)
{
code += (int)CardType.TrapMonster;
}
if (CardTypeList.GetItemCheckState(8) == CheckState.Checked)
{
code += (int)CardType.Spirit;
}
if (CardTypeList.GetItemCheckState(9) == CheckState.Checked)
{
code += (int)CardType.Union;
}
if (CardTypeList.GetItemCheckState(10) == CheckState.Checked)
{
code += (int)CardType.Gemini;
}
if (CardTypeList.GetItemCheckState(11) == CheckState.Checked)
{
code += (int)CardType.Tuner;
}
if (CardTypeList.GetItemCheckState(12) == CheckState.Checked)
{
code += (int)CardType.Synchro;
}
if (CardTypeList.GetItemCheckState(13) == CheckState.Checked)
{
code += (int)CardType.Token;
}
if (CardTypeList.GetItemCheckState(14) == CheckState.Checked)
{
code += (int)CardType.QuickPlay;
}
if (CardTypeList.GetItemCheckState(15) == CheckState.Checked)
{
code += (int)CardType.Continuous;
}
if (CardTypeList.GetItemCheckState(16) == CheckState.Checked)
{
code += (int)CardType.Equip;
}
if (CardTypeList.GetItemCheckState(17) == CheckState.Checked)
{
code += (int)CardType.Field;
}
if (CardTypeList.GetItemCheckState(18) == CheckState.Checked)
{
code += (int)CardType.Counter;
}
if (CardTypeList.GetItemCheckState(19) == CheckState.Checked)
{
code += (int)CardType.Flip;
}
if (CardTypeList.GetItemCheckState(20) == CheckState.Checked)
{
code += (int)CardType.Toon;
}
if (CardTypeList.GetItemCheckState(21) == CheckState.Checked)
{
code += (int)CardType.Xyz;
}
return(code);
}
private void SetCardTypes(IEnumerable <CardType> types)
{
foreach (var cardtype in types)
{
switch (cardtype)
{
case CardType.Monster:
CardTypeList.SetItemCheckState(0, CheckState.Checked);
break;
case CardType.Spell:
CardTypeList.SetItemCheckState(1, CheckState.Checked);
break;
case CardType.Trap:
CardTypeList.SetItemCheckState(2, CheckState.Checked);
break;
case CardType.Normal:
CardTypeList.SetItemCheckState(3, CheckState.Checked);
break;
case CardType.Effect:
CardTypeList.SetItemCheckState(4, CheckState.Checked);
break;
case CardType.Fusion:
CardTypeList.SetItemCheckState(5, CheckState.Checked);
break;
case CardType.Ritual:
CardTypeList.SetItemCheckState(6, CheckState.Checked);
break;
case CardType.TrapMonster:
CardTypeList.SetItemCheckState(7, CheckState.Checked);
break;
case CardType.Spirit:
CardTypeList.SetItemCheckState(8, CheckState.Checked);
break;
case CardType.Union:
CardTypeList.SetItemCheckState(9, CheckState.Checked);
break;
case CardType.Gemini:
CardTypeList.SetItemCheckState(10, CheckState.Checked);
break;
case CardType.Tuner:
CardTypeList.SetItemCheckState(11, CheckState.Checked);
break;
case CardType.Synchro:
CardTypeList.SetItemCheckState(12, CheckState.Checked);
break;
case CardType.Token:
CardTypeList.SetItemCheckState(13, CheckState.Checked);
break;
case CardType.QuickPlay:
CardTypeList.SetItemCheckState(14, CheckState.Checked);
break;
case CardType.Continuous:
CardTypeList.SetItemCheckState(15, CheckState.Checked);
break;
case CardType.Equip:
CardTypeList.SetItemCheckState(16, CheckState.Checked);
break;
case CardType.Field:
CardTypeList.SetItemCheckState(17, CheckState.Checked);
break;
case CardType.Counter:
CardTypeList.SetItemCheckState(18, CheckState.Checked);
break;
case CardType.Flip:
CardTypeList.SetItemCheckState(19, CheckState.Checked);
break;
case CardType.Toon:
CardTypeList.SetItemCheckState(20, CheckState.Checked);
break;
case CardType.Xyz:
CardTypeList.SetItemCheckState(21, CheckState.Checked);
break;
}
}
}
public int SaveRows(CardTypeList CardTypeList)
{
DbTransaction Tran = null;
return(SaveRows(Tran, CardTypeList));
}
public int SaveRows(DbTransaction pTran, CardTypeList CardTypeList)
{
return(SaveRows(pTran, CardTypeList, true));
}
