public async Task <CalendarBussines> GetAsync(string _connectionString, Guid guid) { var list = new CalendarBussines(); try { using (var cn = new SqlConnection(_connectionString)) { var cmd = new SqlCommand("sp_Calendar_Get", cn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", guid); await cn.OpenAsync(); var dr = await cmd.ExecuteReaderAsync(); if (dr.Read()) { list = LoadData(dr); } dr.Close(); cn.Close(); } } catch (Exception exception) { WebErrorLog.ErrorInstence.StartErrorLog(exception); } return(list); }
private async void btnFinish_Click(object sender, EventArgs e) { var res = new ReturnedSaveFuncInfo(); try { btnFinish.Enabled = false; res.AddReturnedValue(await Utilities.PingHostAsync()); if (res.HasError) { return; } res.AddReturnedValue(await CalendarBussines.SaveFromServerAsync()); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } finally { btnFinish.Enabled = true; if (res.HasError) { this.ShowError(res, "خطا در دریافت اطلاعات از سرور"); } else { _ = Task.Run(() => LoadDataAsync()); } } }
public async Task <ReturnedSaveFuncInfo> SaveAsync(CalendarBussines item, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_Calendar_Save", tr.Connection, tr) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", item.Guid); cmd.Parameters.AddWithValue("@modif", item.Modified); cmd.Parameters.AddWithValue("@dateM", item.DateM); cmd.Parameters.AddWithValue("@monasebat", item.Monasebat ?? ""); cmd.Parameters.AddWithValue("@desc", item.Description ?? ""); cmd.Parameters.AddWithValue("@isTatil", item.isTatil); await cmd.ExecuteNonQueryAsync(); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }
private async Task LoadDataAsync(string search = "") { try { _token?.Cancel(); _token = new CancellationTokenSource(); var list = await CalendarBussines.GetAllAsync(search, (int)txtYear.Value, _token.Token); Invoke(new MethodInvoker(() => CalendarBindingSource.DataSource = list.OrderBy(q => q.DateM).ToSortableBindingList())); SetGridColor(); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
private CalendarBussines LoadData(SqlDataReader dr) { var item = new CalendarBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.DateM = (DateTime)dr["DateM"]; item.Monasebat = dr["Monasebat"].ToString(); item.Description = dr["Description"].ToString(); item.isTatil = (bool)dr["isTatil"]; } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }