public int CreateOrganization(OrganizationInsertModel model) { string sql = "insert into public.\"Organization\" (\"Name\",\"PersonFullName\",\"ContactEmail\",\"ActiveStatus\") " + " values(@Name, @PersonFullName, @ContactEmail, 1) RETURNING \"Id\""; return(_connection.ExecuteScalar <int>(sql, model)); }
public IActionResult OrganizationNew(string id) { if (GetUserId() != 0) { return(Redirect("/Home/Dashboard")); } int realId = WebUtilities.DecryptId(id, GetUserName(), GetOrganizationId()); if (realId > 0) { var organizationModel = operations.Organization.GetOrganizationList(0, 99, realId).FirstOrDefault(); OrganizationInsertModel model = new OrganizationInsertModel(); model.AddressBindings = organizationModel.AddressBindings; model.ContactEmail = organizationModel.ContactEmail; model.Id = organizationModel.Id; model.HashedId = WebUtilities.EncryptId(model.Id, GetUserName(), GetOrganizationId()); model.Name = organizationModel.Name; model.PersonFullName = organizationModel.PersonFullName; return(View(model)); } else { OrganizationInsertModel model = new OrganizationInsertModel(); return(View(model)); } }
public void UpdateOrganization(OrganizationInsertModel model) { string sql = "update public.\"Organization\" set \"Name\" = @Name , \"PersonFullName\" = @PersonFullName , \"ContactEmail\" = @ContactEmail where \"Id\" = @Id"; _connection.Execute(sql, model); }
public IActionResult OrganizationNew(OrganizationInsertModel model) { if (GetUserId() != 0) { return(Redirect("/Home/Dashboard")); } model.CloseModal = false; if (String.IsNullOrEmpty(model.Name) || String.IsNullOrEmpty(model.PersonFullName) || String.IsNullOrEmpty(model.ContactEmail) || String.IsNullOrEmpty(model.AddressBindings)) { TempData["Notification"] = WebUtilities.InsertNotification("İsim , ad , mail adresi , adresler boş geçilemez."); return(View(model)); } if (String.IsNullOrEmpty(model.HashedId)) { int returnValue = operations.Organization.CreateOrganization(model); List <AddressBindingInsertModel> insertModel = new List <AddressBindingInsertModel>(); string[] arrAddressBinding = model.AddressBindings.Split(','); for (int i = 0; i < arrAddressBinding.Length; i++) { insertModel.Add(new AddressBindingInsertModel { Address = arrAddressBinding[i].Trim().Split(':')[0], Port = Convert.ToInt32(arrAddressBinding[i].Trim().Split(':')[1]), OrganizationId = returnValue }); } operations.Organization.InsertAddressBindings(returnValue, insertModel); if (returnValue > 0) { model.HashedId = WebUtilities.EncryptId(returnValue, GetUserName(), GetOrganizationId()); TempData["Notification"] = WebUtilities.InsertNotification("Organizasyon başarılı bir şekilde eklenmiştir."); model.CloseModal = true; return(View(model)); } else { TempData["Notification"] = WebUtilities.InsertNotification("Ekleme sırasında bir hata oluştu lütfen sistem yöneticisine başvurunuz."); model.CloseModal = false; return(View(model)); } } else { int realId = WebUtilities.DecryptId(WebUtility.UrlDecode(model.HashedId), GetUserName(), GetOrganizationId()); if (realId > 0) { List <AddressBindingInsertModel> insertModel = new List <AddressBindingInsertModel>(); string[] arrAddressBinding = model.AddressBindings.Split(','); for (int i = 0; i < arrAddressBinding.Length; i++) { insertModel.Add(new AddressBindingInsertModel { Address = arrAddressBinding[i].Trim().Split(':')[0], Port = Convert.ToInt32(arrAddressBinding[i].Trim().Split(':')[1]), OrganizationId = realId }); } operations.Organization.DeleteAddressBinding(realId); operations.Organization.InsertAddressBindings(realId, insertModel); operations.Organization.UpdateOrganization(model); return(View(model)); } else { TempData["Notification"] = WebUtilities.InsertNotification("Hatalı işlem lütfen pencereyi kapatıp tekrar deneyiniz."); model.CloseModal = false; return(View(model)); } } // return View(); }