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; }