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