/// <summary>
/// Get subdivisioin iso id
/// </summary>
/// <param name="country_code">iso code</param>
/// <param name="sub_key">isoid code</param>
/// <returns></returns>
internal async static Task <string> GetSubDivisionIsoID(string country_code, string sub_key)
{
using (HttpClient client = new HttpClient())
{
SubDivision subDivision = null;
client.BaseAddress = new Uri(GDA.REST_URL);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
try
{
var path = System.IO.Path.Combine(GDA.REST_ROUTE, $"{country_code.ToUpper()}/{sub_key}");
HttpResponseMessage response = await client.GetAsync(path);
if (response.IsSuccessStatusCode)
{
var data = await response.Content.ReadAsStringAsync();
subDivision = Newtonsoft.Json.JsonConvert.DeserializeObject <SubDivision>(data);
}
}
catch (Exception)
{
Console.WriteLine($"{DateTime.Now} | {typeof(AddressData).Assembly.GetName()} : An error has occurred when try to fetch Google Address Data");
}
return(subDivision.IsoId);
}
}
public async Task <ActionResult <SubDivision> > Update(SubDivision subdivision) //изменить подразделение
{
#region Проверка входных данных
if (subdivision == null)
{
return(BadRequest("Ошибка чтения запроса"));
}
SubDivision s = await db.SubDivisions.FirstOrDefaultAsync(x => x.Id == subdivision.Id);
if (s == null)
{
return(BadRequest("Подразделение не найдено. Попробуйте изменить запрос"));
}
if (subdivision.Name != null && subdivision.Name != "")
{
s.Name = subdivision.Name;
}
if (subdivision.ParentId != s.ParentId)
{
s.ParentId = subdivision.ParentId;
}
if (subdivision.Employees != null)
{
s.Employees.AddRange(subdivision.Employees);
}
db.SubDivisions.Update(s);
db.SubDivisions.Include(e => e.Employees);
await db.SaveChangesAsync();
#endregion
return(Ok(s));
}
public async Task <IActionResult> SubDivisionCreate([Bind("Id,SubDivisionTitle,SubDivisionCode,DivisionId")]
SubDivision subDivision)
{
if (!ModelState.IsValid)
{
var divisionList = await _wpbService.GetDivisionDropListAsync();
ViewData["Division"] = new SelectList(divisionList, "Id", "DivisionName");
return(View(subDivision));
}
subDivision.SubDivisionCode = subDivision.SubDivisionCode.ToUpper();
var subDivCodeExist = _wpbService.SubdivisionCodeExist(subDivision.SubDivisionCode);
if (subDivCodeExist)
{
var divisionList = await _wpbService.GetDivisionDropListAsync();
ViewData["Division"] = new SelectList(divisionList, "Id", "DivisionName");
ModelState.AddModelError("", "$Subdivision code {subDivision.SubDivisionCode} is already in use.");
return(View(subDivision));
}
await _wpbService.CreateSubDivisionAsync(subDivision);
return(RedirectToAction(nameof(SubDivisionsAll)));
}
private void SetDefaultControls(SubDivision subDiv)
{
using (DBConteiner db = new DBConteiner())
{
try
{
SelectedSubDivivsion = db.SubDivisions.Where(e => e.SubDivisionId == subDiv.SubDivisionId).FirstOrDefault();
ParentSubDiv_comboBox.SelectedItem = SelectedSubDivivsion;
dateTimePicker1.Value = subDiv.CreateDate;
checkBox1.Checked = false;
dateTimePicker2.Value = subDiv.CollapsDate;
SubDivName_txtBox.Text = subDiv.SubDivName;
}
catch (ArgumentNullException ex)
{
MessageBox.Show(ex.Message);
}
catch (OverflowException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityCommandExecutionException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityException ex)
{
MessageBox.Show(ex.Message);
}
}
}
public IHttpActionResult PutSubDivision(int id, SubDivision subDivision)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != subDivision.Id)
{
return(BadRequest());
}
db.Entry(subDivision).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SubDivisionExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void GetSelectedSubDiv(int Id)
{
using (DBConteiner db = new DBConteiner())
{
try
{
SelectedSubDiv = db.SubDivisions.Where(item => item.SubDivisionId == Id).FirstOrDefault();
}
catch (ArgumentNullException ex)
{
MessageBox.Show(ex.Message);
}
catch (OverflowException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityCommandExecutionException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityException ex)
{
MessageBox.Show(ex.Message);
}
}
}
public override void OnActionExecuting(ActionExecutingContext context)
{
s = (SubDivision)context.ActionArguments["subdivision"];
if (s == null || s.Id < 0)
{
context.HttpContext.Response.StatusCode = 400;
}
}
private void CloseSubdivision()
{
if (dateTimePicker2.Value < NewdSubDivivsion.CreateDate || dateTimePicker2.Value > DateTime.Now)
{
MessageBox.Show("Не корректная дата закрытия");
return;
}
using (DBConteiner db = new DBConteiner())
{
try
{
SubDivName_txtBox.Enabled = false;
SubDivision CloseSubdiv = db.SubDivisions.Where(o => o.SubDivisionId == NewdSubDivivsion.SubDivisionId).FirstOrDefault();
if (CloseSubdiv != null)
{
db.Entry(CloseSubdiv).State = EntityState.Modified;
CloseSubdiv.CollapsDate = dateTimePicker2.Value;
CloseSubdiv.WorkStatus = false;
//here we change the status of parent subdivision in all of subdivision which have a parent subdivision
//that we close now. New status of these subdivision is "No patent sabdivision"
List <SubDivision> subDivisions = db.SubDivisions.Where(e => e.ParentIdent == NewdSubDivivsion.SubDivisionId).ToList();
if (subDivisions != null)
{
foreach (SubDivision sub in subDivisions)
{
db.Entry(sub).State = EntityState.Modified;
sub.ParentIdent = 1;
}
}
db.SaveChanges();
NewdSubDivivsion.WorkStatus = false;//for corret showing infomation by label4 (Work ort Don't work)
PreviosDataLoad();
SetDefaultControls();
MessageBox.Show("Подразделение закрыто");
}
}
catch (ArgumentNullException ex)
{
MessageBox.Show(ex.Message);
}
catch (OverflowException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityCommandExecutionException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityException ex)
{
MessageBox.Show(ex.Message);
}
}
}
public IHttpActionResult GetSubDivision(int id)
{
SubDivision subDivision = db.SubDivisions.Find(id);
if (subDivision == null)
{
return(NotFound());
}
return(Ok(subDivision));
}
public void Delete(int id)
{
using (var db = new ModelContext())
{
SubDivision subDivision = db.SubDivisions
.Where(m => m.Id == id)
.FirstOrDefault();
db.Entry(subDivision).State = System.Data.EntityState.Deleted;
db.SaveChanges();
}
}
public void Create(SubDivisionDTO subDivisionDTO)
{
using (var db = new ModelContext())
{
SubDivision subDivision = db.SubDivisions.Create();
subDivision.Name = subDivisionDTO.Name;
subDivision.DivisionId = subDivisionDTO.DivisionId;
db.SubDivisions.Add(subDivision);
db.SaveChanges();
}
}
private void EditSubdiv()
{
using (DBConteiner db = new DBConteiner())
{
try
{
Library lib = new Library();
if (!lib.NewSubDivValidstion(SelectedSubDivivsion))
{
return;
}
SubDivision tmp = db.SubDivisions.Where(o => o.SubDivisionId == NewdSubDivivsion.SubDivisionId).FirstOrDefault();
if (tmp != null)
{
db.Entry(tmp).State = EntityState.Modified;
tmp.SubDivName = SubDivName_txtBox.Text;
tmp.ParentIdent = SelectedSubDivivsion.SubDivisionId;
tmp.ParentSubdiv = db.SubDivisions.Where(e => e.SubDivisionId == SelectedSubDivivsion.SubDivisionId).FirstOrDefault();
tmp.CreateDate = dateTimePicker1.Value;
tmp.CollapsDate = dateTimePicker2.Value;
db.SaveChanges();
editSave = true;
NewdSubDivivsion = SelectedSubDivivsion;
PreviosDataLoad();
SetDefaultControls();
MessageBox.Show("Данные о подразделении изменены");
}
}
catch (ArgumentNullException ex)
{
MessageBox.Show(ex.Message);
}
catch (OverflowException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityCommandExecutionException ex)
{
MessageBox.Show(ex.Message);
}
catch (System.Data.Entity.Core.EntityException ex)
{
MessageBox.Show(ex.Message);
}
}
}
public SubDivForm()
{
InitializeComponent();
DivRecords = new ObservableCollection <SubDivision>();
NewdSubDivivsion = new SubDivision();
PreviosDataLoad();
label4.Text = "";
this.Text = "Режим создания нового подразделения";
checkBox1.CheckedChanged += checkBox1_CheckedChanged;
ParentSubDiv_comboBox.SelectedIndexChanged += ParentSubDiv_comboBox_SelectedIndexChanged;
}
public IHttpActionResult PostSubDivision(SubDivision subDivision)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.SubDivisions.Add(subDivision);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = subDivision.Id }, subDivision));
}
public override void OnActionExecuted(ActionExecutedContext context)
{
OkObjectResult res = (OkObjectResult)context.Result;
s = (SubDivision)res.Value;
if (s.ParentId < 0 || s.ParentId == s.Id)
{
s.ParentId = 0;
res.Value = s;
context.Result = res;
}
}
private async void SubDivisionSaveEntry(object sender, RoutedEventArgs e)
{
try
{
var subDivisionEntry = new SubDivision()
{
Name = SubDName.Text,
BuilderName = SubDBuilder.Text,
City = SubDCity.Text,
State = SubDState.Text,
StartDate = DateTime.Today.ToString("MM/dd/yyyy"),
Zip = Int32.Parse(SubDZip.Text),
BillableFrame = SubDBillable.IsOn,
CrossSt = SubDCrossSt.Text,
ClimateZone = Int32.Parse(SubDClimate.Text),
Division = SubDDivision.Text,
LotTotals = Int32.Parse(SubDLots.Text),
SalesRep = SubDSalesRep.Text,
UtilityProgram = SubDUtility.Text,
UtilityExpedition = SubDUtility2.Text,
Registry = SubDRegistry.Text
};
var lotJson = JsonConvert.SerializeObject(subDivisionEntry);
var client = new HttpClient();
var HttpContent = new StringContent(lotJson);
HttpContent.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json");
await client.PostAsync("http://localhost:62611/api/SubDivisions", HttpContent);
AddSubDivisionPopup.IsOpen = false;
SubDName.Text = "";
SubDBuilder.Text = "";
SubDCrossSt.Text = "";
SubDCity.Text = "";
SubDState.Text = "";
SubDZip.Text = "";
SubDClimate.Text = "";
SubDDivision.Text = "";
SubDLots.Text = "";
SubDSalesRep.Text = "";
SubDRegistry.Text = "";
SubDUtility.Text = "";
SubDUtility2.Text = "";
}
catch (Exception exception)
{
Console.WriteLine(exception);
}
}
public SubDivForm(SubDivision subDiv)
{
InitializeComponent();
newSubDivSet = false;//set flag in edit mode
NewdSubDivivsion = subDiv;
DivRecords = new ObservableCollection <SubDivision>();
PreviosDataLoad();
SetDefaultControls(subDiv);
this.Text = "Режим редактирования данных о подразделении";
checkBox1.CheckedChanged += checkBox1_CheckedChanged;
ParentSubDiv_comboBox.SelectedIndexChanged += ParentSubDiv_comboBox_SelectedIndexChanged;
}
public IHttpActionResult DeleteSubDivision(int id)
{
SubDivision subDivision = db.SubDivisions.Find(id);
if (subDivision == null)
{
return(NotFound());
}
db.SubDivisions.Remove(subDivision);
db.SaveChanges();
return(Ok(subDivision));
}
public void Put(SubDivisionDTO subDivisionDTO)
{
using (var db = new ModelContext())
{
SubDivision existingSubDivision = db.SubDivisions
.Where(m => m.Id == subDivisionDTO.Id)
.FirstOrDefault();
if (existingSubDivision != null)
{
existingSubDivision.Name = subDivisionDTO.Name;
existingSubDivision.DivisionId = subDivisionDTO.DivisionId;
db.SaveChanges();
}
}
}
public bool NewSubDivValidstion(SubDivision newSubDiv)
{
bool result = true;
if (!EmptyField(newSubDiv.SubDivName))
{
MessageBox.Show("Поле названия предприятия не должно быть пустым");
return(false);
}
if (newSubDiv.CollapsDate < newSubDiv.CreateDate)
{
MessageBox.Show("Дата закрытия не может быть более ранеей , чем дата его создания");
return(false);
}
return(result);
}
public async Task <ActionResult <SubDivision> > Read(SubDivision subdivision) //прочитать о подразделении
{
if (Response.StatusCode == 400)
{
return(BadRequest("Не удалось обработать данный запрос."));
}
SubDivision sub = await db.SubDivisions.FirstOrDefaultAsync(x =>
x.Id == subdivision.Id ||
(subdivision.Name != null && x.Name.ToLower() == subdivision.Name.ToLower())); //ищем подразделение
if (sub == null)
{
return(BadRequest("Информация о подразделении не найдена. Попробуйте изменить запрос"));
}
return(Ok(sub));
}
public async Task <ActionResult <SubDivision> > DeleteSubDiv(uint?id) //удалить данные о подразделении
{
#region Проверка входных данных
if (id == null)
{
return(BadRequest("Ошибка чтения запроса"));
}
SubDivision s = await db.SubDivisions.FirstOrDefaultAsync(x => x.Id == id);
#endregion
if (s != null)
{
db.SubDivisions.Remove(s);
await db.SaveChangesAsync();
return(Ok("Данные о подразделении { " + s.Name + " } успешно удалены"));
}
return(BadRequest("Не удалось выполнить удаление. Подразделение не найдено."));
}
public async Task <IActionResult> SubDivisionEdit(int id,
[Bind("Id,SubDivisionTitle,SubDivisionCode,DivisionId")]
SubDivision subDivision)
{
if (id != subDivision.Id)
{
return(NotFound());
}
if (!ModelState.IsValid)
{
return(View(subDivision));
}
var editSuccess = await _wpbService.UpdateSubDivisionAsync(subDivision);
if (editSuccess)
{
return(RedirectToAction(nameof(SubDivisionsAll)));
}
return(NotFound());
}
public async Task <bool> UpdateSubDivisionAsync(SubDivision subDivision)
{
try
{
_wpbDataContext.Update(subDivision);
await _wpbDataContext.SaveChangesAsync();
return(true);
}
catch (DbUpdateConcurrencyException err)
{
var error = err.ToString();
if (!SubDivisionExists(subDivision.Id))
{
return(false);
}
else
{
throw;
};
}
}
public async Task <IActionResult> PutSubDivision(int subDivisionId, SubDivision subDivision)
{
if (subDivisionId != subDivision.SubDivisionId)
{
return(BadRequest());
}
_context.Entry(subDivision).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubDivisionExists(subDivisionId))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <SubDivision> > Create(SubDivision subDivision) //создать запись о подразделении
{
#region Проверка входных данных
if (subDivision == null)
{
return(BadRequest("Невозможно добавить подразделение с пустыми значениями"));
}
if (!CheckEntireData(subDivision.Name))
{
return(BadRequest("Получены некоректные данные"));
}
bool result = await db.SubDivisions.AnyAsync(x => x.Name == subDivision.Name && x.ParentId == subDivision.ParentId); //проверяем, нет ли такого пользователя
if (result)
{
return(BadRequest("Запись о данном подразделении уже внесена"));
}
#endregion
await db.SubDivisions.AddAsync(subDivision);
await db.SaveChangesAsync();
return(Ok(subDivision));
}
public static string SubDivisionManage(SubDivision subdivision)
{
string msg = string.Empty;
try
{
Global.conn.Open();
if (subdivision.SubDivisionID == 0)
{
SqlCommand cmd = new SqlCommand("SubDivisionMasterInsert", Global.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DivisionID", SqlDbType.BigInt).Value = subdivision.DivisionID;
cmd.Parameters.Add("@SubDivisionName", SqlDbType.NVarChar).Value = subdivision.SubDivisionName;
cmd.Parameters.Add("@SubDivisionNameG", SqlDbType.NVarChar).Value = subdivision.SubDivisionNameG;
cmd.Parameters.Add("@ShortCode", SqlDbType.NVarChar).Value = subdivision.ShortCode;
cmd.Parameters.Add("@Address1", SqlDbType.NVarChar).Value = subdivision.Address1;
cmd.Parameters.Add("@Address2", SqlDbType.NVarChar).Value = subdivision.Address2;
cmd.Parameters.Add("@Address3", SqlDbType.NVarChar).Value = subdivision.Address3;
cmd.Parameters.Add("@Address1G", SqlDbType.NVarChar).Value = subdivision.Address1G;
cmd.Parameters.Add("@Address2G", SqlDbType.NVarChar).Value = subdivision.Address2G;
cmd.Parameters.Add("@Address3G", SqlDbType.NVarChar).Value = subdivision.Address3G;
cmd.Parameters.Add("@PhoneNo", SqlDbType.NVarChar).Value = subdivision.PhoneNo;
cmd.Parameters.Add("@PhoneNoG", SqlDbType.NVarChar).Value = subdivision.PhoneNoG;
cmd.Parameters.Add("@MobileNo", SqlDbType.NVarChar).Value = subdivision.MobileNo;
cmd.Parameters.Add("@MobileNoG", SqlDbType.NVarChar).Value = subdivision.MobileNoG;
cmd.Parameters.Add("@LoginType", SqlDbType.NVarChar).Value = HttpContext.Current.Session["LoginType"];
cmd.Parameters.Add("@InsertedBy", SqlDbType.BigInt).Value = HttpContext.Current.Session["UserID"];
cmd.Parameters.Add("@InsertTime", SqlDbType.DateTime).Value = HttpContext.Current.Session["date"];
cmd.Parameters.Add("@YearID", SqlDbType.BigInt).Value = HttpContext.Current.Session["YearID"];
cmd.Parameters.Add("@MachineName", SqlDbType.NVarChar).Value = Global.MachineName;
cmd.ExecuteNonQuery();
cmd.Dispose();
msg = "પેટા વિભાગની માહિતી દાખલ થઇ ગઈ છે.";
// Global.LogInsert(formname, "Insert", "SubDivisionMaster", "SubDivisionManage");
Global.conn.Close();
}
else
{
SqlCommand cmd = new SqlCommand("SubDivisionMasterUpdate", Global.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SubDivisionID", SqlDbType.BigInt).Value = subdivision.SubDivisionID;
cmd.Parameters.Add("@DivisionID", SqlDbType.BigInt).Value = subdivision.DivisionID;
cmd.Parameters.Add("@SubDivisionName", SqlDbType.NVarChar).Value = subdivision.SubDivisionName;
cmd.Parameters.Add("@SubDivisionNameG", SqlDbType.NVarChar).Value = subdivision.SubDivisionNameG;
cmd.Parameters.Add("@ShortCode", SqlDbType.NVarChar).Value = subdivision.ShortCode;
cmd.Parameters.Add("@Address1", SqlDbType.NVarChar).Value = subdivision.Address1;
cmd.Parameters.Add("@Address2", SqlDbType.NVarChar).Value = subdivision.Address2;
cmd.Parameters.Add("@Address3", SqlDbType.NVarChar).Value = subdivision.Address3;
cmd.Parameters.Add("@Address1G", SqlDbType.NVarChar).Value = subdivision.Address1G;
cmd.Parameters.Add("@Address2G", SqlDbType.NVarChar).Value = subdivision.Address2G;
cmd.Parameters.Add("@Address3G", SqlDbType.NVarChar).Value = subdivision.Address3G;
cmd.Parameters.Add("@PhoneNo", SqlDbType.NVarChar).Value = subdivision.PhoneNo;
cmd.Parameters.Add("@PhoneNoG", SqlDbType.NVarChar).Value = subdivision.PhoneNoG;
cmd.Parameters.Add("@MobileNo", SqlDbType.NVarChar).Value = subdivision.MobileNo;
cmd.Parameters.Add("@MobileNoG", SqlDbType.NVarChar).Value = subdivision.MobileNoG;
cmd.Parameters.Add("@LoginType", SqlDbType.NVarChar).Value = HttpContext.Current.Session["LoginType"];
cmd.Parameters.Add("@UpdatedBy", SqlDbType.BigInt).Value = HttpContext.Current.Session["UserID"];
cmd.Parameters.Add("@UpdateTime", SqlDbType.DateTime).Value = HttpContext.Current.Session["date"];
cmd.Parameters.Add("@YearID", SqlDbType.BigInt).Value = HttpContext.Current.Session["YearID"];
cmd.Parameters.Add("@MachineName", SqlDbType.NVarChar).Value = Global.MachineName;
cmd.ExecuteNonQuery();
cmd.Dispose();
msg = "પેટા વિભાગની માહિતી સુધારાઈ ગઈ છે.";
// Global.LogInsert(formname, "Update", "SubDivisionMaster", "SubDivisionManage");
Global.conn.Close();
}
}
catch (Exception ex)
{
Global.ErrorInsert(ex.Message, formname, "SubDivisionManage");
msg = "Error" + ex.Message;
}
finally
{
if (Global.conn.State == ConnectionState.Open)
{
Global.conn.Close();
}
}
return(msg);
}
public async Task CreateSubDivisionAsync(SubDivision subdivision)
{
_wpbDataContext.SubDivisions.Add(subdivision);
await _wpbDataContext.SaveChangesAsync();
}
public Division()
{
Outer = new SubDivision();
Room = new SubDivision();
}
