private void Get_Stats(object parameter)
{
string a =
"SELECT null as status, count(*) as count, TIME_TO_SEC(lead_time) as time FROM request WHERE Managers_id = '" +
parameter +
"' AND pid = 0 UNION ALL SELECT Status,count(Status), TIME_TO_SEC(lead_time) as time FROM request WHERE Managers_id = '" +
parameter + "' and pid = 0 and Status is not null group by Status";
DTS = clsDB.Get_DataTable(a);
if (DTS.Rows.Count > 1)
{
StatsCollection = new ObservableCollection <Stats>
{
new Stats
{
z_All = Convert.ToInt32(DTS.Rows[0][1]),
z_Closed = Convert.ToInt32(DTS.AsEnumerable()
.SingleOrDefault(r => r.Field <string>("status") == "Завершена")["count"]),
z_Time_Sp = Convert.ToInt32(DTS.AsEnumerable()
.SingleOrDefault(w => w.Field <string>("status") == "Завершена")["time"]) / 60,
}
};
}
else
{
MessageBox.Show("StatsViewModel");
}
}
/// <summary>
/// دکمه بروزرسانی اطلاعات از مرکز
/// که تمامی اطلاعات اولیه را از مرکز دانلود و در دیتابیس اسکیوالایت کنترلر ذخیره میکند
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void menuBtnDownload_Click(object sender, RoutedEventArgs e)
{
try
{
var dialog = new MessageDialog("اطلاعات بروزرسانی می شود ، آیا اطمینان دارید؟");
dialog.Title = "توجه";
dialog.Commands.Add(new UICommand {
Label = "بله", Id = 0
});
dialog.Commands.Add(new UICommand {
Label = "خیر", Id = 1
});
var res = await dialog.ShowAsync();
if ((int)res.Id == 0)
{
if (!string.IsNullOrWhiteSpace(tbxSqlIP.Text.Trim()))
{
if (Extension.IsSqlServerAvailable(tbxSqlIP.Text.Trim()))
{
LoadingIndicator.IsActive = true;
await Window.Current.Dispatcher.RunAsync(Windows.UI.Core.CoreDispatcherPriority.Normal, async() =>
{
DTS.Init(tbxSqlIP.Text.Trim());
DTS.FullDownload();
});
//await Task.Run(() => DTS.FullDownload((string.IsNullOrWhiteSpace(tbxSqlIP.Text.Trim()) ? "" : tbxSqlIP.Text.Trim())));
}
else
{
var dialogg = new MessageDialog("اتصال به پایگاه داده مرکز برقرار نیست");
dialogg.Title = "خطا در اتصال به پایگاه داده";
await dialogg.ShowAsync();
}
}
else
{
var dialogg = new MessageDialog("آی پی آدرس سرور مرکز بایستی پر باشد");
dialogg.Title = "توجه";
await dialogg.ShowAsync();
}
}
}
catch (Exception ex)
{
//ErrorLog.SaveLog(ex);
var dialog = new MessageDialog(ex.Message + " * " + ((ex.InnerException != null) ? ex.InnerException.Message : ""));
dialog.Title = "خطای انتقال";
await dialog.ShowAsync();
}
finally
{
LoadingIndicator.IsActive = false;
BindCombo();
BindSetting();
}
}
public void AddDataRowSach(Sach s)
{
DataRow dr = DTS.NewRow();
dr["maSach"] = s.maSach;
dr["tenSach"] = s.tenSach;
dr["soLuong"] = s.soLuong;
dr["maTG"] = s.maTG;
dr["maNXB"] = s.maNXB;
DTS.Rows.Add(dr);
}
public void EditDataRowSach(Sach s)
{
foreach (DataRow i in DTS.Rows)
{
if (Convert.ToInt32(i["maSach"].ToString()) == s.maSach)
{
CSDL.Instance.DTS.Rows.Remove(i);
DataRow dr = DTS.NewRow();
dr["tenSach"] = s.tenSach;
dr["soLuong"] = s.soLuong;
dr["maTG"] = s.maTG;
dr["maNXB"] = s.maNXB;
DTS.Rows.Add(dr);
return;
}
}
}
//Method takes values from Student object and converts into XML format
public void ExportToXml(Student student, string filename, bool alsoread)
{
//Add student object to Dataset
DataTable DTS;
if (StudentDataSet == null)
{
StudentDataSet = new DataSet("Students");
DTS = new DataTable("Student");
DTS.Columns.Add("FirstName");
DTS.Columns.Add("Surname");
DTS.Columns.Add("Email");
DTS.Columns.Add("Phone");
DTS.Columns.Add("AddressLine1");
DTS.Columns.Add("AddressLine2");
DTS.Columns.Add("County");
DTS.Columns.Add("City");
DTS.Columns.Add("Graduatelevel");
DTS.Columns.Add("Course");
DTS.Columns.Add("StudentNumber");
StudentDataSet.Tables.Add(DTS);
}
DTS = StudentDataSet.Tables["Student"];
DataRow rowstu = DTS.NewRow();
rowstu["FirstName"] = student.FirstName;
rowstu["Surname"] = student.Surname;
rowstu["Email"] = student.Email;
rowstu["Phone"] = student.Phone;
rowstu["AddressLine1"] = student.AddressLine1;
rowstu["AddressLine2"] = student.AddressLine2;
rowstu["County"] = student.County;
rowstu["City"] = student.City;
rowstu["Graduatelevel"] = student.GraduateLevel;
rowstu["Course"] = student.Course;
rowstu["StudentNumber"] = student.StudentNumber;
DTS.Rows.Add(rowstu);
DTS.AcceptChanges();
//To export to XML
if (alsoread)
{
StudentDataSet.ReadXml(filename, XmlReadMode.InferSchema);
}
StudentDataSet.WriteXml($"{filename}");
}
/// <summary>
/// Creates the column transformation object.
/// </summary>
/// <param name="sourceColumn">The source column.</param>
/// <param name="destinationColumn">The destination column.</param>
/// <param name="customTask">The custom task.</param>
/// <param name="fieldOrdinal">The field ordinal.</param>
private void createColumnTransformation(DTSColumn sourceColumn, DTSColumn destinationColumn,
ref DTS.DataPumpTask2 customTask, int fieldOrdinal)
{
try
{
DTS.Transformation2 oTransformation = (DTS.Transformation2)
customTask.Transformations.New("DTS.DataPumpTransformCopy.1");
// create new source and destination DTS.columns
oTransformation.SourceColumns.Add(oTransformation.SourceColumns.New(sourceColumn.Name, fieldOrdinal));
oTransformation.DestinationColumns.Add(oTransformation.DestinationColumns.New(destinationColumn.Name, fieldOrdinal));
oTransformation = null;
}
catch(Exception ex)
{
throw ex;
}
}
/// <summary>
/// Sets the DTS package/object OLEDB properties from a serialized XML node.
/// </summary>
/// <param name="p">The DTS OLEDB properties.</param>
/// <param name="x">The XML node.</param>
private void SetOLEDBProperties(DTS.OleDBProperties p, XmlNode x)
{
if (p == null) return;
if (x == null) return;
foreach ( XmlElement xl in x )
{
foreach (DTS.OleDBProperty2 p1 in p)
{
if (p1.Name == xl.Name.Replace("_", " "))
{
// TODO: add reconversion of non-visible chars
if (xl.InnerText.Length > 0)
{
p1.Value = xl.InnerText.Replace("{cr}","\r").Replace("{lf}","\n");
}
break;
}
}
}
p = null;
}
/// <summary>
/// Sets the DTS package/object properties from a serialized XML node.
/// </summary>
/// <param name="p">The DTS properties.</param>
/// <param name="x">The XML node.</param>
private void SetDTSProperties(DTS.Properties p, XmlNode x)
{
if (p == null) return;
if (x == null) return;
foreach ( XmlElement xl in x )
{
foreach (DTS.Property p1 in p)
{
if (p1.Set && p1.Name == xl.Name)
{
if (xl.InnerText.Length > 0)
{
p1.Value = xl.InnerText.Replace("{cr}","\r").Replace("{lf}","\n");
}
break;
}
}
}
p = null;
}
/// <summary>
/// Workout the view to return...
/// </summary>
/// <param name="format"></param>
/// <param name="viewName"></param>
/// <param name="partialPath"></param>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult GetView(DTS.Web.MVC.ResponseFormatEnum format, string viewName, string partialPath, object model)
{
ActionResult result = null;
switch (format)
{
case ResponseFormatEnum.html:
result = this.View(viewName, model);
break;
case ResponseFormatEnum.json:
JsonResult r = this.Json(model);
r.ContentType = "text/json-comment-filtered";
result = r;
break;
case ResponseFormatEnum.partial:
result = this.View(partialPath, model);
break;
}
return result;
}
