public ActionResult EditUser(User userToSave) { try { user dalUser = (from u in dbContext.users where u.user_id == userToSave.UserId select u).FirstOrDefault(); dalUser.email = userToSave.Email; dalUser.password = userToSave.Password; if (!dbContext.organizations.Any(o => o.orginization_name.Contains(userToSave.OrgName) || o.orginization_name.StartsWith(userToSave.OrgName))) { string orgAbrev = string.Join(string.Empty, userToSave.OrgName.Split(new[] { ' ' }, StringSplitOptions.RemoveEmptyEntries).Select(s => s[0])); organization newOrg = new organization { orginization_name = userToSave.OrgName, orginization_abrev = orgAbrev }; dbContext.organizations.InsertOnSubmit(newOrg); dbContext.SubmitChanges(); dalUser.organization_id = userToSave.OrganizationId; } dalUser.role_id = userToSave.RoleId; dbContext.SubmitChanges(); return(RedirectToAction("UserMGMT")); } catch { return(View()); } }
public ActionResult CreateUser(User newUser) { try { user dalSubmission = new user { email = newUser.Email, password = newUser.Password, role_id = newUser.RoleId }; if (!dbContext.organizations.Any(o => o.orginization_name.Contains(newUser.OrgName) || o.orginization_name.StartsWith(newUser.OrgName))) { string orgAbrev = string.Join(string.Empty, newUser.OrgName.Split(new[] { ' ' }, StringSplitOptions.RemoveEmptyEntries).Select(s => s[0])); organization newOrg = new organization { orginization_name = newUser.OrgName, orginization_abrev = orgAbrev }; dbContext.organizations.InsertOnSubmit(newOrg); dbContext.SubmitChanges(); dalSubmission.organization_id = newOrg.organization_id; } dbContext.users.InsertOnSubmit(dalSubmission); dbContext.SubmitChanges(); return(RedirectToAction("UserMGMT")); } catch { return(View()); } }
public JsonResult AddOrganazation(organization org) { var check = db.organization.Where(c => c.name == org.name); int result = 0; if (check.Count() != 0) { result = 0; } else { if (ModelState.IsValid) { org.manger_id = (int)Session["man_id"]; db.organization.Add(org); db.SaveChanges(); Session["orggg_id"] = org.id; result = 1; } else { result = -1; } } return(Json(new { result, JsonRequestBehavior.AllowGet })); }
public ActionResult Create(OrganizationViewModel organization) { //OrganizationService os = new OrganizationService(); try { if (ModelState.IsValid) { organization o = new organization(); //o.id = organization.id; o.name = organization.name; o.type = organization.type; o.PresidentID = organization.PresidentID; o.Location = organization.Location; os.Add(o); os.Commit(); Session["organization"] = o; return(RedirectToAction("Index")); } return(View()); } catch { return(View()); } }
public ActionResult Delete(int id, FormCollection collection) { try { OrganizationService os = new OrganizationService(); organization o = os.GetById(id); OrganizationViewModel om = new OrganizationViewModel(); om.id = o.id; om.name = o.name; om.type = o.type; om.President = us.GetById((int)o.PresidentID); user i = om.President; o.PresidentID = null; i.DTYPE = "user"; us.Update(i); us.Commit(); os.Delete(o); os.Commit(); return(RedirectToAction("Index")); } catch { return(View()); } }
public IEnumerable <organization> GetOrganization(string Identifier, string addressCity, string partof, string type, string active, string addressState) { try { if (string.IsNullOrEmpty(Identifier) && string.IsNullOrEmpty(addressCity) && string.IsNullOrEmpty(partof) && string.IsNullOrEmpty(type)) { OrganizationDAL OrgDAL = new OrganizationDAL(); return(OrgDAL.GetAll()); } else { organization FilterObj = organizationConverter.ConvertParams(Identifier, active, type, addressCity, addressState, partof); OrganizationDAL OrgDAL = new OrganizationDAL(); return(OrgDAL.Filter(FilterObj)); } } catch (Exception e) { throw e; } }
public string AddOrganization(ref OperationResult pobjOperationResult, organizationDto pobjDtoEntity, List <string> ClientSession) { //mon.IsActive = true; string NewId = "(No generado)"; try { SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel(); organization objEntity = organizationAssembler.ToEntity(pobjDtoEntity); objEntity.d_InsertDate = DateTime.Now; objEntity.i_InsertUserId = Int32.Parse(ClientSession[2]); objEntity.i_IsDeleted = 0; // Autogeneramos el Pk de la tabla int intNodeId = 9; NewId = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 5), "OO"); objEntity.v_OrganizationId = NewId; dbContext.AddToorganization(objEntity); dbContext.SaveChanges(); pobjOperationResult.Success = 1; return(NewId); } catch (Exception ex) { pobjOperationResult.Success = 0; pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex); // Llenar entidad Log LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.CREACION, "ORGANIZACIÓN", "i_OrganizationId=" + NewId.ToString(), Success.Failed, pobjOperationResult.ExceptionMessage); return(null); } }
public IHttpActionResult Putorganization(int id, organization organization) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != organization.id) { return(BadRequest()); } db.Entry(organization).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!organizationExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
//build Organizations Hierarchy tree public JsonResult json_readWorkFlow() { sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString); DataTable dt = db.fetch("select * from dbo.organization").Tables[0]; //build tree List <organization> tree = new List <organization> { }; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["parent_org_id"].ToString() == "") { var node = new organization() { org_id = dt.Rows[i][0].ToString(), parent_org_id = dt.Rows[i][1].ToString(), org_name = dt.Rows[i][2].ToString(), logo = "/resources/modules/workflow/images/" + dt.Rows[i][6].ToString(), children = new List <organization>(), //assignedUsers = this.getTaskAssignedUsers(Convert.ToUInt16(dt.Rows[i][0])) }; tree.Add(node); } } for (int j = 0; j < tree.Count; j++) { this.RecTree(tree[j], dt); } return(Json(tree, JsonRequestBehavior.AllowGet)); }
private void dgOrg_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { if (e.EditAction == DataGridEditAction.Commit) { organization org = e.Row.DataContext as organization; var matchedData = (from o in dbContext.organization where o.ID == org.ID select o).SingleOrDefault(); if (matchedData == null) { organization rOrganization = new organization(); rOrganization.organizationName = org.organizationName; dbContext.organization.Add(rOrganization); dbContext.SaveChanges(); dgOrg.ItemsSource = GetOrganizationList(); txtStatus.Text = rOrganization.organizationName + " has being added!"; } else { matchedData.organizationName = org.organizationName; dbContext.SaveChanges(); dgOrg.ItemsSource = GetOrganizationList(); txtStatus.Text = "Məlumat yeniləndi"; } } }
public HttpResponseMessage put(int id, [FromBody] organization organizations) { try { using (Count10_DevEntities entities = new Count10_DevEntities()) { var entity = entities.organizations.FirstOrDefault(e => e.id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Organization with Id = " + id.ToString() + " not found to edit")); } else { entity.name = organizations.name; entity.alt_name = organizations.alt_name; entity.parent_id = organizations.parent_id; entity.notes = organizations.notes; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IHttpActionResult post([FromBody] organization organizations) { try { if (string.IsNullOrEmpty(organizations.name)) { ModelState.AddModelError("name", "Name is Required"); } if (ModelState.IsValid) { using (Count10_DevEntities entities = new Count10_DevEntities()) { organizations.active = organizations.active.HasValue ? organizations.active : true; organizations.archived = organizations.archived.HasValue ? organizations.archived : false; organizations.updated_by = organizations.updated_by.HasValue ? organizations.updated_by : 1; organizations.created_by = organizations.created_by.HasValue ? organizations.created_by : 1; organizations.created_at = DateTime.Now; organizations.updated_at = DateTime.Now; entities.organizations.Add(organizations); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, organizations); } return(Ok(organizations)); } return(BadRequest(ModelState)); } catch (Exception) { return(BadRequest(ModelState)); } }
public ActionResult DeleteConfirmed(int id) { organization organization = db.organizations.Find(id); db.organizations.Remove(organization); db.SaveChanges(); return(RedirectToAction("Index")); }
private void homepage_Load(object sender, EventArgs e) { //窗口变量赋值 organization = new organization(); personal = new personal(); feedback = new feedback(); administrator = new administrator(); help = new help(); changepassword = new changepassword(); }
public ActionResult AddOrganization(organization org, int univ) { org.idUniv = univ; IserviceOrganization spo = new serviceOrganization(); spo.Add(org); spo.Commit(); return(RedirectToAction("Organizations")); }
public ActionResult Edit([Bind(Include = "organizationID,name,phone,email,note")] organization organization) { if (ModelState.IsValid) { db.Entry(organization).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(organization)); }
public IHttpActionResult Getorganization(int id) { organization organization = db.organizations.Find(id); if (organization == null) { return(NotFound()); } return(Ok(organization)); }
public ActionResult Create([Bind(Include = "organizationID,name,phone,email,note")] organization organization) { if (ModelState.IsValid) { db.organizations.Add(organization); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(organization)); }
//添加组织 public static bool Add(organization organ) { //string constr= ConfigurationManager.ConnectionStrings["qhj_aspEntities"].ConnectionString; string constr = "Server=localhost;UserId=root;Password=qhj12345;Database=qhj_asp;pooling=false;CharSet=utf8;port=3306"; MySqlConnection conn = new MySqlConnection(constr); try { conn.Open(); string name = organ.oname; string time = organ.time; string creator = organ.creator; string desc = organ.description; string task = organ.task; string contact = organ.contact; string mySql = "INSERT INTO organization(oname,time,creator,description,task,contact) VALUES(@name,@time,@creator,@desc,@task,@contact)"; MySqlCommand sqlcmd2 = new MySqlCommand(mySql, conn); MySqlParameter p1 = new MySqlParameter("@name", MySqlDbType.VarChar); p1.Value = name; MySqlParameter p2 = new MySqlParameter("@time", MySqlDbType.VarChar); p2.Value = time; MySqlParameter p3 = new MySqlParameter("@creator", MySqlDbType.VarChar); p3.Value = creator; MySqlParameter p4 = new MySqlParameter("@desc", MySqlDbType.VarChar); p4.Value = desc; MySqlParameter p5 = new MySqlParameter("@task", MySqlDbType.VarChar); p5.Value = task; MySqlParameter p6 = new MySqlParameter("@contact", MySqlDbType.VarChar); p6.Value = contact; sqlcmd2.Parameters.Add(p1); sqlcmd2.Parameters.Add(p2); sqlcmd2.Parameters.Add(p3); sqlcmd2.Parameters.Add(p4); sqlcmd2.Parameters.Add(p5); sqlcmd2.Parameters.Add(p6); int iResult = sqlcmd2.ExecuteNonQuery(); if (iResult > 0) { return(true); } } catch (Exception ex) { Debug.WriteLine("Error: " + ex.Message); } finally { conn.Close(); conn.Dispose(); } return(false); }
public ActionResult Edit([Bind(Include = "organizationId,code,name,description,fulladdress,phone,email,website,organizationtypeId")] organization organization) { if (ModelState.IsValid) { db.Entry(organization).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.organizationtypeIdList = new SelectList(db.organizationtypes, "organizationtypeId", "code", organization.organizationtypeId); return(View(organization)); }
public object GetData() { if (null == workingRecord) { workingRecord = new organization(); } workingRecord.name = wtrOrgName.Text; workingRecord.orgsunshineid = wtrID.Text; workingRecord.phone = wtrPhone.Text; workingRecord.phonenumbers_organization.Clear(); foreach (var item in flpPhoneNumbers.Controls) { if (item is PhoneAdd) { workingRecord.phonenumbers_organization.Add(new phonenumbers_organization() { ownerID = workingRecord.orgid, phonenumber = (item as PhoneAdd).GetText() }); } } workingRecord.social_media_organization.Clear(); foreach (var item in flpSocial.Controls) { if (item is SocialMediaLink) { workingRecord.social_media_organization.Add(new social_media_organization() { sm_org_id = workingRecord.orgid, sm_title = (item as SocialMediaLink).LinkTitle, sm_link = Encoding.ASCII.GetBytes((item as SocialMediaLink).LinkURL), sm_type = (item as SocialMediaLink).SMType }); } } workingRecord.addresses_organization.Clear(); AddAddressToRecord(workingRecord.addresses_organization, GetPrimaryAddress()); AddAddressToRecord(workingRecord.addresses_organization, GetSecondaryAddress()); if (null != workingRecord.actions_organization) { workingRecord.actions_organization.Clear(); } workingRecord.actions_organization = actions; workingRecord.financialsupport = GetFinancialSupport(); return(workingRecord); }
public ActionResult RegisterOrganization(organization organization) { if (ModelState.IsValid) { WebsiteDB.organizations.Add(organization); WebsiteDB.SaveChanges(); return(RedirectToAction("Organizations")); } return(View()); }
public IHttpActionResult Postorganization(organization organization) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.organizations.Add(organization); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = organization.id }, organization)); }
// GET: Organization/Delete/5 public ActionResult Delete(int id) { OrganizationService os = new OrganizationService(); organization o = os.GetById(id); OrganizationViewModel om = new OrganizationViewModel(); om.id = o.id; om.name = o.name; om.type = o.type; om.President = us.GetById((int)o.PresidentID); return(View(om)); }
public static OrganizationDetial_M ToViewModel(organization organizationDetial, List <activity> organizationActivity, string uid) { return(new OrganizationDetial_M() { userName = organizationDetial.orgMember.FirstOrDefault().student.name, organizationDetial = organizationDetial, organizationBeginTime = organizationDetial.establish_time.Value.ToString("yyyy-MM-dd"), organizationActivity = organizationActivity, activityWaiting = organizationActivity.Where(o => o.activity_time > DateTime.Now).ToList(), activityFinished = organizationActivity.Where(o => o.activity_time <= DateTime.Now).ToList(), concernsState = organizationDetial.organizationalConcerns.Count(o => o.org_id == organizationDetial.org_id && o.userid == uid) > 0 ? 1 : 0 }); }
public ActionResult DeleteConfirmed(int id) { organization organization = db.organizations.Find(id); db.organizations.Remove(organization); IEnumerable <contact> contacts = db.contacts.Where(c => c.organizationID == id); foreach (contact p in contacts) { p.organizationID = null; } db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: /CRM/organizations/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } organization organization = db.organizations.Find(id); if (organization == null) { return(HttpNotFound()); } return(View(organization)); }
public IHttpActionResult Deleteorganization(int id) { organization organization = db.organizations.Find(id); if (organization == null) { return(NotFound()); } db.organizations.Remove(organization); db.SaveChanges(); return(Ok(organization)); }
// GET: /CRM/organizations/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } organization organization = db.organizations.Find(id); if (organization == null) { return(HttpNotFound()); } ViewBag.organizationtypeIdList = new SelectList(db.organizationtypes, "organizationtypeId", "code", organization.organizationtypeId); return(View(organization)); }
// GET: Organization/Details/5 public ActionResult Details(int id) { OrganizationViewModel om = new OrganizationViewModel(); organization o = os.GetById(id); om.id = o.id; om.name = o.name; om.type = o.type; om.Location = o.Location; om.President = us.GetById((int)o.PresidentID); return(View(om)); }
public static organization getOrgDetails(string org_id) { sqlServer db = new sqlServer(ConfigurationManager.ConnectionStrings["winhostConnection"].ConnectionString); DataTable dt = db.fetch("select * from organization where org_id=" + org_id).Tables[0]; organization data = new organization(); data = new organization() { org_id = dt.Rows[0][0].ToString(), parent_org_id = dt.Rows[0][1].ToString(), org_name = dt.Rows[0][2].ToString(), street = dt.Rows[0][3].ToString(), city = dt.Rows[0][4].ToString(), postalcode = dt.Rows[0][5].ToString() }; return data; }