public ActionResult PostTicket(String Subject, String Email)
{//Should the ticket processing be handled like this?
var formManager = new FormDetails(Subject, Email);
var createResponse = new TicketManager();
var response = createResponse.TicketPostResponse(formManager);
return(Content(response, "application/json"));
}
public void CreateNewForm()
{
var form = new StoreForm();
var formDetails = new FormDetails {
Form = form
};
ApplyNewFormDefaults(formDetails);
Model.Forms.Add(formDetails);
OpenWindow(form);
formDetails.Model.IsDirty = true;
}
private void ApplyNewFormDefaults(FormDetails formDetails)
{
formDetails.Form.Name = GetNextFormName();
formDetails.Form.Caption = formDetails.Form.Name;
formDetails.Form.Namespace = _currentProject.Settings.DefaultFormNamespace ?? _currentProject.Settings.DefaultNamespace;
formDetails.Form.PageHeaderFormReadOnly = true;
if (Model.Schemas.Count == 1)
{
formDetails.Form.Schema = Model.Schemas.First().Schema.Name;
formDetails.Form.Schema = Model.Schemas.First().Schema.Name;
}
}
public async Task <IActionResult> PostFormDetails([FromBody] FormDetails formDetails)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.FormDetails.Add(formDetails);
await _context.SaveChangesAsync();
//return CreatedAtAction("GetFormDetails", new { id = formDetails.FormDetailsId }, formDetails);
return(Created("GetFormDetails", formDetails.FormDetailsId));
}
public async Task <FormDetails> GetDetailsById(string id, string username)
{
var form = await FormRepository.GetById(id);
if (form.CreatorId != username)
{
return(null);
}
var answers = AnswerRepository.GetByFormId(id);
var details = new FormDetails();
return(details);
}
public async Task <IActionResult> SaveFormDetails([Bind("Id,FormContent")] FormJson formDetails)
{
FormDetails obj = new FormDetails();
obj.Id = formDetails.Id;
obj.FromDetailsEntered = formDetails.FormContent;
if (ModelState.IsValid)
{
_context.Add(obj);
await _context.SaveChangesAsync();
return(View(obj));
}
return(View(obj));
}
public ActionResult Index()//the main page when it loads it will have all the page refreshed and the dropdown list filled properly.
{
FormInsert infoReader = new FormInsert();
List <SizeReference> sizeRef = infoReader.GetSizeReferences();
List <ClothesColorReference> clothesColorRef = infoReader.GetClothesColorReference();
List <PrintColorReference> printColorRef = infoReader.GetPrintColorReference();
List <CustomLaceColorReference> laceColorRef = infoReader.GetCustomLaceColorReference();
FormDetails formDetails = new FormDetails();
formDetails.sizes = sizeRef;
formDetails.clothesColor = clothesColorRef;
formDetails.printColor = printColorRef;
formDetails.laceColor = laceColorRef;
return(View("Index", formDetails));
}
public ActionResult Submit(FormDetails fd)//submitting the information to the database
{
FormInsert infoReader = new FormInsert();
List <SizeReference> sizeRef = infoReader.GetSizeReferences();
List <ClothesColorReference> clothesColorRef = infoReader.GetClothesColorReference();
List <PrintColorReference> printColorRef = infoReader.GetPrintColorReference();
List <CustomLaceColorReference> laceColorRef = infoReader.GetCustomLaceColorReference();
FormDetails formDetails = new FormDetails();
formDetails.sizes = sizeRef;
formDetails.clothesColor = clothesColorRef;
formDetails.printColor = printColorRef;
formDetails.laceColor = laceColorRef;
string test = "";
test = fd.clothingType;
test = formDetails.clothingType;
FormInsert findEstimate = new FormInsert();
//int Result = findEstimate.GetEstimatedCost(fd);
//validation starts here
if (fd.clothingType == "")//makes sure they choose an option
{
ModelState.AddModelError("clothingType", "Choose a clothing type");
fd.confirmationButton = false;
}
if (fd.clothingType != "PO")//if the choice is not Print Only they must choose size and color
{
if (fd.sizeCode == "00")
{
ModelState.AddModelError("sizeCode", "Choose a size");
fd.confirmationButton = false;
}
if (fd.clothesColorCode == "00")
{
ModelState.AddModelError("clothesColorCode", "Choose a clothes color");
fd.confirmationButton = false;
}
}
if (fd.printColorCode == "00")//if they choose print only, they must choose a print color
{
ModelState.AddModelError("printColorCode", "Choose a print color");
fd.confirmationButton = false;
}
else
{
if (fd.fontType == "")
{
ModelState.AddModelError("fontType", "Choose a font");
fd.confirmationButton = false;
}
}
//if(fd.ticketNumber == null)//makes sure the ticket section is filled out
//{
// ModelState.AddModelError("ticketNumber", "Enter a ticket number");
//}
int Result = findEstimate.Insert(fd);
formDetails.estimatedCost = fd.estimatedCost;
if (fd.confirmationButton) //if the confirmation isnt pressed, we can't continue
{
if (ModelState.IsValid) //if the confirmation button is clicked, we still need to check if the previous validations passed.
{
//FormInsert finsert = new FormInsert();
return(RedirectToAction("Index", fd));
}
else
{
return(View("Index", formDetails));
}
}
return(View("Index", formDetails));
}
public static SuperEventDetails CreateObject(PayLoad payLoad)
{
SuperEventDetails superEventDetail = new SuperEventDetails();
foreach (Event _event in payLoad.Data)
{
if (_event.AdditionalDetails == null)
{
_event.AdditionalDetails = new AdditionalDetails();
}
List <EventDetailHeader> gett = new List <EventDetailHeader>();
var eventDetailHeader = new EventDetailHeader()
{
EventID = _event.EventID,
NextStreamPosition = payLoad.NextStreamPosition,
EventTimeStamp = _event.EventTimestamp
};
superEventDetail.EventDetailHeaders.Add(eventDetailHeader);
switch (_event.ObjectType)
{
case "SHEET":
var sheetDetail = new SheetDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
SourceObjectID = _event.AdditionalDetails.SourceObjectID,
SourceGlobaltemplateID = _event.AdditionalDetails.SourceGlobalTemplateID,
SourcetemplateID = _event.AdditionalDetails.SourceTemplateID,
Source = _event.AdditionalDetails.Source,
SourceType = _event.AdditionalDetails.SourceType,
SheetName = _event.AdditionalDetails.SheetName,
NewName = _event.AdditionalDetails.NewName,
OldName = _event.AdditionalDetails.OldName,
AccessLevel = _event.AdditionalDetails.AccessLevel,
UserIDInitiator = _event.AdditionalDetails.UserID,
GroupID = _event.AdditionalDetails.GroupID,
WorkSpaceID = _event.AdditionalDetails.WorkSpaceID,
OldUserID = _event.AdditionalDetails.OldUserID,
OldAccessLevel = _event.AdditionalDetails.OldAccessLevel,
NewUserID = _event.AdditionalDetails.NewUserID,
NewAccessLevel = _event.AdditionalDetails.NewAccessLevel,
RecipientEmail = _event.AdditionalDetails.RecipientEmail,
RecipientGroupID = _event.AdditionalDetails.RecipientGroupID,
FormatType = _event.AdditionalDetails.FormatType,
RowCount = _event.AdditionalDetails.RowCount,
IncludeAttachments = _event.AdditionalDetails.IncludeAttachments,
IncludeDiscussions = _event.AdditionalDetails.IncludeDiscussions,
SourceSheetID = _event.AdditionalDetails.SourceSheetID,
DestinationSheetID = _event.AdditionalDetails.DestinationSheetID,
RowsMoved = _event.AdditionalDetails.RowsMoved,
RowsCopied = _event.AdditionalDetails.RowsCopied,
CelllinkSourceSheetID = _event.AdditionalDetails.CelllinkSourceSheetID,
NewParentContainerID = _event.AdditionalDetails.NewParentContainerID,
ParentContainerID = _event.AdditionalDetails.ParentContainerID,
FolderName = _event.AdditionalDetails.FolderName,
RequestUserID = _event.AdditionalDetails.RequestUserID,
SendCompletionEmail = _event.AdditionalDetails.SendCompletionEmail,
UserIDImpacted = _event.AdditionalDetails.UserIDImpacted,
EventTimestamp = _event.AdditionalDetails.EventTimeStamp
};
superEventDetail.SheetDetails.Add(sheetDetail);
break;
case "REPORT":
var reportDetail = new ReportDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
ReportName = _event.AdditionalDetails.ReportName,
SourceObjectID = _event.AdditionalDetails.SourceObjectID,
SourceGlobaltemplateID = _event.AdditionalDetails.SourceGlobalTemplateID,
SourceType = _event.AdditionalDetails.SourceType,
NewName = _event.AdditionalDetails.NewName,
OldName = _event.AdditionalDetails.OldName,
AccessLevel = _event.AdditionalDetails.AccessLevel,
UserID = _event.AdditionalDetails.UserID,
GroupID = _event.AdditionalDetails.GroupID,
WorkSpaceID = _event.AdditionalDetails.WorkSpaceID,
OldUserID = _event.AdditionalDetails.OldUserID,
OldAccessLevel = _event.AdditionalDetails.OldAccessLevel,
NewUserID = _event.AdditionalDetails.NewUserID,
NewAccessLevel = _event.AdditionalDetails.NewAccessLevel,
NewParentContainerID = _event.AdditionalDetails.NewParentContainerID,
ParentContainerID = _event.AdditionalDetails.ParentContainerID,
FolderName = _event.AdditionalDetails.FolderName,
RecipientEmail = _event.AdditionalDetails.RecipientEmail,
RecipientGroupID = _event.AdditionalDetails.RecipientGroupID,
FormatType = _event.AdditionalDetails.FormatType,
UserIDImpacted = _event.AdditionalDetails.UserIDImpacted,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source
};
superEventDetail.ReportDetails.Add(reportDetail);
break;
case "ATTACHMENT":
var attachmentDetail = new AttachmentDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
SheetID = _event.AdditionalDetails.SheetID,
WorkSpaceID = _event.AdditionalDetails.WorkSpaceID,
AttachmentName = _event.AdditionalDetails.AttachmentName,
MultifileDownloadname = _event.AdditionalDetails.MultifileDownloadName,
RecipientEmail = _event.AdditionalDetails.RecipientEmail,
RecipientGroupID = _event.AdditionalDetails.RecipientGroupID,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.AttachmentDetails.Add(attachmentDetail);
break;
case "USER":
var userDetail = new UserDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
UserTypes = _event.AdditionalDetails.UserTypes,
EmailAddress = _event.AdditionalDetails.EmailAddress,
DeclineReason = _event.AdditionalDetails.DeclineReason,
OldownerUserID = _event.AdditionalDetails.OldOwnerUserID,
NewownerUserID = _event.AdditionalDetails.NewOwnerUserID,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.UserDetails.Add(userDetail);
break;
case "DISCUSSION":
var discussionDetail = new DiscussionDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
SheetRowID = _event.AdditionalDetails.SheetRowID,
SheetID = _event.AdditionalDetails.SheetID,
WorkSpaceID = _event.AdditionalDetails.WorkSpaceID,
RecipientEmail = _event.AdditionalDetails.RecipientEmail,
RecipientGroupID = _event.AdditionalDetails.RecipientGroupID,
IncludeAttachments = _event.AdditionalDetails.IncludeAttachments,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.DiscussionDetails.Add(discussionDetail);
break;
case "DASHBOARD":
var dashboardDetail = new DashboardDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
DashboardName = _event.AdditionalDetails.DashboardName,
SourceGlobalTemplateID = _event.AdditionalDetails.SourceGlobalTemplateID,
SourceObjectID = _event.AdditionalDetails.SourceObjectID,
SourceType = _event.AdditionalDetails.SourceType,
AccessibleBy = _event.AdditionalDetails.AccessibleBy,
PublishType = _event.AdditionalDetails.PublishType,
PublishFormat = _event.AdditionalDetails.PublishFormat,
AccessLevel = _event.AdditionalDetails.AccessLevel,
UserID = _event.AdditionalDetails.UserID,
GroupID = _event.AdditionalDetails.GroupID,
WorkspaceID = _event.AdditionalDetails.WorkSpaceID,
OldUserID = _event.AdditionalDetails.OldUserID,
OldAccessLevel = _event.AdditionalDetails.OldAccessLevel,
NewUserID = _event.AdditionalDetails.NewUserID,
NewAccessLevel = _event.AdditionalDetails.NewAccessLevel,
NewparentContainerID = _event.AdditionalDetails.NewParentContainerID,
ParentContainerID = _event.AdditionalDetails.ParentContainerID,
FolderName = _event.AdditionalDetails.FolderName,
OldName = _event.AdditionalDetails.OldName,
NewName = _event.AdditionalDetails.NewName,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.DashboardDetails.Add(dashboardDetail);
break;
case "FOLDER":
var folderDetail = new FolderDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
FolderName = _event.AdditionalDetails.FolderName,
SourceFolderID = _event.AdditionalDetails.SourceFolderID,
OldName = _event.AdditionalDetails.OldName,
NewName = _event.AdditionalDetails.NewName,
SendCompletionEmail = _event.AdditionalDetails.SendCompletionEmail,
IncludeAttachments = _event.AdditionalDetails.IncludeAttachments,
FormatType = _event.AdditionalDetails.FormatType,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.FolderDetails.Add(folderDetail);
break;
case "FORM":
var formDetail = new FormDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
FormName = _event.AdditionalDetails.FolderName,
SheetID = _event.AdditionalDetails.SheetID,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.FormDetails.Add(formDetail);
break;
case "UPDATE REQUEST":
var updateRequestDetail = new UpdateRequestDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
SheetID = _event.AdditionalDetails.SheetID,
RowCounts = _event.AdditionalDetails.RowCount.ToString(),
IncludeAttachments = _event.AdditionalDetails.IncludeAttachments,
IncludeDiscussions = _event.AdditionalDetails.IncludeDiscussions,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.UpdateRequestDetails.Add(updateRequestDetail);
break;
case "WORKSPACE":
var workspaceDetail = new WorkSpaceDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
OldName = _event.AdditionalDetails.OldName,
NewName = _event.AdditionalDetails.NewName,
AccessLevel = _event.AdditionalDetails.AccessLevel,
UserID = _event.AdditionalDetails.UserID,
GroupID = _event.AdditionalDetails.GroupID,
IncludeAttachments = _event.AdditionalDetails.IncludeAttachments,
SendCompletionEmail = _event.AdditionalDetails.SendCompletionEmail,
FormatType = _event.AdditionalDetails.FormatType,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.WorkSpaceDetails.Add(workspaceDetail);
break;
case "ACCESSTOKEN":
var accessTokenDetails = new AccessTokenDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
TokenName = _event.AdditionalDetails.TokenName,
TokenDisplayValue = _event.AdditionalDetails.TokenDisplayValue,
TokenExpirationTimestamp = _event.AdditionalDetails.TokenExpirationTimestamp,
AccessScopes = _event.AdditionalDetails.AccessScopes,
AppClientID = _event.AdditionalDetails.AppClientID,
AppName = _event.AdditionalDetails.AppName,
TokenUserID = _event.AdditionalDetails.TokenUserID,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.AccessTokenDetails.Add(accessTokenDetails);
break;
case "ACCOUNT":
var accountDetails = new AccountDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
NewContactUserID = _event.AdditionalDetails.NewContactUserID,
OldContactUserID = _event.AdditionalDetails.OldContactUserID,
NewName = _event.AdditionalDetails.NewName,
OldName = _event.AdditionalDetails.OldName,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.AccountDetails.Add(accountDetails);
break;
case "GROUP":
var groupDetails = new GroupDetails()
{
EventID = _event.EventID,
ObjectID = _event.ObjectID,
Action = _event.Action,
GroupName = _event.AdditionalDetails.GroupName,
OldName = _event.AdditionalDetails.OldName,
NewName = _event.AdditionalDetails.NewName,
OldownerUserID = _event.AdditionalDetails.OldOwnerUserID,
NewownerUserID = _event.AdditionalDetails.NewOwnerUserID,
MemberUserID = _event.AdditionalDetails.MemberUserID,
UserIDInitiator = _event.UserID,
EventTimestamp = _event.EventTimestamp,
RequestUserID = _event.RequestUserID,
Source = _event.Source,
};
superEventDetail.GroupDetails.Add(groupDetails);
break;
}
}
return(superEventDetail);
}
public int Insert(FormDetails fd)
{
string phoneNumber1 = fd.phoneNumber;
string tickerNumber1 = fd.ticketNumber;
string comments1 = fd.comments;
string clothingType1 = fd.clothingType;
string fontType1 = fd.fontType;
string sizeType1 = fd.sizeType;
string clothingColor1 = fd.clothesColorType;
string printColor1 = fd.printColorType;
string laceColor1 = fd.laceColorType;
string completeTask = "Not Completed";
string frontJersey1 = fd.frontJersey;
string leftSleeveJersey1 = fd.leftSleeveJersey;
string rightSleeveJersey1 = fd.rightSleeveJersey;
string topBackJersey1 = fd.topBackJersey;
string bottomBackJersey1 = fd.bottomBackJersey;
//This is my connection string i have assigned the database file address path
//clothing type section-----------------------------------------------------------------------------------------------
if (fd.clothingType == "TS")
{
clothingType1 = "T-SHIRT";
fd.finalCost += 20;
}
else if (fd.clothingType == "H")
{
clothingType1 = "HOODIE";
fd.finalCost += 35;
}
else if (fd.clothingType == "ZH")
{
clothingType1 = "ZIP HOODIE";
fd.finalCost += 35;
}
else if (fd.clothingType == "C")
{
clothingType1 = "CAPS";
fd.finalCost += 25;
}
else if (fd.clothingType == "P")
{
clothingType1 = "PILLOWCASE";
fd.finalCost += 25;
}
else if (fd.clothingType == "PT")
{
clothingType1 = "PERFORMANCE TEE";
fd.finalCost += 30;
}
else if (fd.clothingType == "B")
{
clothingType1 = "BANDANA";
fd.finalCost += 25;
}
else if (fd.clothingType == "PO")
{
clothingType1 = "PRINT ONLY";
fd.finalCost += 0;
}
//size section-----------------------------------------------------------------------------------------------
if (fd.sizeCode == "S")
{
sizeType1 = "Small";
}
else if (fd.sizeCode == "M")
{
sizeType1 = "Medium";
}
else if (fd.sizeCode == "L")
{
sizeType1 = "Large";
}
else if (fd.sizeCode == "XL")
{
sizeType1 = "Extra Large";
}
else if (fd.sizeCode == "2XL")
{
sizeType1 = "2XL";
}
else if (fd.sizeCode == "3XL")
{
sizeType1 = "3XL";
}
//clothing color section-----------------------------------------------------------------------------------------------
if (fd.clothesColorCode == "01")
{
clothingColor1 = "White";
}
else if (fd.clothesColorCode == "02")
{
clothingColor1 = "Navy";
}
else if (fd.clothesColorCode == "03")
{
clothingColor1 = "Yellow";
}
else if (fd.clothesColorCode == "04")
{
clothingColor1 = "Black";
}
else if (fd.clothesColorCode == "05")
{
clothingColor1 = "Kelly";
}
else if (fd.clothesColorCode == "06")
{
clothingColor1 = "Red Heather";
}
else if (fd.clothesColorCode == "07")
{
clothingColor1 = "Military Green";
}
else if (fd.clothesColorCode == "08")
{
clothingColor1 = "Kelly Heather";
}
else if (fd.clothesColorCode == "09")
{
clothingColor1 = "Purple";
}
else if (fd.clothesColorCode == "10")
{
clothingColor1 = "Lime";
}
else if (fd.clothesColorCode == "11")
{
clothingColor1 = "Celadon";
}
else if (fd.clothesColorCode == "12")
{
clothingColor1 = "Orange";
}
else if (fd.clothesColorCode == "13")
{
clothingColor1 = "Royal";
}
else if (fd.clothesColorCode == "14")
{
clothingColor1 = "Coral";
}
else if (fd.clothesColorCode == "15")
{
clothingColor1 = "Pacific Blue";
}
else if (fd.clothesColorCode == "16")
{
clothingColor1 = "Red";
}
//print color section-----------------------------------------------------------------------------------------------
if (fd.printColorCode == "01")
{
printColor1 = "White";
}
else if (fd.printColorCode == "02")
{
printColor1 = "Black";
}
else if (fd.printColorCode == "03")
{
printColor1 = "Royal Blue";
}
else if (fd.printColorCode == "04")
{
printColor1 = "Orange";
}
else if (fd.printColorCode == "05")
{
printColor1 = "Red";
}
else if (fd.printColorCode == "06")
{
printColor1 = "Green";
}
else if (fd.printColorCode == "07")
{
printColor1 = "Gold";
}
else if (fd.printColorCode == "08")
{
printColor1 = "Cyan";
}
//lace color section-----------------------------------------------------------------------------------------------
if (fd.laceColorCode == "01")
{
laceColor1 = "Red";
fd.finalCost += 5;
}
else if (fd.laceColorCode == "02")
{
laceColor1 = "Pink";
fd.finalCost += 5;
}
else if (fd.laceColorCode == "03")
{
laceColor1 = "Yellow";
fd.finalCost += 5;
}
else if (fd.laceColorCode == "04")
{
laceColor1 = "Blue";
fd.finalCost += 5;
}
else if (fd.laceColorCode == "05")
{
laceColor1 = "Orange";
fd.finalCost += 5;
}
else if (fd.laceColorCode == "06")
{
laceColor1 = "Green";
fd.finalCost += 5;
}
else if (fd.laceColorCode == "07")
{
laceColor1 = "Purple";
fd.finalCost += 5;
}
//font type section-----------------------------------------------------------------------------------------------
if (fd.fontType == "JM")
{
fontType1 = "JERSEY M54";
}
else if (fd.fontType == "N")
{
fontType1 = "NOTEWORTHY";
}
else if (fd.fontType == "BN")
{
fontType1 = "BEBAS NEUE";
}
else if (fd.fontType == "D")
{
fontType1 = "DEATHWISH";
}
else if (fd.fontType == "H")
{
fontType1 = "HELVETICA";
}
//print locations section-----------------------------------------------------------------------------------------------
if (fd.frontJersey != null)
{
fd.finalCost += 10;
}
if (fd.leftSleeveJersey != null)
{
fd.finalCost += 5;
}
if (fd.rightSleeveJersey != null)
{
fd.finalCost += 5;
}
if (fd.bottomBackJersey != null)
{
fd.finalCost += 10;
}
if (fd.topBackJersey != null)
{
fd.finalCost += 10;
}
//cost logic section-----------------------------------------------------------------------------------------------
if (fd.frontJersey != null || fd.bottomBackJersey != null || fd.topBackJersey != null)
{
fd.finalCost -= 10;
}
else if (fd.leftSleeveJersey != null || fd.rightSleeveJersey != null)
{
fd.finalCost -= 5;
}
fd.estimatedCost = fd.finalCost;
if (fd.confirmationButton)
{
//sending all the information needed to the database
string sql = "server=localhost;user id=root;password=1234;database=kusteez";
MySqlConnection conn = new MySqlConnection(sql);
MySqlCommand cmd = conn.CreateCommand();
cmd.Parameters.AddWithValue("@clothingType1", clothingType1);
cmd.Parameters.AddWithValue("@sizeType1", sizeType1);
cmd.Parameters.AddWithValue("@clothingColor1", clothingColor1);
cmd.Parameters.AddWithValue("@printColor1", printColor1);
cmd.Parameters.AddWithValue("@laceColor1", laceColor1);
cmd.Parameters.AddWithValue("@fontType1", fontType1);
cmd.Parameters.AddWithValue("@completeTask", completeTask);
cmd.Parameters.AddWithValue("@finalCost", fd.finalCost);
cmd.Parameters.AddWithValue("@frontJersey1", frontJersey1);
cmd.Parameters.AddWithValue("@leftSleeveJersey1", leftSleeveJersey1);
cmd.Parameters.AddWithValue("@rightSleeveJersey1", rightSleeveJersey1);
cmd.Parameters.AddWithValue("@topBackJersey1", topBackJersey1);
cmd.Parameters.AddWithValue("@bottomBackJersey1", bottomBackJersey1);
cmd.Parameters.AddWithValue("@comments1", comments1);
cmd.Parameters.AddWithValue("@phoneNumber1", phoneNumber1);
cmd.Parameters.AddWithValue("@ticketNumber1", tickerNumber1);
cmd.CommandText = "insert into kusteezform (clothing, size, color, printColor, laceColor, font, status, finalCost, frontJersey, leftSleeveJersey, rightSleeveJersey, topBackJersey, bottomBackJersey, comment, phoneNumber, ticketNumber ) " +
"values (@clothingType1, @sizeType1, @clothingColor1, @printColor1, @laceColor1, @fontType1, @completeTask, @finalCost, @frontJersey1, @leftSleeveJersey1, @rightSleeveJersey1, @topBackJersey1, @bottomBackJersey1, @comments1, @phoneNumber1, @ticketNumber1)";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
return(0);
}
public FormSubmitDetails UpdateFormDetails(string Instance, string SessionId, string Version, FormDetails FormDetails)
{
FormSubmitDetails formSubmitDetails = new FormSubmitDetails();
SICTLogger.WriteInfo(DepartureFormServices.CLASS_NAME, "UpdateFormDetails", "Start");
try
{
UserDetailsBusiness userDetailsBusiness = new FactoryBusiness().GetUserDetailsBusiness(BusinessConstants.VERSION_BASE);
if (userDetailsBusiness.IsSessionIdValid(SessionId, false))
{
DepartureFormBusiness departureFormBusiness = new FactoryBusiness().GetDepartureFormBusiness(Version);
formSubmitDetails = departureFormBusiness.UpdateFormDetails(Instance, FormDetails, SessionId);
}
else
{
formSubmitDetails.ReturnCode = 0;
formSubmitDetails.ReturnMessage = "Invalid session";
SICTLogger.WriteWarning(DepartureFormServices.CLASS_NAME, "UpdateFormDetails", "Invalid session ");
}
}
catch (Exception ex)
{
formSubmitDetails.ReturnCode = -1;
formSubmitDetails.ReturnMessage = "Error in API Execution";
SICTLogger.WriteException(DepartureFormServices.CLASS_NAME, "UpdateFormDetails", ex);
}
SICTLogger.WriteInfo(DepartureFormServices.CLASS_NAME, "UpdateFormDetails", "End");
return(formSubmitDetails);
}
