private void btnExcel_Click(object sender, EventArgs e)
{
if (MyDs.Tables.Count > 0)
{
if (MyDs.Tables[0].Rows.Count > 0)
{
PleaseWait frmPW = new PleaseWait();
frmPW.Show();
Application.DoEvents();
FastExportingMethod.ExportToExcel(MyDs);//, sfd.FileName);
frmPW.Close();
}
}
}
private void miExportTable_Click(object sender, System.EventArgs e)
{
if (MyDs.Tables.Count > 0)
{
if (MyDs.Tables[0].Rows.Count > 0)
{
PleaseWait frmPW = new PleaseWait();
frmPW.Show();
Application.DoEvents();
FastExportingMethod.ExportToExcel(MyDs);
frmPW.Close();
}
}
}
private void ExportSelected()
{
DataSet SelectedDataSet = new DataSet();
DataTable dt = new DataTable();
String SQL = @"SELECT ProductGroup, Description, SerialNumber as [Serial Number], DMMPropertyNum as [DMM Property Number],
Status, AssignedToDep as [Assigned To Department], AssignedTo as [Assigned To], Quantity, IPAddress as [IP Address], '' as [Date of change], UserName as [Changed by], Serviser as [Supplier/Servicer], AssignementNumber as [Assignement Form], RelatedBDA as [Related BDA], Notes FROM Items i LEFT OUTER JOIN Assignement as a on a.AssignementId = i.AssignementID WHERE 1=2";
dt = Vasko.ReturnDataTable(SQL);
SelectedDataSet.Tables.Add(dt);
foreach (DataGridViewRow dr in outlookGrid1.Rows)
{
if (dr.Selected)
{
DataRow drNew = SelectedDataSet.Tables[0].NewRow();
drNew[0] = dr.Cells[1].Value;
drNew[1] = dr.Cells[2].Value;
drNew[2] = dr.Cells[3].Value;
drNew[3] = dr.Cells[4].Value;
drNew[4] = dr.Cells[5].Value;
drNew[5] = dr.Cells[6].Value;
drNew[6] = dr.Cells[7].Value;
drNew[7] = dr.Cells[8].Value;
drNew[8] = dr.Cells[9].Value;
drNew[9] = dr.Cells[10].Value.ToString();
drNew[10] = dr.Cells[11].Value;
drNew[11] = dr.Cells[12].Value;
drNew[12] = dr.Cells[13].Value;
drNew[13] = dr.Cells[15].Value;
drNew[14] = dr.Cells[16].Value;
//drNew[15] = dr.Cells[15].Value;
SelectedDataSet.Tables[0].Rows.Add(drNew);
}
}
if (SelectedDataSet.Tables[0].Rows.Count > 0)
{
PleaseWait frmPW = new PleaseWait();
frmPW.Show();
Application.DoEvents();
FastExportingMethod.ExportToExcel(SelectedDataSet);//, sfd.FileName);
frmPW.Close();
}
}
public void SendReportExecutionRequest(ReportDefinition selectedReport, string path, UnitOfWork uow)
{
var reportServiceDestination = "";// ConfigurationStatic.GetParameterValue("ReportingServerAddress", uow);
if (string.IsNullOrEmpty(reportServiceDestination))
{
throw new InvalidOperationException("Reporting Sevrer Address Not Found");
}
var def = new DataExportRequest()
{
ReportDefinitionID = selectedReport.ID, Parameters = new List <QueryParameterHelper>()
};
foreach (var parameter in selectedReport.QueryParametersCollection)
{
def.Parameters.Add(new QueryParameterHelper()
{
ParameterName = parameter.ParameterName, ParameterValue = parameter.ParameterValue.ToString()
});
}
var xml = FastExportingMethod.Serialize(def);
var xmlBytes = Encoding.UTF8.GetBytes(xml);
var base64Xml = Convert.ToBase64String(xmlBytes);
var encodedBase64Xml = WebUtility.UrlEncode(base64Xml);
var request = WebRequest.Create($"http://{reportServiceDestination}/?data={encodedBase64Xml}");
request.Timeout = 600000;
var response = request.GetResponse();
using (var file = response.GetResponseStream())
using (var fileStream = new FileStream(path, FileMode.Create))
file?.CopyTo(fileStream);
}
public static void ExportToExcel()
{
DataTable table = new DataTable();
TransactionWork transactionWork = null;
SqlParameter[] parameters = new SqlParameter[3];
SqlParameter parameter = new SqlParameter();
parameter.DbType = DbType.String;
parameter.Size = 100;
parameter.ParameterName = "@whereClasure";
parameter.Value = whereClasure;
parameters[0] = parameter;
parameter = new SqlParameter();
parameter.DbType = DbType.String;
parameter.ParameterName = "@Param";
parameter.Size = 100;
if (value == null)
{
parameter.Value = string.Empty;
}
else
{
parameter.Value = value;
}
parameter.IsNullable = true;
parameters[1] = parameter;
parameter = new SqlParameter();
parameter.DbType = DbType.String;
parameter.Size = 30;
parameter.ParameterName = "@ParamType";
parameter.Value = dbType;
parameter.IsNullable = true;
parameters[2] = parameter;
try
{
using (transactionWork = (TransactionWork)TransactionFactory.Create())
{
transactionWork.Execute(table, "uspDynamicQuery", parameters);
transactionWork.Commit();
}
}
catch (Exception)
{
transactionWork?.Rollback();
throw;
}
FastExportingMethod.ExportToExcel(table,
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "List"));
FastExportingMethod.GemExportToExcel(table,
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "List2.xls"));
table.Dispose();
table = null;
GC.Collect();
GC.WaitForPendingFinalizers();
}
public string GenerateEmailFromSchedule(DoSoReportSchedule schedule, UnitOfWork unitOfWork)
{
string exception = string.Empty;
var objects = SenderHelper.GetMyObjects(schedule.ObjectsCriteria, unitOfWork, schedule.BusinessObjectFullName, true, 500);
foreach (var item in objects)
{
try
{
var classInfo = unitOfWork.GetClassInfo(item);
var properties = unitOfWork.GetProperties(classInfo);
var mailTo = new ExpressionEvaluator(properties, schedule.MessageTo).Evaluate(item).With(x => x.ToString());
if (string.IsNullOrEmpty(mailTo))
{
continue;
}
var subject = new ExpressionEvaluator(properties, schedule.MessageSubject).Evaluate(item).ToString();
var body = new ExpressionEvaluator(properties, schedule.MessageBody).Evaluate(item).ToString();
var key = classInfo.KeyProperty.GetValue(item).ToString();
var sameMailFromDb = unitOfWork.Query <DoSoEmail>().Where(x =>
x.ExpiredOn == null &&
x.EmailTo == mailTo &&
x.ObjectKey == key &&
x.ObjectTypeName == item.GetType().FullName&&
x.ReportSchedule == schedule);
var oldNotSentMail = sameMailFromDb.Where(x => !x.IsSent && !x.IsCanceled && x.SendingDate < DateTime.Now);
foreach (var oldMail in oldNotSentMail)
{
oldMail.IsCanceled = true;
oldMail.StatusComment = "Created New Email";
}
//var alredySentMails = sameMailFromDb.FirstOrDefault(x =>
// x.IsSent &&
// !x.IsCanceled &&
// x.SentDate.AddDays(schedule.SkipExecutionDate) > DateTime.Now);
var email = new DoSoEmail(unitOfWork)
{
EmailTo = mailTo,
EmailSubject = subject,
EmailBody = body,
SendingDate = DateTime.Now,
ObjectKey = key,
ObjectTypeName = item.GetType().FullName,
//SourceFilePath = path + fullName,
ReportSchedule = schedule
};
if (schedule.ReportDefinition != null)
{
var path = System.IO.Path.GetTempPath();
var name = DateTime.Now.ToString("MMMddHHmmssfff");
var fullName = name + ".xlsx";
SetParameteValues(schedule, item, unitOfWork);
var exported = FastExportingMethod.ExportData2Excel(schedule.ReportDefinition, unitOfWork.Connection as SqlConnection, path, name);
if (exported)
{
email.SourceFilePath = path + fullName;
}
else
{
email.EmailBody += string.Format("{0}{0}{1}", Environment.NewLine, schedule.AlternativeText);
}
}
schedule.GetNextExecutionDate();
unitOfWork.CommitChanges();
}
catch (Exception ex)
{
exception += ex + Environment.NewLine;
continue;
}
}
return(exception);
}
