public async Task <SerializedDataBussines> GetAsync(string _connectionString, string memberName)
{
var obj = new SerializedDataBussines();
try
{
using (var cn = new SqlConnection(_connectionString))
{
var cmd = new SqlCommand("sp_SerializedData_Get", cn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@memberName", memberName ?? "");
await cn.OpenAsync();
var dr = await cmd.ExecuteReaderAsync();
if (dr.Read())
{
obj = LoadData(dr);
}
cn.Close();
}
}
catch (Exception exception)
{
WebErrorLog.ErrorInstence.StartErrorLog(exception);
}
return(obj);
}
private async Task LoadCitiesAsync()
{
try
{
var list = await SerializedDataBussines.GetDivarCityAsync();
var dc = list?.Where(q =>
q.Name.Contains("مشهد") || q.Name.Contains("اصفهان") || q.Name.Contains("تهران") ||
q.Name.Contains("کرج") || q.Name.Contains("اهواز") || q.Name.Contains("شیراز") ||
q.Name.Contains("قم")).ToList();
cityBindingSource.DataSource = dc?.ToList();
if (cityBindingSource.Count > 0)
{
var cityLocal = await CitiesBussines.GetAsync(Guid.Parse(Settings.Classes.clsEconomyUnit.EconomyCity));
if (cityLocal != null)
{
cmbState.Text = cityLocal.Name;
}
}
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
private async void btnInsert_Click(object sender, EventArgs e)
{
try
{
if (DGrid.RowCount <= 0)
{
return;
}
if (DGrid.CurrentRow == null)
{
return;
}
var list = await SerializedDataBussines.GetDivarRegionAsync();
var guid = (Guid)DGrid[dgGuid.Index, DGrid.CurrentRow.Index].Value;
var reg = list.FirstOrDefault(q => q.Guid == guid);
if (reg == null)
{
return;
}
var frm = new frmMatchRegionMain(reg);
frm.ShowDialog(this);
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
private SerializedDataBussines LoadData(SqlDataReader dr)
{
var item = new SerializedDataBussines();
try
{
item.Guid = (Guid)dr["Guid"];
item.Name = dr["Name"].ToString();
item.Data = dr["Data"].ToString();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
return(item);
}
private async Task LoadDataAsync()
{
try
{
var list = await SerializedDataBussines.GetDivarRegionAsync();
if (cmbState.SelectedValue != null && (Guid)cmbState.SelectedValue != Guid.Empty)
{
list = list.Where(q => q.CityGuid == (Guid)cmbState.SelectedValue).ToList();
}
regBindingSource.DataSource = list.ToSortableBindingList();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
public async Task <ReturnedSaveFuncInfo> SaveAsync(SerializedDataBussines item, SqlTransaction tr)
{
var res = new ReturnedSaveFuncInfo();
try
{
var cmd = new SqlCommand("sp_SerializedData_Save", tr.Connection, tr)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@guid", item.Guid);
cmd.Parameters.AddWithValue("@name", item.Name ?? "");
cmd.Parameters.AddWithValue("@data", item.Data ?? "");
await cmd.ExecuteNonQueryAsync();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
res.AddReturnedValue(ex);
}
return(res);
}
private async void lblBaseInfo_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show(this,
"توجه داشته باشید... درصورتیکه از قبل داده ای را دریافت نموده باشید و مجددا نسبت به دریافت آن اقدام نمایدد، می بایست داده های موجود در صفحه تطبیق را هم اصلاح نمایید. آیا ادامه میدهید؟",
"هشدار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
var divar = DivarAdv.GetInstance();
var cityList = divar.GetAllCityFromDivar();
var serializedData = new SerializedDataBussines()
{
Guid = Guid.NewGuid(),
Name = "DivarCities",
Data = Json.ToStringJson(cityList)
};
await SerializedDataBussines.SaveAsync("DivarCities", serializedData.Data);
var cities = await SerializedDataBussines.GetDivarCityAsync();
var dc = cities.Where(q =>
q.Name.Contains("مشهد") || q.Name.Contains("اصفهان") || q.Name.Contains("تهران") ||
q.Name.Contains("کرج") || q.Name.Contains("اهواز") || q.Name.Contains("شیراز") ||
q.Name.Contains("قم")).ToList();
var regList = await divar.GetAllRegionFromDivar(dc);
Utility.CloseAllChromeWindows();
var serializedData_ = new SerializedDataBussines()
{
Guid = Guid.NewGuid(),
Name = "DivarRegions",
Data = Json.ToStringJson(regList)
};
await SerializedDataBussines.SaveAsync("DivarRegions", serializedData_.Data);
//var sheypoor = SheypoorAdv.GetInstance();
//var cityList = sheypoor.GetAllCityFromSheypoor();
//var serializedData = new SerializedDataBussines()
//{
// Guid = Guid.NewGuid(),
// Name = "SheypoorCities",
// Data = Json.ToStringJson(cityList)
//};
//await SerializedDataBussines.SaveAsync("SheypoorCities", serializedData.Data);
//var cities_ = await SerializedDataBussines.GetAsync("SheypoorCities");
//var dc_ = cities_.Data.FromJson<List<SheypoorCities>>();
//var regList_ = await sheypoor.GetAllRegionFromSheypoor(dc_);
//Utility.CloseAllChromeWindows();
//var serializedData_ = new SerializedDataBussines()
//{
// Guid = Guid.NewGuid(),
// Name = "DivarRegions",
// Data = Json.ToStringJson(regList_)
//};
//await SerializedDataBussines.SaveAsync("DivarRegions", serializedData_.Data);
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
}
