public FormDocument GetByID(int _formDocumentID) { FormDocumentDAC _formDocumentComponent = new FormDocumentDAC(); IDataReader reader = _formDocumentComponent.GetByIDFormDocument(_formDocumentID); FormDocument _formDocument = null; while(reader.Read()) { _formDocument = new FormDocument(); if(reader["FormDocumentID"] != DBNull.Value) _formDocument.FormDocumentID = Convert.ToInt32(reader["FormDocumentID"]); if(reader["FormDocumentStatusID"] != DBNull.Value) _formDocument.FormDocumentStatusID = Convert.ToInt32(reader["FormDocumentStatusID"]); if(reader["Title"] != DBNull.Value) _formDocument.Title = Convert.ToString(reader["Title"]); if(reader["Description"] != DBNull.Value) _formDocument.Description = Convert.ToString(reader["Description"]); if(reader["StartDate"] != DBNull.Value) _formDocument.StartDate = Convert.ToDateTime(reader["StartDate"]); if(reader["EndDate"] != DBNull.Value) _formDocument.EndDate = Convert.ToDateTime(reader["EndDate"]); if(reader["ConfirmationText"] != DBNull.Value) _formDocument.ConfirmationText = Convert.ToString(reader["ConfirmationText"]); if(reader["CreatorID"] != DBNull.Value) _formDocument.CreatorID = Convert.ToInt32(reader["CreatorID"]); if(reader["CreationDate"] != DBNull.Value) _formDocument.CreationDate = Convert.ToDateTime(reader["CreationDate"]); if(reader["SendEmail"] != DBNull.Value) _formDocument.SendEmail = Convert.ToBoolean(reader["SendEmail"]); if(reader["SendSMS"] != DBNull.Value) _formDocument.SendSMS = Convert.ToBoolean(reader["SendSMS"]); if(reader["AllowModify"] != DBNull.Value) _formDocument.AllowModify = Convert.ToBoolean(reader["AllowModify"]); _formDocument.NewRecord = false; } reader.Close(); return _formDocument; }
public bool Update(FormDocument formdocument ,int old_formDocumentID) { FormDocumentDAC formdocumentComponent = new FormDocumentDAC(); return formdocumentComponent.UpdateFormDocument( formdocument.FormDocumentStatusID, formdocument.Title, formdocument.Description, formdocument.StartDate, formdocument.EndDate, formdocument.ConfirmationText, formdocument.CreatorID, formdocument.CreationDate, formdocument.SendEmail, formdocument.SendSMS, formdocument.AllowModify, old_formDocumentID); }
public static DataTable ExportToDataTable(FormDocument document) { if (document == null) return null; DataTable result = new DataTable(); foreach (FormField q in document.FormFields) { if (q.FormFieldTypeId == 6) { List<FormFieldValue> FormFieldvalues = new BusinessLogicLayer.Components.FormBuilder.FormFieldValueLogic().GetAllByFormFieldId(q.FormFieldId); foreach (FormFieldValue v in FormFieldvalues) { DataColumn col = new DataColumn(v.FieldValue); col.ExtendedProperties.Add("TypeID", q.FormFieldTypeId); col.Caption = String.Format("{0},{1}", q.FormFieldId, v.FormFieldValueId); result.Columns.Add(col); } } else { DataColumn col = new DataColumn(q.Title); col.ExtendedProperties.Add("TypeID", q.FormFieldTypeId); col.Caption = q.FormFieldId.ToString(); result.Columns.Add(col); } } DataColumn colIsAnonymous = new DataColumn("IsAnonymous_System"); colIsAnonymous.Caption = "IsAnonymous_System"; DataColumn colFirstName = new DataColumn("UserDisplayName_System"); colFirstName.Caption = "UserDisplayName_System"; DataColumn colUserName = new DataColumn("UserName_System"); colUserName.Caption = "UserName_System"; result.Columns.Add(colIsAnonymous); //result.Columns.Add(colFirstName); result.Columns.Add(colUserName); List<FormSubmissionAnswer> answers = new BusinessLogicLayer.Components.FormBuilder.FormSubmissionAnswerLogic().ViewSubmissionAnswers(document.FormDocumentID); var submissions = (from x in answers select x.FormSubmissionId).Distinct(); foreach (int submission in submissions) { DataRow row = result.NewRow(); var userSubmission = (from x in answers where x.FormSubmissionId == submission select x).FirstOrDefault(); foreach (DataColumn col in result.Columns) { switch (col.Caption) { case "IsAnonymous_System": row[col.ColumnName] = userSubmission.FormSubmission.IsAnonymous; break; case "UserName_System": row[col.ColumnName] = userSubmission.FormSubmission.User.Username; break; //case "UserDisplayName_System": // row[col.ColumnName] = userSubmission.UserDisplayName; // break; default: if (col.Caption.Contains(",")) { string[] splitResults = col.Caption.Split(','); var answerResult = from x in answers where x.FormSubmissionId == submission && x.FormFieldId == Convert.ToInt32(splitResults[0]) && x.FormFieldValueId == Convert.ToInt32(splitResults[1]) select x; string resultText = ""; int count = 1; foreach (FormSubmissionAnswer a in answerResult) { if (count > 1) resultText += ","; resultText += a.Answer; } row[col.ColumnName.ToString()] = resultText; } else { var answerResult = from x in answers where x.FormSubmissionId == submission && x.FormFieldId == Convert.ToInt32(col.Caption) select x; string resultText = ""; int count = 1; foreach (FormSubmissionAnswer a in answerResult) { if (count > 1) resultText += ","; resultText += a.Answer; } row[col.ColumnName.ToString()] = resultText; } break; } } result.Rows.Add(row); } foreach (FormField q in document.FormFields) { if (q.FormFieldTypeId == 6) { List<FormFieldValue> FormFieldvalues = new BusinessLogicLayer.Components.FormBuilder.FormFieldValueLogic().GetAllByFormFieldId(q.FormFieldId); foreach (FormFieldValue v in FormFieldvalues) { string cap = v.FieldValue; result.Columns[cap].Caption = v.FieldValue; //DataColumn col = new DataColumn(v.FieldValue); //col.ExtendedProperties.Add("TypeID", q.FormFieldTypeId); //col.Caption = String.Format("{0},{1}", q.FormFieldId, v.FormFieldValueId); //result.Columns.Add(col); } } else { string cap = q.Title; result.Columns[cap].Caption = q.Title; //DataColumn col = new DataColumn(q.Title); //col.ExtendedProperties.Add("TypeID", q.FormFieldTypeId); //col.Caption = //result.Columns.Add(col); } } return result; }
public bool Insert(FormDocument formdocument) { int autonumber = 0; FormDocumentDAC formdocumentComponent = new FormDocumentDAC(); bool endedSuccessfuly = formdocumentComponent.InsertNewFormDocument( ref autonumber, formdocument.FormDocumentStatusID, formdocument.Title, formdocument.Description, formdocument.StartDate, formdocument.EndDate, formdocument.ConfirmationText, formdocument.CreatorID, formdocument.CreationDate, formdocument.SendEmail, formdocument.SendSMS, formdocument.AllowModify); if(endedSuccessfuly) { formdocument.FormDocumentID = autonumber; } return endedSuccessfuly; }
public static void ExportToExcel(System.Web.UI.Page page,FormDocument document,string fileName) { DataTable dt = ExportToDataTable(document); page.Response.Clear(); page.Response.AddHeader("content-disposition", String.Format("attachment;filename={0}", fileName)); page.Response.ContentType = "application/vnd.ms-excel"; StringWriter stringWriter = new StringWriter(); HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWriter); DataGrid dataExportExcel = new DataGrid(); dataExportExcel.DataSource = dt; dataExportExcel.DataBind(); dataExportExcel.RenderControl(htmlWrite); StringBuilder sbResponseString = new StringBuilder(); sbResponseString.Append(String.Format("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=unicode-1200\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>FormBuilder</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>")); sbResponseString.Append(stringWriter + "</body></html>"); page.Response.Write(sbResponseString.ToString()); page.Response.End(); }