internal void getGirl(int userId, int girlId, Troops troopInfo, Girls girlInfo)
{
using (SqlConnection conn = new SqlConnection(DB.DB_Conn))
{
dbOps.connectToDB(conn);
SqlCommand comm = new SqlCommand("usp_getGirlRecord", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@intUserId", userId));
comm.Parameters.Add(new SqlParameter("@intGirlId", girlId));
comm.Parameters.Add(new SqlParameter("@strFirstName", SqlDbType.VarChar, 20));
comm.Parameters.Add(new SqlParameter("@strLastName", SqlDbType.VarChar, 20));
comm.Parameters.Add(new SqlParameter("@dtmDOB", SqlDbType.DateTime));
comm.Parameters.Add(new SqlParameter("@intLevelId", SqlDbType.Int));
comm.Parameters.Add(new SqlParameter("@strLevel", SqlDbType.VarChar, 25));
comm.Parameters.Add(new SqlParameter("@intTroopId", SqlDbType.Int));
comm.Parameters.Add(new SqlParameter("@intTroopNumber", SqlDbType.Int));
comm.Parameters.Add(new SqlParameter("@strCommunity", SqlDbType.VarChar, 50));
comm.Parameters.Add(new SqlParameter("@intRegionNumber", SqlDbType.Int));
comm.Parameters.Add(new SqlParameter("@strCouncil", SqlDbType.VarChar, 50));
comm.Parameters["@strFirstName"].Direction = ParameterDirection.Output;
comm.Parameters["@strLastName"].Direction = ParameterDirection.Output;
comm.Parameters["@dtmDOB"].Direction = ParameterDirection.Output;
comm.Parameters["@intLevelId"].Direction = ParameterDirection.Output;
comm.Parameters["@strLevel"].Direction = ParameterDirection.Output;
comm.Parameters["@intTroopId"].Direction = ParameterDirection.Output;
comm.Parameters["@intTroopNumber"].Direction = ParameterDirection.Output;
comm.Parameters["@strCommunity"].Direction = ParameterDirection.Output;
comm.Parameters["@intRegionNumber"].Direction = ParameterDirection.Output;
comm.Parameters["@strCouncil"].Direction = ParameterDirection.Output;
try
{
comm.ExecuteNonQuery();
girlInfo.girl_Id = girlId;
girlInfo.user_Id = userId;
girlInfo.firstName = Convert.ToString(comm.Parameters["@strFirstName"].Value);
girlInfo.lastName = Convert.ToString(comm.Parameters["@strLastName"].Value);
girlInfo.dob = Convert.ToDateTime(comm.Parameters["@dtmDOB"].Value);
girlInfo.level_Id = (int)comm.Parameters["@intLevelId"].Value;
girlInfo.classLevel = Convert.ToString(comm.Parameters["@strLevel"].Value);
girlInfo.troop_Id = (int)comm.Parameters["@intTroopId"].Value;
troopInfo.troop_Id = (int)comm.Parameters["@intTroopId"].Value;
troopInfo.troop_nbr = (int)comm.Parameters["@intTroopNumber"].Value;
troopInfo.community = Convert.ToString(comm.Parameters["@strCommunity"].Value);
troopInfo.region_Id = (int)comm.Parameters["@intRegionNumber"].Value;
troopInfo.council = Convert.ToString(comm.Parameters["@strCouncil"].Value);
}
catch (Exception e)
{
MessageBox.Show(e.ToString(),
sysMessages.dbError,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
internal void NewOrder(
int orderTypeId,
DateTime orderDate,
int troopId,
int cookieId,
int cookieQty,
int userId,
Troops troops)
{
using (SqlConnection conn = new SqlConnection(DB.DB_Conn))
{
dbOps.connectToDB(conn);
SqlCommand comm = new SqlCommand("usp_insertOrderRecord", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@intOrderType", orderTypeId));
comm.Parameters.Add(new SqlParameter("@dtmOrderDate", orderDate.ToLocalTime()));
comm.Parameters.Add(new SqlParameter("@intTroopId", troopId));
comm.Parameters.Add(new SqlParameter("@intCookieId", cookieId));
comm.Parameters.Add(new SqlParameter("@intQty", cookieQty));
comm.Parameters.Add(new SqlParameter("@intDirection", 1));
comm.Parameters.Add(new SqlParameter("@intGirlId", -1));
comm.Parameters.Add(new SqlParameter("@intBoothId", -1));
comm.Parameters.Add(new SqlParameter("@intUserId", userId));
comm.Parameters.Add(new SqlParameter("@intReturn", SqlDbType.Int));
comm.Parameters["@intReturn"].Direction = ParameterDirection.Output;
try
{
comm.ExecuteNonQuery();
orderInfo.order_Type = Convert.ToInt32(comm.Parameters["@intOrderType"].Value);
orderInfo.order_Date = Convert.ToDateTime(comm.Parameters["@dtmOrderDate"].Value);
orderInfo.troop_Id = Convert.ToInt32(comm.Parameters["@intTroopId"].Value);
orderInfo.cookie_Id = Convert.ToInt32(comm.Parameters["@intCookieId"].Value);
orderInfo.cookie_Qty = Convert.ToInt32(comm.Parameters["@intQty"].Value);
orderInfo.user_Id = Convert.ToInt32(comm.Parameters["@intUserId"].Value);
retval = Convert.ToInt32(comm.Parameters["@intReturn"].Value);
}
catch (Exception e)
{
MessageBox.Show(e.ToString(),
sysMessages.dbError,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
internal void getTroopInfo(int troopId, Troops troopInfo)
{
using (SqlConnection conn = new SqlConnection(DB.DB_Conn))
{
dbOps.connectToDB(conn);
SqlCommand comm = new SqlCommand("usp_getTroopInfo", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@intTroopId", troopId));
comm.Parameters.Add(new SqlParameter("@intTroopNbr", SqlDbType.Int));
comm.Parameters.Add(new SqlParameter("@strCommunity", SqlDbType.VarChar, 50));
comm.Parameters.Add(new SqlParameter("@intRegionNbr", SqlDbType.Int));
comm.Parameters.Add(new SqlParameter("@strCouncil", SqlDbType.VarChar, 50));
comm.Parameters["@intTroopNbr"].Direction = ParameterDirection.Output;
comm.Parameters["@strCommunity"].Direction = ParameterDirection.Output;
comm.Parameters["@intRegionNbr"].Direction = ParameterDirection.Output;
comm.Parameters["@strCouncil"].Direction = ParameterDirection.Output;
try
{
comm.ExecuteNonQuery();
troopInfo.troop_Id = troopId;
troopInfo.troop_nbr = (int)comm.Parameters["@intTroopNbr"].Value;
troopInfo.community = Convert.ToString(comm.Parameters["@strCommunity"].Value);
troopInfo.region_Id = (int)comm.Parameters["@intRegionNbr"].Value;
troopInfo.council = Convert.ToString(comm.Parameters["@strCouncil"].Value);
}
catch (Exception e)
{
MessageBox.Show(e.ToString(),
sysMessages.dbError,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
internal void NewGirl(
Troops troops,
string firstName,
string lastName,
DateTime dob,
int levelId,
int troopId,
int userId)
{
using (SqlConnection conn = new SqlConnection(DB.DB_Conn))
{
dbOps.connectToDB(conn);
SqlCommand comm = new SqlCommand("usp_insertGirlRecord", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@strFirstName", firstName));
comm.Parameters.Add(new SqlParameter("@strLastName", lastName));
comm.Parameters.Add(new SqlParameter("@dtmDOB", dob));
comm.Parameters.Add(new SqlParameter("@intLevelId", levelId));
comm.Parameters.Add(new SqlParameter("@intTroopId", troopId));
comm.Parameters.Add(new SqlParameter("@intUserId", userId));
comm.Parameters.Add(new SqlParameter("@dtmCreationDate", DateTime.Today.ToLocalTime()));
comm.Parameters.Add(new SqlParameter("@intReturn", SqlDbType.Int));
comm.Parameters["@intReturn"].Direction = ParameterDirection.Output;
try
{
comm.ExecuteNonQuery();
girlInfo.firstName = Convert.ToString(comm.Parameters["@strFirstName"].Value);
girlInfo.lastName = Convert.ToString(comm.Parameters["@strLastName"].Value);
girlInfo.dob = Convert.ToDateTime(comm.Parameters["@dtmDOB"].Value);
girlInfo.level_Id = Convert.ToInt32(comm.Parameters["@intLevelId"].Value);
girlInfo.troop_Id = Convert.ToInt32(comm.Parameters["@intTroopId"].Value);
girlInfo.user_Id = Convert.ToInt32(comm.Parameters["@intUserId"].Value);
retval = Convert.ToInt32(comm.Parameters["@intReturn"].Value);
}
catch (Exception e)
{
MessageBox.Show(e.ToString(),
sysMessages.dbError,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
if (retval == 0)
{
troopInfo.getTroopInfo(girlInfo.troop_Id, troops);
string msg = girlInfo.firstName + " " + girlInfo.lastName + sysMessages.msgSpace + sysMessages.msgWasSuccessfully +
sysMessages.msgSpace + sysMessages.msgAdded + sysMessages.msgSpace + sysMessages.msgTroop +
sysMessages.msgSpace + troops.troop_nbr + sysMessages.msgPeriod;
MessageBox.Show(msg,
sysMessages.msgAddNewGirl,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
string msg = girlInfo.firstName + sysMessages.msgSpace + girlInfo.lastName + sysMessages.msgSpace + sysMessages.msgExists;
MessageBox.Show(msg,
sysMessages.msgNoNewGirl,
MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
}
}
}
}
