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