public void InsertCard(SheetCard newCard)
{
try
{
ConsultationAccessor.InsertCard(newCard);
}
catch (Exception)
{
throw;
}
}
public static int InsertCard(SheetCard newCard)
{
int rowsAffected = 0;
var conn = DatabaseConnection.GetExEventDatabaseConnection();
var cmdText = "spInsertCard";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@sheet_id", newCard.sheetID);
cmd.Parameters.AddWithValue("@card_slot", newCard.cardSlot);
cmd.Parameters.AddWithValue("@card_name", newCard.cardName);
cmd.Parameters.AddWithValue("@requested_date", newCard.requestedDate);
cmd.Parameters.AddWithValue("@award_date", newCard.awardDate);
cmd.Parameters.AddWithValue("@awarded_by", newCard.awardedBy);
cmd.Parameters.AddWithValue("@award_method", newCard.awardMethod);
cmd.Parameters.AddWithValue("@award_note", newCard.awardNote);
try
{
conn.Open();
rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new ApplicationException("Card Insert Failed. Please refresh and try again.");
}
}
catch (Exception)
{
throw;
}
return(rowsAffected);
}
public void updateCard(string c, int empID)
{
Employee loggedInEmployee = (Employee)Session["loggedInUser"];
ConsultationCard oldCard = _myConsultationCardManager.FindCard(empID);
ConsultationCard updatedCard = oldCard;
int consultantID = Convert.ToInt32(Request.QueryString["agent"]);
ConsultationSheet currentSheet = _myConsultationCardManager.SelectCurrentConsultationSheet(consultantID);
SheetCard newSheetCard = new SheetCard();
newSheetCard.sheetID = currentSheet.sheetID;
int cardCount = _myConsultationCardManager.SelectCurrentCardSheetCount(currentSheet.sheetID);
int newCount = cardCount + 1;
newSheetCard.cardSlot = newCount;
newSheetCard.cardName = c;
switch (c)
{
case "Communication":
updatedCard.Communication = 1;
newSheetCard.requestedDate = updatedCard.CommunicationRequestDate;
break;
case "Competitors":
updatedCard.Competitors = 1;
newSheetCard.requestedDate = updatedCard.CompetitorsRequestDate;
break;
case "Goals":
updatedCard.Goals = 1;
newSheetCard.requestedDate = updatedCard.GoalsRequestDate;
break;
case "Growth":
updatedCard.Growth = 1;
newSheetCard.requestedDate = updatedCard.GrowthRequestDate;
break;
case "Headcount":
updatedCard.Headcount = 1;
newSheetCard.requestedDate = updatedCard.HeadcountRequestDate;
break;
case "Market":
updatedCard.Market = 1;
newSheetCard.requestedDate = updatedCard.MarketRequestDate;
break;
case "Rapport":
updatedCard.Rapport = 1;
newSheetCard.requestedDate = updatedCard.RapportRequestDate;
break;
case "Recommended":
updatedCard.Recommended = 1;
newSheetCard.requestedDate = updatedCard.RecommendedRequestDate;
break;
case "Term":
updatedCard.Term = 1;
newSheetCard.requestedDate = updatedCard.TermRequestDate;
break;
case "Website":
updatedCard.Website = 1;
newSheetCard.requestedDate = updatedCard.WebsiteRequestDate;
break;
}
newSheetCard.awardDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
newSheetCard.awardedBy = loggedInEmployee.FirstName + " " + loggedInEmployee.LastName;
newSheetCard.awardMethod = ddlMethod.SelectedValue;
newSheetCard.awardNote = txtNote.Text;
//updatedCard.RequestDate = "1/1/1900 12:00:00";
_myConsultationCardManager.InsertCard(newSheetCard);
_myConsultationCardManager.UpdateConsultationCard(oldCard, updatedCard);
Employee currentEmp = _myEmployeeManager.FindSingleEmployee(updatedCard.EmployeeID);
SendMail(currentEmp.FirstName, c, currentEmp.EmailAddress);
if (updatedCard.Communication == 1 && updatedCard.Competitors == 1 && updatedCard.Goals == 1 && updatedCard.Growth == 1 && updatedCard.Headcount == 1 && updatedCard.Market == 1 && updatedCard.Rapport == 1 && updatedCard.Recommended == 1 && updatedCard.Term == 1 && updatedCard.Website == 1)
{
ConsultationSheet newSheet = currentSheet;
newSheet.completedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
_myConsultationCardManager.CloseCardSheet(currentSheet, newSheet);
_myConsultationCardManager.CreateNewCardSheet(consultantID);
addEntry(consultantID);
SendEntryMail(currentEmp.FirstName, currentEmp.EmailAddress);
}
Response.Redirect(Request.RawUrl);
}
