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