protected void Page_Load(object sender, EventArgs e)
{
project project = new project();
DataSet dt = project.GetList("");
StringBuilder stringBuilder = new StringBuilder();
string strProjectDetail = "";
if (dt.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
stringBuilder.Append("<li><img src = \"Images/Img.jpg\" ><a href = \"projectDetail.aspx?docid=" + dt.Tables[0].Rows[i]["id"].ToString() + "&rend =" + System.Guid.NewGuid().ToString() + "\">");
stringBuilder.Append("<span> " + dt.Tables[0].Rows[i]["projectNmae"].ToString() + " </span></a><br>");
stringBuilder.Append(" <i> " + Convert.ToDateTime(dt.Tables[0].Rows[i]["publishTime"].ToString()).ToString("yyyy.MM.dd") + "");
string[] strArray = dt.Tables[0].Rows[i]["industry"].ToString().Split('#');
for (int j = 0; j < strArray.Length; j++)
{
if (j != strArray.Length - 1)
{
stringBuilder.Append(" " + strArray[j] + " ");
}
}
stringBuilder.Append("</i>");
strProjectDetail = dt.Tables[0].Rows[i]["projectDetail"].ToString();
if (strProjectDetail.Length > 400)
{
strProjectDetail = strProjectDetail.Substring(0, 400) + "...";
}
stringBuilder.Append("<p>" + strProjectDetail + "</p>");
stringBuilder.Append("<a href =\"projectDetail.aspx?docid=" + dt.Tables[0].Rows[i]["id"] + "&rend=" + System.Guid.NewGuid().ToString() + "\"><em> 了解更多 </em></a>\"");
stringBuilder.Append("</li>\"");
}
}
this.lb_show.Text = stringBuilder.ToString();
}
private void dataShow()
{
string strDocid = "";
if (this.Request.QueryString["docid"] != null)
{
strDocid = this.Request.QueryString["docid"].ToString();
project project = new project();
project.GetModel(" and id='" + strDocid + "' ");
this.lb_projectName.Text = project.projectNmae;
this.lb_projectNet.Text = project.projectAdress;
this.lb_projectSummary.Text = project.projcetSummary;
this.lb_projectKey.Text = project.projcetKeyword;
this.lb_industry.Text = project.industry.Replace("#", " ");
this.lb_projectDetail.Text = project.projectDetail;
this.lb_financing.Text = project.financing.ToString();
this.lb_phone.Text = project.phoneNumber;
this.lb_email.Text = project.eamil;
this.lb_movice.Text = project.video;
this.lb_teamDetail.Text = project.teamDetail;
projectMessage projectMessage = new projectMessage();
DataSet dtSet = projectMessage.GetList(" and projectId ='" + strDocid + "' ");
string strMessage = "";
if (dtSet.Tables[0].Rows.Count > 0)
{
for (int i=0;i<dtSet.Tables[0].Rows.Count;i++)
{
strMessage = dtSet.Tables[0].Rows[i]["projectMessages"].ToString();
for (int j=0;j<((strMessage.Length/30)+1);j++)
{
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Request.QueryString["docid"] != null)
{
this.txtDocid.Text = this.Request.QueryString["docid"].ToString();
}
DataSet dt = new DataSet();
project project = new project();
dt = project.GetList(" id='" + this.txtDocid.Text + "' ");
if (dt.Tables[0].Rows.Count > 0)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<span> " + dt.Tables[0].Rows[0]["projectNmae"].ToString() + " </span><br>");
stringBuilder.Append(" <i> " + Convert.ToDateTime(dt.Tables[0].Rows[0]["publishTime"].ToString()).ToString("yyyy.MM.dd") + "");
string[] strArray = dt.Tables[0].Rows[0]["industry"].ToString().Split('#');
for (int j = 0; j < strArray.Length; j++)
{
if (j != strArray.Length - 1)
{
stringBuilder.Append(" " + strArray[j] + " ");
}
}
stringBuilder.Append("</i>");
stringBuilder.Append("<img src =\"Images/Img.jpg\" >");
stringBuilder.Append("<p> " + dt.Tables[0].Rows[0]["projectDetail"].ToString() + "</p>");
this.lb_show.Text = stringBuilder.ToString();
}
}
public Projects(project input)
{
this.ID = int.Parse(input.id.First().Value);
this.Name = input.name;
this.Status = input.status;
this.CompanyID = int.Parse(input.company.First().id.First().Value);
this.Company = input.company.First().name;
this.TodoLists = new List<TodoLists>();
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClassesDataContext da = new DataClassesDataContext();
project p = new project();
p.project_num = TextBox1.Text;
p.title = TextBox2.Text;
p.type = TextBox3.Text;
p.major = TextBox4.Text;
p.detail = TextBox5.Text;
da.project.InsertOnSubmit(p);
da.SubmitChanges();
Binder();
}
//批量删除
protected void btndelinfo_Click(object sender, EventArgs e)
{
HyCommon HyCommon = new HyCommon();
project project = new project();
String[] v_uids = this.txtuids.Value.Split(',');
for (int i = 0; i < v_uids.Length; i++)
{
project.id = v_uids[i];
project.Delete();
}
string pageUrl = HyCommon.CombUrlTxt("exportList.aspx", "page={0}&rnd={1}", "" + this.txtPage.Text + "", "" + System.Guid.NewGuid().ToString() + "");
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>tip('数据已经被成功删除！','" + pageUrl + "');</script>");
}
public static int get_routing_method_index(project current_project)
{
switch (current_project.run_options.routing_method)
// Channel, Landscape Unit, Hydrologic Response Unit, All Basin
{
case "Variable Storage":
return(0);
case "Muskingum":
return(1);
default:
return(1);
}
}
public async Task <ActionResult> PatchProject(int id, ProjectDTO patchDoc)
{
try
{
var getProject = await _projectSvc.GetProjectByIdAsNoTracking(id);
if (getProject == null)
{
return(NotFound());
}
if (patchDoc.sdlcSystem != null)
{
if (patchDoc.sdlcSystem.id != 0)
{
var sdlcSys = await _sdlSvc.GetSdlcSystemByIdAsNoTracking(patchDoc.sdlcSystem.id);
if (sdlcSys == null)
{
return(NotFound());
}
}
}
if (patchDoc.name == null && patchDoc.external_id == null && patchDoc.sdlcSystem == null)
{
return(NotFound());
}
var project = new project();
var toUpdate = _mapper.Map(patchDoc, project);
var newUpdate = await _projectSvc.UpdateProject(id, toUpdate);
if (newUpdate == null)
{
return(Conflict());
}
return(Ok(newUpdate));
}
catch (Exception ex)
{
Log.Error("An error occurred " + ex);
return(BadRequest());
}
}
/// <summary>
/// Modifie un enregistrement sélectionner dans une liste d'un onglet sélectionner
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MIT_Open_Click(object sender, EventArgs e)
{
// ouvrir la liste des projets
if (TBC_Project.SelectedTab == TBP_ListProject && DTG_Project.SelectedRows[0].DataBoundItem != null)
{
project selectedProject = DTG_Project.SelectedRows[0].DataBoundItem as project;
EditProject editProject = new EditProject(selectedProject);
editProject.StartPosition = FormStartPosition.CenterParent;
if (editProject.ShowDialog() == DialogResult.OK)
{
_ProjectManagement.ListProject.Remove(selectedProject);
_ProjectManagement.ListProject.Add(selectedProject);
hasChanges = true;
}
}
// ouvrir la liste des types de tâches
else if (TBC_Project.SelectedTab == TBP_ListTypeTask && DTG_ListeTaskType.SelectedRows[0].DataBoundItem != null)
{
taskType selectedTaskType = DTG_ListeTaskType.SelectedRows[0].DataBoundItem as taskType;
EditTaskType editTaskType = new EditTaskType(selectedTaskType);
editTaskType.StartPosition = FormStartPosition.CenterParent;
if (editTaskType.ShowDialog() == DialogResult.OK)
{
_ProjectManagement.ListTaskType.Remove(selectedTaskType);
_ProjectManagement.ListTaskType.Add(selectedTaskType);
hasChanges = true;
}
}
// ouvrir la liste des tâches
else if (TBC_Project.SelectedTab == TBP_ListTask && DTG_ListTask.SelectedRows[0].DataBoundItem != null)
{
task selectedTask = DTG_ListTask.SelectedRows[0].DataBoundItem as task;
EditTask editTask = new EditTask(_ProjectManagement.ListProject, _ProjectManagement.ListTaskType, selectedTask);
editTask.StartPosition = FormStartPosition.CenterParent;
if (editTask.ShowDialog() == DialogResult.OK)
{
_ProjectManagement.ListTask.Remove(selectedTask);
_ProjectManagement.ListTask.Add(selectedTask);
hasChanges = true;
}
}
}
/// <summary>
/// 添加部门信息
/// </summary>
/// <param name="info">部门对象</param>
/// <returns>若成功返回true</returns>
public bool AddDepartmentWithParameter(DepartmentInfo info)
{
List <DepartmentInfo> infos = new List <DepartmentInfo>();
infos.Add(info);
project data = new project();
data.Field = JsonConvert.SerializeObject(infos);
data.Type = "1";
data.Search_type = "5";
String JSON = JsonConvert.SerializeObject(data);
data = DBTool.JSONStringToObject(DBTool.Send(JSON));
return(DBTool.isTrue(data.Field));
}
public ActionResult GetProject(int id)
{
using (PMEntities context = new PMEntities())
{
if (context.projects.Any(p => p.Id == id))
{
project pj = context.projects.Find(id);
pj.project_manager = context.Users.Find(pj.project_manager_id);
return(Json(new { status = "200", data = pj, displaySweetAlert = false }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "404", data = "", message = "project not found", displaySweetAlert = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Create([Bind(Include = "projectID,createrID,arrival,installation,rehearsal,start,finish,deinstallation,departure,placeID,worktype,executorID,type,showmanID,managerID,clientID,content,note,receipts_cash,receipts_noncash,expenditure_cash,expenditure_noncash,profit_cash,profit_noncash,profit_total")] project project)
{
if (ModelState.IsValid)
{
db.projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.executorID = new SelectList(db.contacts, "contactID", "name", project.executorID);
ViewBag.clientID = new SelectList(db.contacts, "contactID", "name", project.clientID);
ViewBag.managerID = new SelectList(db.contacts, "contactID", "name", project.managerID);
ViewBag.showmanID = new SelectList(db.contacts, "contactID", "name", project.showmanID);
ViewBag.placeID = new SelectList(db.places, "placeID", "name", project.placeID);
return(View(project));
}
public ActionResult Edit(int id)
{
project project = db.projects
.Include("tags")
.Include("project_photo")
.Include("updates")
.Include("donations")
.Include("achievements")
.Single(p => p.ProjectID == id);
ViewBag.Supporters = new SelectList(db.users.Where(x => x.Role == "admin" || x.Role == "supporter"), "UserID", "UserName");
ViewBag.CountryID = new SelectList(db.countries, "CountryID", "Name", project.CountryID);
ViewBag.UserID = new SelectList(db.users.Where(x => x.Role == "admin" || x.Role == "publisher"), "UserID", "UserName", project.UserID);
ViewBag.Tags = db.tags;
return(View(project));
}
/// <summary>
/// 修改用户个人信息
/// </summary>
/// <param name="info">用户对象</param>
/// <returns>若成功返回true</returns>
public bool Update(UserInfo info)
{
List <UserInfo> infos = new List <UserInfo>();
infos.Add(info);
project data = new project();
data.Field = JsonConvert.SerializeObject(infos);
data.Type = "5";
data.Search_type = "3";
String JSON = JsonConvert.SerializeObject(data);
data = DBTool.JSONStringToObject(DBTool.Send(JSON));
return(DBTool.isTrue(data.Field));
}
// GET: projects/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
project project = db.projects.Find(id);
if (project == null)
{
return(HttpNotFound());
}
ViewBag.projectStatusID = new SelectList(db.projectStatus, "projectStatusID", "projectStatusName", project.projectStatusID);
ViewBag.userID = new SelectList(db.proUsers, "userID", "firstname", project.userID);
return(View(project));
}
public ActionResult index(String describtion, String projectname, String pramter)
{
int i = Int32.Parse(WelcomeController.Tempid);
project p = new project();
user u = db.usertable.Find(Int32.Parse(WelcomeController.Tempid));
p.Customer = u;
p.describtion = describtion;
p.projectname = projectname;
p.status = "unsigned";
db.projecttable.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create()
{
ViewBag.CountryID = new SelectList(db.countries, "CountryID", "Name");
ViewBag.UserID = new SelectList(db.users.Where(x => x.Role == "admin" || x.Role == "publisher"), "UserID", "UserName");
var model = new project();
model.Date = DateTime.Now;
model.DateStart = DateTime.Now;
model.DateEnd = DateTime.Now.AddDays(60);
model.DateUpdate = DateTime.Now;
model.Target = 1000;
model.Approved = true;
model.Enabled = false;
model.Image = "https://s3-eu-west-1.amazonaws.com/localactors-webapp/projects/placeholder_project.png";
return(View(model));
}
// POST api/Projectsapi
public HttpResponseMessage Postproject(project project)
{
if (ModelState.IsValid)
{
db.projects.Add(project);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, project);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = project.id }));
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public ActionResult EditNotDelivered(int id, String describtion, String projectname)
{
int i = Int32.Parse(WelcomeController.Tempid);
project x = db.projecttable.Find(id);
x.describtion = describtion;
x.projectname = projectname;
if (TryUpdateModel(x))
{
db.SaveChanges();
}
return(RedirectToAction("CustomerProfile"));
}
public ActionResult Create()
{
ViewBag.CountryID = new SelectList(db.countries, "CountryID", "Name");
var model = new project();
model.UserID = CurrentUser.UserID;
model.Date = DateTime.Now;
model.DateStart = DateTime.Now;
model.DateEnd = DateTime.Now.AddDays(60);
model.DateUpdate = DateTime.Now;
model.Target = 1000;
model.Image = "https://s3-eu-west-1.amazonaws.com/localactors-webapp/projects/placeholder_project.png";
return(View(model));
}
// GET: project/Details/5
public ActionResult Details(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
project p = Pservice.GetById(id);
if (p == null)
{
return(HttpNotFound());
}
return(View(p));
}
// GET: projects/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
project project = db.projects.Find(id);
if (project == null)
{
return(HttpNotFound());
}
ViewBag.categoryid = new SelectList(db.categories, "catid", "name", project.categoryid);
ViewBag.clientid = new SelectList(db.userdetails, "userid", "name", project.clientid);
return(View(project));
}
public ActionResult Addproject(project project)
{
if (ModelState.IsValid)
{
int id = Convert.ToInt32(Session["ID"]);
var writer = db.users.Where(model => model.Id == id).FirstOrDefault();
project.user_id = writer.Id;
project.Post_Status = 0;
db.projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public void ProcessRequest(HttpContext context)
{
if (context.Session["tea_id"] == null)
{
context.Response.Write("nologin");
}
else
{
if (context.Request["status"] == "del")
{
project project = new project()
{
teacher_num = context.Request["tea_num"],
project_name = context.Request["project_name"],
};
if (BLL.stuBll.tea_del_project(project) == true)
{
context.Response.ContentType = "text/plain";
context.Response.Write("true");
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("false");
}
}
else
{
project project = new project()
{
teacher_num = context.Request["tea_num"],
project_name = context.Request["project_name"],
project_info = context.Request["project_info"]
};
if (BLL.stuBll.tea_update_project(project) == true)
{
context.Response.ContentType = "text/plain";
context.Response.Write("true");
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("false");
}
}
}
}
public JsonResult Add_Project(string name, string[] pics, string[] pic_ext)
{
mikroklimat.Classes.Db_Connection db_c = new Classes.Db_Connection();
project pr = new project();
pr.name = name;
pr.add_date = DateTime.Now;
user add_us = db_c.mde.user.ToList().FirstOrDefault(x => x.username == User.Identity.Name);
pr.add_user = add_us.id;
db_c.mde.project.Add(pr);
db_c.mde.SaveChanges();
if (pics != null)
{
for (int i = 0; i < pics.Length; i++)
{
string data = @pics[i];
var base64Data = Regex.Match(data, @"data:image/(?<type>.+?),(?<data>.+)").Groups["data"].Value;
var binData = Convert.FromBase64String(base64Data);
using (var stream = new MemoryStream(binData))
{
Bitmap img = new Bitmap(stream);
string name_path = "/Content/img/large_" + pr.id + "_" + Guid.NewGuid() + pic_ext[i];
img.Save(Server.MapPath(name_path));
//Bitmap bm = new Bitmap(stream);
img = new Bitmap(stream);
mikroklimat.Classes.imgCrop icrop = new mikroklimat.Classes.imgCrop(ref img);
string s_name_path = "/Content/img/small_" + pr.id + "_" + Guid.NewGuid() + pic_ext[i];
//Image new_img = bm;
img.Save(Server.MapPath(s_name_path));
image db_img = new image();
db_img.path = name_path;
db_img.small_img_path = s_name_path;
db_img.project_id = pr.id;
db_c.mde.image.Add(db_img);
db_c.mde.SaveChanges();
}
}
}
return(Json(new EmptyResult(), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Creates a new project with given properties.
/// Adds the new project to the database and sets it as active project.
/// </summary>
protected void CreateNewProject(string projectName, string projectDesc, string githubUser, string githubRepo)
{
try
{
project newProject = new project
{
name = projectName,
description = projectDesc,
github_username = githubUser,
github_reponame = githubRepo
};
// Add project to DB
if (!Database.AddProject(newProject))
{
lblMessages.Text = "Project named '" + newProject.name + "' already exists!";
}
// Add project to currently logged in user
if (Session["LoggedUser"] != null)
{
string loggedUser = Session["LoggedUser"].ToString();
Database.AddProjectToUser(loggedUser, newProject.id);
}
// Make the user admin of the project
if (Session["LoggedUserId"] != null)
{
int userId = Convert.ToInt32(Session["LoggedUserId"]);
Database.AddRoleForUserToProject("admin", userId, newProject.id);
}
// User wants project to be public -> add it to default-user
if (!cbPrivateProject.Checked)
{
Database.AddProjectToUser("Default", newProject.id);
}
Session["ActiveProject"] = newProject.id;
Response.Redirect("Home.aspx", true);
}
catch (Exception ex)
{
lblMessages.Text = ex.Message;
}
}
// delete
public project delete(int id)
{
if (!(checkRight(main.Enums.rights.deleteProject)))
{
throw new serviceException("Bu projeyi silmeye yetkiniz bulunmamaktadır.");
}
project project = get(id);
if (project == null)
{
throw new serviceException("Boyle bir proje bulunamadı");
}
project.isdeleted = true;
_context.Entry(project).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(project);
}
public ActionResult Index(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var project_equipment = db.project_equipment.Include(pe => pe.project).Include(pe => pe.equipment).Where(pe => pe.projectID == id).ToList();
if (project_equipment == null)
{
return(HttpNotFound());
}
ViewBag.ID = id;
project pr = db.projects.Find(id);
if (pr.executorID != null)
{
ViewBag.ExecutorName = pr.contact1.name;
ViewBag.ExecutorLastname = pr.contact1.lastname;
}
if (pr.placeID != null)
{
ViewBag.Place = pr.place.name;
}
if (pr.start != null)
{
ViewBag.Start = @Convert.ToDateTime(pr.start).ToString("dd.MM.yyyy hh:mm");
}
if (Request.Cookies.Get("id") != null)
{
if (((FormsIdentity)User.Identity).Ticket.UserData == "admin" || pr.createrID == null || pr.createrID.ToString() == Request.Cookies.Get("id").Value)
{
ViewBag.Hide = "no";
}
else
{
ViewBag.Hide = "yes";
}
}
else
{
ViewBag.Hide = "yes";
}
return(View(project_equipment));
}
public ActionResult Edit(int id, project p)
{
if (!ModelState.IsValid)
{
return(EditDetails());
}
if (ModelState.IsValid)
{
Pservice.Update(p);
Pservice.commit();
Pservice.Dispose();
return(RedirectToAction("Index"));
}
return(View(p));
}
public project Save(project project)
{
Project proj = new Project();
proj = _itemRepository.GetById((int)project.ProjectId);
if (proj == null)
{
Project newProject = new Project();
newProject.Name = project.Name;
newProject.Code = project.Code;
newProject.CreatedByUserId = 2;
newProject.CreatedDateTime = DateTime.UtcNow;
newProject.CustomerId = project.CustomerId;
newProject.Description = project.Description;
newProject.EndDate = DateTime.Parse(project.EndDate);
newProject.LastModifiedByUserId = 2;
newProject.LastModifiedDateTime = DateTime.UtcNow;
newProject.ModelId = project.ModelId;
newProject.State = project.State;
newProject.Status = 1;
newProject.TechnologyId = project.TechnologyId;
newProject.ProposalId = project.ProposalId;
newProject.StartDate = DateTime.Parse(project.StartDate);
_itemRepository.Add(newProject);
}
else
{
proj.Name = project.Name;
proj.Code = project.Code;
proj.CreatedByUserId = project.CreatedByUserId;
proj.CustomerId = project.CustomerId;
proj.Description = project.Description;
proj.EndDate = DateTime.Parse(project.EndDate);
proj.LastModifiedByUserId = project.LastModifiedByUserId;
proj.LastModifiedDateTime = DateTime.UtcNow;
proj.ModelId = project.ModelId;
proj.State = project.State;
proj.Status = 1;
proj.TechnologyId = project.TechnologyId;
proj.ProposalId = project.ProposalId;
proj.StartDate = DateTime.Parse(project.StartDate);
_itemRepository.Update(proj);
}
return(project);
}
public ActionResult Edit(int id)
{
project cls = null;
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("http://localhost:18080");
HttpResponseMessage response = client.GetAsync("http://localhost:18080/MapLevio-web/rest/projets/" + id.ToString()).Result;
if (response.IsSuccessStatusCode)
{
cls = response.Content.ReadAsAsync <project>().Result;
}
return(View(cls));
}
public void ProcessRequest(HttpContext context)
{
//string tea= context.Response[""]
project project = new project()
{
teacher_num = context.Request["tea_num"]
};
StringBuilder jsonStr = new StringBuilder();
jsonStr.Append("[");
DataSet ds = BLL.stuBll.tea_select_project(project);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
jsonStr.Append("{");
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
if (j != ds.Tables[0].Columns.Count - 1)
{
jsonStr.Append("\"" + ds.Tables[0].Columns[j].ToString() + "\":\"" + ds.Tables[0].Rows[i][j].ToString() + "\",");
}
else
{
if (i == ds.Tables[0].Rows.Count - 1)
{
jsonStr.Append("\"" + ds.Tables[0].Columns[j].ToString() + "\":\"" + ds.Tables[0].Rows[i][j].ToString() + "\"}");
}
else
{
jsonStr.Append("\"" + ds.Tables[0].Columns[j].ToString() + "\":\"" + ds.Tables[0].Rows[i][j].ToString() + "\"},");
}
}
}
}
jsonStr.Append("]");
context.Response.ContentType = "text/plain";
context.Response.Write(jsonStr.ToString());
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("");
}
}
public static List <MembershipUser> GetProjectManagers(project this_project)
{
List <MembershipUser> managers = new List <MembershipUser>();
List <projects_user> project_managers = (from project_user in bug_tracker.projects_users
join user in bug_tracker.aspnet_Users on project_user.user_id equals user.UserId
join user_role in bug_tracker.aspnet_UsersInRoles on user.UserId equals user_role.UserId
join roles in bug_tracker.aspnet_Roles on user_role.RoleId equals roles.RoleId
where project_user.project_id == this_project.id && roles.RoleName == "Project Manager"
select project_user).Distinct().ToList();
foreach (projects_user manager in project_managers)
{
managers.Add(Membership.GetUser(manager.user_id));
}
return(managers);
}
private void btnDelete_Click(object sender)
{
try
{
if (MessageBox.Show("Are you sure want to Delete?", "Cognitivo", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
project project = (project)ProjectDataGrid.SelectedItem;
project.is_head = false;
project.State = EntityState.Deleted;
project.IsSelected = true;
}
}
catch (Exception ex)
{
toolBar.msgError(ex);
}
}
public string DelProject(ProjectDto projectDto) //Aldığı projectDto yla eşleşen projeyi silen servis.
{
using (UnitOfWorkPattern unitOf = new UnitOfWorkPattern())
{
project pr = unitOf.RepositoryPattern <project>().Get(projectDto.Id); // Id ile eşleşen project tipinde dönen veri
if (pr != null) //eğer yukarıdaki satırda uygun eşleşme bulunamazsa delete işlemi yapılmaz.Else satırına düşer.
{
unitOf.RepositoryPattern <project>().Delete(pr); //Delete işlemi.
unitOf.Save(); //Delete işlemi kayıt kısmı.
return("Kayıt silindi");
}
else
{
return("Kayıt bulunamadı");
}
}
}
private static List <projectDetails> getProjects(inputs theInputs)
{
// get all the projects in the org
string url = $"https://dev.azure.com/{theInputs.Org}/_apis/projects?api-version=5.1";
string response = RunGetAPI(theInputs.Pat, url);
if (!string.IsNullOrEmpty(response))
{
project ret = JsonConvert.DeserializeObject <project>(response);
return(ret.value);
}
else
{
return(null);
}
}
public void test_NewProjectPostShouldReturnProjectResource()
{
project project = new project {
name = "test",
active = true,
bill_by = "none",
client_id = 0,
code = "999",
notes = "test notes",
budget = 100,
budget_by = "none"
};
var result = harvest.CreateNewProject(project);
Assert.IsNotNull(result);
Assert.IsTrue(result);
Assert.IsInstanceOfType(result, typeof(bool));
}
partial void Insertproject(project instance);
// 数据绑定
private void RptBind()
{
HyCommon HyCommon = new HyCommon();
//获取当前页数
if (this.Request.QueryString["page"] != null)
{
this.page = int.Parse(HyCommon.Filter(this.Request.QueryString["page"].ToString()));
}
this.txtPageNum.Text = this.pageSize.ToString();
project dtExpert = new project();
string strWhere = "";
if (this.txtNmae.Text.Trim() != "")
{
strWhere += " and projectNmae like '%" + this.txtNmae.Text.Trim() + "%'";
}
//获取数据
DataSet dt = dtExpert.GetDataPage(this.pageSize, this.page, strWhere);
//获取数据条数
this.totalCount = dtExpert.GetList(strWhere).Tables[0].Rows.Count;
this.lblcount.Text = totalCount.ToString();
rptList.DataSource = dt;
rptList.DataBind();
//地址传递数据
string pageUrl = HyCommon.CombUrlTxt(ls_url, "page={0}&rnd={1}&txtNmae={2}", "__id__", System.Guid.NewGuid().ToString(), this.txtNmae.Text);
PageContent.InnerHtml = HyCommon.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void butSave_Click_1(object sender, EventArgs e)
{
//http://207.46.16.248/en-us/library/MySql.Data.MySqlClient.sqlclientmetadatacollectionnames_fields%28VS.100%29.aspx
//return DialogResult.OK;
// search metadata...
Thread t = new Thread(new ParameterizedThreadStart(search));
// we need to pass data through object
//project pro = new project();
if (pr == null)
pr = new project();
pr.name = txtName.Text;
pr.host = txtHost.Text;
pr.database = txtDatabase.Text;
pr.user = txtUser.Text;
pr.password = txtPassword.Text;
pr.dbDataType = (project.databaseType)cmbDataType.SelectedItem;
//project.databaseType tipo = new project.databaseType();
//tipo = (project.databaseType)cmbDataType.SelectedItem;
//pro.dbDataType = cmbDataType.SelectedItem;
// clear data
pr.tables.Clear();
pr.relations.Clear();
t.Start(pr);
// this.DialogResult = DialogResult.Yes;
//MessageBox.Show("Hand message", "Hand title", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
/// <summary>
/// Loads a project into the tree view
/// </summary>
/// <param name="Dir"></param>
private void LoadProject(DirectoryInfo Dir)
{
// Create new listItem
SPListItem d = AddItem(Dir.Name,new Uri( "spotdev:project:"+Dir.Name+":overview"));
d.Icon = Resources.spotifyapp;
String path = "";
ListDirectory(Dir.Name, Dir, d, ref path);
project c = new project();
c.title = Dir.Name;
c.identifier = Dir.Name;
projects.Add(c);
}
public void saveProject(string filename)
{
try
{
// Create an instance of the XmlSerializer class;
// specify the type of object to serialize.
XmlSerializer serializer = new XmlSerializer(typeof(project));
TextWriter writer = new StreamWriter(filename);
project po = new project();
po = this;
// Serialize and close the TextWriter.
serializer.Serialize(writer, po);
writer.Close();
}
catch (Exception ex)
{
throw;
}
}
private void Form1_FormClosed(object sender, FormClosedEventArgs e)
{
try
{
project pr = new project();
pr = general.actualProject;
pr.templateSelectedFullUri = general.templateSelectedFullUri;
String tableSelected = cmbTablesx.Text;
foreach (table item in general.actualProject.tables)
{
string numberoffields = item.fields.Count.ToString();
if (item.Name.Equals(tableSelected))
pr.actualTable = item;
}
//confi.actualTable = actualTable;
pr.templateSelected = general.templateSelected;
pr.templateSelectedFullUri = general.templateSelectedFullUri;
pr.targetDirectory = general.targetDirectory;
// save the project template from the listbox
if (lbProjectTemplate.Items.Count != 0 )
{
string pt = lbProjectTemplate.SelectedItem.ToString();
foreach (projectconfigfiles item in ctes.listaProjectConfigFiles)
{
if (item.Name == pt)
{
pr.projectTemplatesDirectory = item.Directory;
}
}
pr.projectTemplatesDirectorySmall = pt;
}
//pr.projectTemplatesDirectory = general.projectTemplateSelectedFullUri;
//pr.projectTemplatesDirectorySmall = general.projectTemplateSelected;
pr.saveProject(Path.Combine(util.conf_dir, "conf.xml"));
pr.saveProject(Path.Combine(util.projects_dir, general.actualProject.name) + ".xml");
}
catch (Exception)
{
//throw;
}
}
partial void Deleteproject(project instance);
partial void Updateproject(project instance);
protected void btn_save_Click(object sender, EventArgs e)
{
project project = new project();
project.id = System.Guid.NewGuid().ToString();
project.projectNmae = this.txtName.Value;
project.investorID = "";
project.inveestorNmae = "";
project.publishID = "";
project.publishName = "";
project.publishTime = DateTime.Now;
project.projectAdress = this.txtPath.Value;
project.projcetSummary = this.txtDetail.Value;
project.projcetKeyword = this.txtKeyWords.Value;
string strCheckValue = "";
if (getCheckBox(this.ck_net) != "")
{
strCheckValue += getCheckBox(this.ck_net) + "#";
}
if (getCheckBox(this.ck_move) != "")
{
strCheckValue += getCheckBox(this.ck_move) + "#";
}
if (getCheckBox(this.ck_medicene) != "")
{
strCheckValue += getCheckBox(this.ck_medicene) + "#";
}
if (getCheckBox(this.ck_finance) != "")
{
strCheckValue += getCheckBox(this.ck_finance) + "#";
}
if (getCheckBox(this.ck_education) != "")
{
strCheckValue += getCheckBox(this.ck_education) + "#";
}
if (getCheckBox(this.ck_equipment) != "")
{
strCheckValue += getCheckBox(this.ck_equipment) + "#";
}
if (getCheckBox(this.ck_furniture) != "")
{
strCheckValue += getCheckBox(this.ck_furniture) + "#";
}
if (getCheckBox(this.ck_energy) != "")
{
strCheckValue += getCheckBox(this.ck_energy) + "#";
}
if (getCheckBox(this.ck_agriculture) != "")
{
strCheckValue += getCheckBox(this.ck_agriculture) + "#";
}
if (getCheckBox(this.ck_others) != "")
{
strCheckValue += getCheckBox(this.ck_others) + "#";
}
project.industry = strCheckValue;
project.projectDetail = this.txtProjectDetail.Value;
project.financing = Convert.ToDecimal(this.txtAmount.Value);
project.phoneNumber = this.txtPhone.Value;
project.eamil = this.txtEmail.Value;
project.video = this.txtMoviePath.Value;
project.teamDetail = this.txtdt_summary.Value;
project.ifHot = false;
project.projectState = "发布";
project.Add();
Response.Write("<script>alert('发布项目成功！');</script>");
}
private void newProject_Load(object sender, EventArgs e)
{
pr = new project();
}
private void launcher_Load(object sender, EventArgs e)
{
// vemos si existe un conf.xml o ultimo proyecto utilizado...
project pr = new project();
pr = project.loadProject(Path.Combine(util.conf_dir, "conf.xml"));
if (pr != null)
{
general.actualProject = pr;
this.Text = "myWay " + pr.name;
}
loadControls();
}
// return the name of the keyField of the parent table from a foreign key
public table getFTByFK(project pr, string fieldName)
{
foreach (table item in pr.GetTables)
{
if (item.GetKey.ToLower().Equals(fieldName.ToLower()))
return item;
}
return null;
}
public IHttpActionResult Postproject(project project)
{
project.pdate = DateTime.Now;
project.employee_eid = q.GetUserId();
db.projects.Add(project);
db.SaveChanges();
project_messages pm = new project_messages();
pm.project_pid = project.pid;
pm.projectmessage = "*** Verkefni stofnað ***";
pm.messagetimestamp = DateTime.Now;
pm.employee_eid = q.GetUserId();
db.project_messages.Add(pm);
db.SaveChanges();
return CreatedAtRoute("DefaultApi", new { id = project.pid }, project);
}
private void search(object file)
{
bool right = false;
string errorMessage = "";
AsyncEnableButton(false);
try
{
project pro = new project();
pro = (project)file;
Cursor.Current = Cursors.WaitCursor;
switch (pro.dbDataType)
{
case project.databaseType.mySql:
String connectionString = null;
connectionString = "Server=" + pr.host + ";Database=" + pr.database + ";Uid=" + pr.user + ";Pwd=" + pr.password + ";";
dbMySql db = new dbMySql();
errorMessage = db.test(connectionString);
if (errorMessage.Equals(""))
{
AsyncWrite("");
AsyncWriteLine("Success connection \n");
//pr = new project();
//pr.name = pr.name;
// lets get the tables...
List<table> lista = new List<table>();
lista = db.getTables(connectionString, pr.database);
//lista.Sort();
pr.tables.Clear();
foreach (table item in lista)
{
AsyncWriteLine("Found table... " + item.Name + "\n");
// now lets get the fields for each table...
List<field> listaField = new List<field>();
listaField = db.getFields(connectionString, pr.database, item.Name);
if (listaField != null)
{
foreach (field fi in listaField)
{
item.fields.Add(fi);
AsyncWriteLine("Found field... " + fi.Name + "\n");
}
// the descriptionField its the first string field of table...
foreach (field campito in listaField)
{
if (campito.type.ToString().Equals("_string") || campito.type.ToString().Equals("_text"))
{
item.fieldDescription = campito.Name;
break;
}
}
if (item.fieldDescription == null)
item.fieldDescription = listaField[0].Name;
}
// lets get primary keys and foreign keys for the table...
db.getKeys(connectionString, item, pr.database);
// lets sort the fields in the table...
// we order but put first key fields
if (general.orderFields)
{
item.fields.Sort(new compareFields(compareFields.CompareByOptions.name));
item.fields.Sort(new compareFields(compareFields.CompareByOptions.key));
}
pr.tables.Add(item);
}
pr.tables.Sort();
//// now lets get the relations ...
pr.relations.Clear();
List<relation> listarelation = new List<relation>();
listarelation = db.getRelations(connectionString, pr.database);
if (listarelation != null)
{
foreach (relation re in listarelation)
{
// found description of fields...
foreach (table item in pr.tables)
{
if (item.Name.ToLower().Equals(re.childTable.ToLower()))
{
re.childDescription = item.fieldDescription;
// we put the field as keyfield...
foreach (field fi in item.fields)
{
if (fi.Name.ToLower().Equals(re.childField.ToLower()))
fi.isForeignKey = true;
}
}
if (item.Name.ToLower().Equals(re.parentTable.ToLower()))
re.parentDescription = item.fieldDescription;
}
if (!pr.existsRelation(re.parentTable, re.childTable))
{
pr.relations.Add(re);
AsyncWriteLine("Found relation... " + re.name + "\n");
}
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
// we put the relation in the child table...
if (item.Name.ToLower().Equals(re.childTable.ToLower()))
item.relations.Add(re);
}
}
}
// also we can get relations about the field names
foreach (table tab in pr.tables)
{
foreach (field campo in tab.fields)
{
if (campo.isKey)
{
foreach (table tab2 in pr.tables)
{
if (!tab.Name.ToLower().Equals(tab2.Name.ToLower()))
{
foreach (field campo2 in tab2.fields)
{
if (campo.Name.ToLower().Equals(campo2.Name.ToLower()))
{
// check if relation exists..
if (!pr.existsRelation(tab.Name, tab2.Name))
{
campo2.isForeignKey = true;
relation rel = new relation();
rel.name = tab2.Name + "_" + tab.Name;
bool found = false;
foreach (relation relax in pr.relations)
{
if (relax.name.Equals(rel.name))
found = true;
}
if (!found)
{
rel.parentTable = tab.Name;
rel.parentField = campo.Name;
rel.childTable = tab2.Name;
rel.childField = campo2.Name;
// found description of fields...
foreach (table item in pr.tables)
{
if (item.Name.ToLower().Equals(rel.childTable.ToLower()))
rel.childDescription = item.fieldDescription;
if (item.Name.ToLower().Equals(rel.parentTable.ToLower()))
rel.parentDescription = item.fieldDescription;
}
pr.relations.Add(rel);
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
if (item.Name.Equals(tab2.Name))
item.relations.Add(rel);
}
}
}
}
}
}
}
}
}
}
right = true;
pr.host = pro.host;
pr.database = pro.database;
pr.user = pro.user;
pr.password = pro.password;
pr.dbDataType = pro.dbDataType;
//pr.saveProject(Path.Combine(util.projects_dir, pro.name + ".xml"));
// lets save it for next load of application...
// pr.saveProject(Path.Combine(util.projects_dir, "conf.xml"));
// AsyncWriteLine("Project saved... \n");
}
else
{
AsyncWrite(errorMessage);
}
break;
case project.databaseType.SqlServer:
connectionString = "Data Source=" + pro.host + ";Network Library=DBMSSOCN;Initial Catalog=" + pro.database + ";User ID=" + pro.user + ";Password="******";";
// connectionStringOleDb = "Provider=SQLNCLI;Server=" + txtHost.Text + ";Database=" + txtDatabase.Text + ";Uid=" + txtUser.Text + ";Pwd=" + txtPassword.Text + ";";
dbSql2005 dbSqlServer = new dbSql2005();
errorMessage = dbSqlServer.test(connectionString);
if (errorMessage.Equals(""))
{
AsyncWrite("");
AsyncWriteLine("Success connection \n");
//pr = new project();
//pr.name = pro.name;
// lets get the tables...
List<table> lista = new List<table>();
lista = dbSqlServer.getTables(connectionString, pro.database);
//lista.Sort();
foreach (table item in lista)
{
AsyncWriteLine("Found table... " + item.Name + "\n");
// now lets get the fields for each table...
List<field> listaField = new List<field>();
listaField = dbSqlServer.getFields(connectionString, item.Name);
if (listaField != null)
{
foreach (field fi in listaField)
{
item.fields.Add(fi);
AsyncWriteLine("Found field... " + fi.Name + "\n");
}
// the descriptionField its the first string field of table...
foreach (field campito in listaField)
{
if (campito.type.ToString().Equals("_string") || campito.type.ToString().Equals("_text"))
{
item.fieldDescription = campito.Name;
break;
}
}
if (item.fieldDescription == null)
item.fieldDescription = listaField[0].Name;
}
// lets get primary keys and foreign keys for the table...
dbSqlServer.getKeys(connectionString, item);
// lets get not primary keys
foreach (field campito in item.fields)
{
if (!campito.isKey)
item.getNotKeyFields.Add(campito);
}
// lets sort the fields in the table...
// we order but put first key fields
if (general.orderFields)
{
item.fields.Sort(new compareFields(compareFields.CompareByOptions.name));
item.fields.Sort(new compareFields(compareFields.CompareByOptions.key));
}
pr.tables.Add(item);
// lets get description of table
string DescriptionOfTable = "";
DescriptionOfTable = dbSqlServer.getCommentsFromTable(connectionString, item.Name);
if (DescriptionOfTable.IndexOf("#exclude#") != -1)
{
item.excludeFromGeneration = true;
DescriptionOfTable.Replace("#exclude#", "");
}
if (!DescriptionOfTable.Equals(""))
item.TargetName = DescriptionOfTable;
// end of description for table
}
pr.tables.Sort();
// now lets get the relations ...
List<relation> listarelation = new List<relation>();
listarelation = dbSqlServer.getRelations(connectionString);
if (listarelation != null)
{
foreach (relation re in listarelation)
{
// item.fields.Add(re);
pr.relations.Add(re);
AsyncWriteLine("Found relation... " + re.name + "\n");
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
// we put the relation in the parent table...
if (item.Name.ToLower().Equals(re.parentTable.ToLower()))
{
// le añadimos la descripcion
re.parentDescription = item.fieldDescription;
foreach (table taby in pr.tables)
{
if (taby.Name.Equals(re.childTable))
re.childDescription = taby.fieldDescription;
}
item.relations.Add(re);
}
}
}
}
// also we can get relations about the field names
foreach (table tab in pr.tables)
{
foreach (field campo in tab.fields)
{
if (campo.isKey)
{
foreach (table tab2 in pr.tables)
{
if (!tab.Name.ToLower().Equals(tab2.Name.ToLower()))
{
foreach (field campo2 in tab2.fields)
{
if (campo.Name.ToLower().Equals(campo2.Name.ToLower()))
{
campo2.isForeignKey = true;
relation rel = new relation();
rel.name = tab.Name + "_" + tab2.Name;
if (!pr.relations.Contains(rel.name))
{
rel.parentTable = tab2.Name;
rel.parentField = campo2.Name;
rel.childTable = tab.Name;
rel.childField = campo.Name;
// found description of fields...
foreach (table item in pr.tables)
{
if (item.Name.ToLower().Equals(rel.childTable.ToLower()))
rel.childDescription = item.fieldDescription;
if (item.Name.ToLower().Equals(rel.parentTable.ToLower()))
rel.parentDescription = item.fieldDescription;
}
pr.relations.Add(rel);
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
if (item.Name.Equals(tab2.Name))
{
// see if the relation exists..
bool seguir = true;
foreach (relation rel2 in tab2.relations)
{
if (rel2.name.ToLower().Equals(rel.name.ToLower()))
seguir = false;
}
if (seguir)
item.relations.Add(rel);
}
}
}
}
}
}
}
}
}
}
right = true;
pr.host = pro.host;
pr.database = pro.database;
pr.user = pro.user;
pr.password = pro.password;
pr.dbDataType = pro.dbDataType;
//pr.saveProject(Path.Combine(util.projects_dir, pro.name + ".xml"));
// lets save it for next load of application...
// pr.saveProject(Path.Combine(util.projects_dir, "conf.xml"));
//AsyncWriteLine("Project saved... \n");
}
else
{
AsyncWrite(errorMessage);
}
break;
case project.databaseType.dbf:
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pro.database + ";Extended Properties=dBASE IV;User ID=" + pro.user + ";Password="******";";
dbDbf dbf = new dbDbf();
errorMessage = dbf.test(connectionString);
if (errorMessage.Equals(""))
{
AsyncWrite("");
AsyncWriteLine("Success connection \n");
//pr = new project();
//pr.name = pro.name;
// lets get the tables...
List<table> lista = new List<table>();
lista = dbf.getTables(connectionString, pro.database);
//lista.Sort();
foreach (table item in lista)
{
AsyncWriteLine("Found table... " + item.Name + "\n");
// now lets get the fields for each table...
List<field> listaField = new List<field>();
listaField = dbf.getFields(connectionString, item.Name);
if (listaField != null)
{
foreach (field fi in listaField)
{
item.fields.Add(fi);
AsyncWriteLine("Found field... " + fi.Name + "\n");
}
// the descriptionField its the first string field of table...
foreach (field campito in listaField)
{
if (campito.type.ToString().Equals("_string") || campito.type.ToString().Equals("_text"))
{
item.fieldDescription = campito.Name;
break;
}
}
if (item.fieldDescription == null)
item.fieldDescription = listaField[0].Name;
}
// lets get primary keys and foreign keys for the table...
dbf.getKeys(connectionString, item);
// lets sort the fields in the table...
// we order but put first key fields
if (general.orderFields)
{
item.fields.Sort(new compareFields(compareFields.CompareByOptions.name));
item.fields.Sort(new compareFields(compareFields.CompareByOptions.key));
}
pr.tables.Add(item);
}
pr.tables.Sort();
// now lets get the relations ...
List<relation> listarelation = new List<relation>();
listarelation = dbf.getRelations(connectionString);
if (listarelation != null)
{
foreach (relation re in listarelation)
{
// item.fields.Add(re);
pr.relations.Add(re);
AsyncWriteLine("Found relation... " + re.name + "\n");
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
// we put the relation in the parent table...
if (item.Name.ToLower().Equals(re.parentTable.ToLower()))
{
// le añadimos la descripcion
re.parentDescription = item.fieldDescription;
foreach (table taby in pr.tables)
{
if (taby.Name.Equals(re.childTable))
re.childDescription = taby.fieldDescription;
}
item.relations.Add(re);
}
}
}
}
// also we can get relations about the field names
foreach (table tab in pr.tables)
{
foreach (field campo in tab.fields)
{
if (campo.isKey)
{
foreach (table tab2 in pr.tables)
{
if (!tab.Name.ToLower().Equals(tab2.Name.ToLower()))
{
foreach (field campo2 in tab2.fields)
{
if (campo.Name.ToLower().Equals(campo2.Name.ToLower()))
{
campo2.isForeignKey = true;
relation rel = new relation();
rel.name = tab.Name + "_" + tab2.Name;
if (!pr.relations.Contains(rel.name))
{
rel.parentTable = tab2.Name;
rel.parentField = campo2.Name;
rel.childTable = tab.Name;
rel.childField = campo.Name;
// found description of fields...
foreach (table item in pr.tables)
{
if (item.Name.ToLower().Equals(rel.childTable.ToLower()))
rel.childDescription = item.fieldDescription;
if (item.Name.ToLower().Equals(rel.parentTable.ToLower()))
rel.parentDescription = item.fieldDescription;
}
pr.relations.Add(rel);
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
if (item.Name.Equals(tab2.Name))
{
// see if the relation exists..
bool seguir = true;
foreach (relation rel2 in tab2.relations)
{
if (rel2.name.ToLower().Equals(rel.name.ToLower()))
seguir = false;
}
if (seguir)
item.relations.Add(rel);
}
}
}
}
}
}
}
}
}
}
right = true;
pr.host = pro.host;
pr.database = pro.database;
pr.user = pro.user;
pr.password = pro.password;
pr.dbDataType = pro.dbDataType;
}
else
{
AsyncWriteLine(errorMessage);
}
break;
case project.databaseType.access2003:
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pro.database + ";User ID=" + pro.user + ";Password="******";";
dbAccess dba2003 = new dbAccess();
errorMessage = dba2003.test(connectionString);
if (errorMessage.Equals(""))
{
AsyncWrite("");
AsyncWriteLine("Success connection \n");
//pr = new project();
//pr.name = pro.name;
// lets get the tables...
List<table> lista = new List<table>();
lista = dba2003.getTables(connectionString, pro.database);
//lista.Sort();
foreach (table item in lista)
{
AsyncWriteLine("Found table... " + item.Name + "\n");
// now lets get the fields for each table...
List<field> listaField = new List<field>();
listaField = dba2003.getFields(connectionString, item.Name);
if (listaField != null)
{
foreach (field fi in listaField)
{
item.fields.Add(fi);
AsyncWriteLine("Found field... " + fi.Name + "\n");
}
}
// lets get primary keys and foreign keys for the table...
dba2003.getKeys(connectionString, item);
// now we search a text field that is not key
if (listaField != null)
{
// the descriptionField its the first string field of table...
foreach (field campito in listaField)
{
if (campito.type.ToString().Equals("_string") && !campito.isKey)
{
item.fieldDescription = campito.Name;
break;
}
}
}
if (item.fieldDescription == null)
item.fieldDescription = item.GetKey;
// lets sort the fields in the table...
// we order but put first key fields
if (general.orderFields)
{
item.fields.Sort(new compareFields(compareFields.CompareByOptions.name));
item.fields.Sort(new compareFields(compareFields.CompareByOptions.key));
}
pr.tables.Add(item);
}
pr.tables.Sort();
// now lets get the relations ...
List<relation> listarelation = new List<relation>();
listarelation = dba2003.getRelations(connectionString);
if (listarelation != null)
{
foreach (relation re in listarelation)
{
// item.fields.Add(re);
pr.relations.Add(re);
AsyncWriteLine("Found relation... " + re.name + "\n");
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
// we put the relation in the parent table...
if (item.Name.ToLower().Equals(re.parentTable.ToLower()))
{
// le añadimos la descripcion
re.parentDescription = item.fieldDescription;
foreach (table taby in pr.tables)
{
if (taby.Name.Equals(re.childTable))
re.childDescription = taby.fieldDescription;
}
item.relations.Add(re);
}
}
}
}
// also we can get relations about the field names
foreach (table tab in pr.tables)
{
foreach (field campo in tab.fields)
{
if (campo.isKey)
{
foreach (table tab2 in pr.tables)
{
if (!tab.Name.ToLower().Equals(tab2.Name.ToLower()))
{
foreach (field campo2 in tab2.fields)
{
if (campo.Name.ToLower().Equals(campo2.Name.ToLower()))
{
campo2.isForeignKey = true;
relation rel = new relation();
rel.name = tab.Name + "_" + tab2.Name;
if (!pr.relations.Contains(rel.name))
{
rel.parentTable = tab2.Name;
rel.parentField = campo2.Name;
rel.childTable = tab.Name;
rel.childField = campo.Name;
// found description of fields...
foreach (table item in pr.tables)
{
if (item.Name.ToLower().Equals(rel.childTable.ToLower()))
rel.childDescription = item.fieldDescription;
if (item.Name.ToLower().Equals(rel.parentTable.ToLower()))
rel.parentDescription = item.fieldDescription;
}
pr.relations.Add(rel);
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
if (item.Name.Equals(tab2.Name))
{
// see if the relation exists..
bool seguir = true;
foreach (relation rel2 in tab2.relations)
{
if (rel2.name.ToLower().Equals(rel.name.ToLower()))
seguir = false;
}
if (seguir)
item.relations.Add(rel);
}
}
}
}
}
}
}
}
}
}
right = true;
pr.host = pro.host;
pr.database = pro.database;
pr.user = pro.user;
pr.password = pro.password;
pr.dbDataType = pro.dbDataType;
}
else
{
AsyncWriteLine(errorMessage);
}
break;
case project.databaseType.access2007:
connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pro.database + ";Persist Security Info=False;";
//Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pro.database + ";Jet OLEDB:Database Password=MyDbPassword;
dbAccess dba2007 = new dbAccess();
errorMessage = dba2007.test(connectionString);
if (errorMessage.Equals(""))
{
AsyncWrite("");
AsyncWriteLine("Success connection \n");
//pr = new project();
//pr.name = pro.name;
// lets get the tables...
List<table> lista = new List<table>();
lista = dba2007.getTables(connectionString, pro.database);
//lista.Sort();
foreach (table item in lista)
{
AsyncWriteLine("Found table... " + item.Name + "\n");
// now lets get the fields for each table...
List<field> listaField = new List<field>();
listaField = dba2007.getFields(connectionString, item.Name);
if (listaField != null)
{
foreach (field fi in listaField)
{
item.fields.Add(fi);
AsyncWriteLine("Found field... " + fi.Name + "\n");
}
}
// lets get primary keys and foreign keys for the table...
dba2007.getKeys(connectionString, item);
// now we search a text field that is not key
if (listaField != null)
{
// the descriptionField its the first string field of table...
foreach (field campito in listaField)
{
if (campito.type.ToString().Equals("_string") || campito.type.ToString().Equals("_text") )
{
item.fieldDescription = campito.Name;
break;
}
}
}
if (item.fieldDescription == null)
item.fieldDescription = item.GetKey;
// lets sort the fields in the table...
// we order but put first key fields
if (general.orderFields)
{
item.fields.Sort(new compareFields(compareFields.CompareByOptions.name));
item.fields.Sort(new compareFields(compareFields.CompareByOptions.key));
}
pr.tables.Add(item);
}
pr.tables.Sort();
// now lets get the relations ...
List<relation> listarelation = new List<relation>();
listarelation = dba2007.getRelations(connectionString);
if (listarelation != null)
{
foreach (relation re in listarelation)
{
// item.fields.Add(re);
pr.relations.Add(re);
AsyncWriteLine("Found relation... " + re.name + "\n");
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
// we put the relation in the parent table...
if (item.Name.ToLower().Equals(re.parentTable.ToLower()))
{
// le añadimos la descripcion
re.parentDescription = item.fieldDescription;
foreach (table taby in pr.tables)
{
if (taby.Name.Equals(re.childTable))
re.childDescription = taby.fieldDescription;
}
item.relations.Add(re);
}
}
}
}
// also we can get relations about the field names
foreach (table tab in pr.tables)
{
foreach (field campo in tab.fields)
{
if (campo.isKey)
{
foreach (table tab2 in pr.tables)
{
if (!tab.Name.ToLower().Equals(tab2.Name.ToLower()))
{
foreach (field campo2 in tab2.fields)
{
if (campo.Name.ToLower().Equals(campo2.Name.ToLower()))
{
campo2.isForeignKey = true;
relation rel = new relation();
rel.name = tab.Name + "_" + tab2.Name;
if (!pr.relations.Contains(rel.name))
{
rel.parentTable = tab2.Name;
rel.parentField = campo2.Name;
rel.childTable = tab.Name;
rel.childField = campo.Name;
// found description of fields...
foreach (table item in pr.tables)
{
if (item.Name.ToLower().Equals(rel.childTable.ToLower()))
rel.childDescription = item.fieldDescription;
if (item.Name.ToLower().Equals(rel.parentTable.ToLower()))
rel.parentDescription = item.fieldDescription;
}
pr.relations.Add(rel);
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
if (item.Name.Equals(tab2.Name))
{
// see if the relation exists..
bool seguir = true;
foreach (relation rel2 in tab2.relations)
{
if (rel2.name.ToLower().Equals(rel.name.ToLower()))
seguir = false;
}
if (seguir)
item.relations.Add(rel);
}
}
}
}
}
}
}
}
}
}
right = true;
pr.host = pro.host;
pr.database = pro.database;
pr.user = pro.user;
pr.password = pro.password;
pr.dbDataType = pro.dbDataType;
}
else
{
AsyncWriteLine(errorMessage);
}
break;
// end of access2007
case project.databaseType.excelOrCsv:
if (pr.database.Contains("xls"))
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pr.database + ";Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";
else
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pr.database + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
dbExcelOrCsv dbaODBC = new dbExcelOrCsv();
errorMessage = dbaODBC.test(connectionString);
if (errorMessage.Equals(""))
{
AsyncWrite("");
AsyncWriteLine("Success connection \n");
//pr = new project();
//pr.name = pro.name;9
// lets get the tables...
List<table> lista = new List<table>();
lista = dbaODBC.getTables(connectionString, pr.database);
//lista.Sort();
foreach (table item in lista)
{
AsyncWriteLine("Found table... " + item.Name + "\n");
// now lets get the fields for each table...
List<field> listaField = new List<field>();
listaField = dbaODBC.getFields(connectionString, item.Name);
if (listaField != null)
{
foreach (field fi in listaField)
{
item.fields.Add(fi);
AsyncWriteLine("Found field... " + fi.Name + "\n");
}
}
// lets get primary keys and foreign keys for the table...
dbaODBC.getKeys(connectionString, item);
// now we search a text field that is not key
if (listaField != null)
{
// the descriptionField its the first string field of table...
foreach (field campito in listaField)
{
if (campito.type.ToString().Equals("_string") || campito.type.ToString().Equals("_text"))
{
item.fieldDescription = campito.Name;
break;
}
}
}
if (item.fieldDescription == null)
item.fieldDescription = item.GetKey;
// lets sort the fields in the table...
// we order but put first key fields
if (general.orderFields)
{
item.fields.Sort(new compareFields(compareFields.CompareByOptions.name));
item.fields.Sort(new compareFields(compareFields.CompareByOptions.key));
}
pr.tables.Add(item);
}
pr.tables.Sort();
// now lets get the relations ...
List<relation> listarelation = new List<relation>();
listarelation = dbaODBC.getRelations(connectionString);
if (listarelation != null)
{
foreach (relation re in listarelation)
{
// item.fields.Add(re);
pr.relations.Add(re);
AsyncWriteLine("Found relation... " + re.name + "\n");
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
// we put the relation in the parent table...
if (item.Name.ToLower().Equals(re.parentTable.ToLower()))
{
// le añadimos la descripcion
re.parentDescription = item.fieldDescription;
foreach (table taby in pr.tables)
{
if (taby.Name.Equals(re.childTable))
re.childDescription = taby.fieldDescription;
}
item.relations.Add(re);
}
}
}
}
// also we can get relations about the field names
foreach (table tab in pr.tables)
{
foreach (field campo in tab.fields)
{
if (campo.isKey)
{
foreach (table tab2 in pr.tables)
{
if (!tab.Name.ToLower().Equals(tab2.Name.ToLower()))
{
foreach (field campo2 in tab2.fields)
{
if (campo.Name.ToLower().Equals(campo2.Name.ToLower()))
{
campo2.isForeignKey = true;
relation rel = new relation();
rel.name = tab.Name + "_" + tab2.Name;
if (!pr.relations.Contains(rel.name))
{
rel.parentTable = tab2.Name;
rel.parentField = campo2.Name;
rel.childTable = tab.Name;
rel.childField = campo.Name;
// found description of fields...
foreach (table item in pr.tables)
{
if (item.Name.ToLower().Equals(rel.childTable.ToLower()))
rel.childDescription = item.fieldDescription;
if (item.Name.ToLower().Equals(rel.parentTable.ToLower()))
rel.parentDescription = item.fieldDescription;
}
pr.relations.Add(rel);
// now if the relation has to do with the tables...
foreach (table item in pr.tables)
{
if (item.Name.Equals(tab2.Name))
{
// see if the relation exists..
bool seguir = true;
foreach (relation rel2 in tab2.relations)
{
if (rel2.name.ToLower().Equals(rel.name.ToLower()))
seguir = false;
}
if (seguir)
item.relations.Add(rel);
}
}
}
}
}
}
}
}
}
}
right = true;
pr.host = pr.host;
pr.database = pr.database;
pr.user = pr.user;
pr.password = pr.password;
pr.dbDataType = pr.dbDataType;
}
else
{
AsyncWriteLine(errorMessage);
}
break;
// end of excelOrCsv
}
Cursor.Current = Cursors.Default;
switch (right)
{
case true:
AsyncWriteLine("All right. Now you can save the project...");
AsyncEnableButton(true);
SystemSounds.Exclamation.Play();
break;
case false:
AsyncWriteLine("Error, review the configuration.");
AsyncEnableButton(false);
//util.playSimpleSound(Path.Combine(util.sound_dir, "zasentodalaboca.wav"));
SystemSounds.Asterisk.Play();
break;
}
// we have finished with new project
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
AsyncWrite(ex.Message);
}
}
public IHttpActionResult Putproject(int id, project project)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != project.pid)
{
return BadRequest();
}
db.Entry(project).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!projectExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
// return the name of the parent table of a foreign key
public String getTableNameByForeignKey(project pr, string fieldName)
{
try
{
foreach (table item in pr.GetTables)
{
if (item.GetKey.ToLower().Equals(fieldName.ToLower()))
return item.Name;
}
}
catch (Exception ex)
{
throw;
}
return "";
}
private void Form1_Load(object sender, EventArgs e)
{
//diagram di = new diagram();
//di.ShowDialog();
//model ed = new model();
//ed.actualProject = actualProject;
//ed.ShowDialog();
//// para apañar templates antiguos...
//myWay.classes.fixTemplate fi = new myWay.classes.fixTemplate();
//fi.traverseDirectory("I:\\proyectos\\desktop\\myWay\\templates\\vb");
// para crear el control avalonEdit
// son necesarias las siguientes dll (copiadas del framework 3.0 la mayoria)
// ICSharpCode.AvalonEdit - PresentationCore - PresentationFramework - WindowsBase - WindowsFormsIntegration
ElementHost host = new ElementHost();
host.Name = "editor";
host.Dock = DockStyle.Fill;
TextEditor uc = new TextEditor();
uc.Options.IndentationSize = 4;
uc.Background = System.Windows.Media.Brushes.White;
uc.ShowLineNumbers = true;
uc.WordWrap = true;
IHighlightingDefinition highlightDefinition = HighlightingManager.Instance.GetDefinition("C#");
uc.SyntaxHighlighting = highlightDefinition;
host.Child = uc;
// in the constructor:
uc.TextArea.TextEntering += textEditor_TextArea_TextEntering;
uc.TextArea.TextEntered += textEditor_TextArea_TextEntered;
panel1.Controls.Add(host);
//this.Controls.Add(host);
// if there is a template selected early we load it..
if (general.templateSelectedFullUri != null)
{
// rt1.Text = util.loadFile(templateSelectedFullUri);
writeText(util.loadFile(general.templateSelectedFullUri));
}
string numberOfLinesWrittenBefore = sf.toLong(System.Configuration.ConfigurationManager.AppSettings["numberOfLinesWritten"]).ToString();
labNumberOfLinesWritten.Values.Text = sf.cadena(numberOfLinesWrittenBefore) + " lines written with myWay";
string labNumberOfAppsBefore = sf.toLong(System.Configuration.ConfigurationManager.AppSettings["labNumberOfAppsWritten"]).ToString();
labNumberOfApps.Values.Text = sf.cadena(labNumberOfAppsBefore) + " apps written with myWay";
// lets load config files of project templates ...
traverseDirectorySearchProjectConfigFiles(util.projectTemplates_dir);
foreach (projectconfigfiles item in ctes.listaProjectConfigFiles)
{
lbProjectTemplate.Items.Add(item.Name);
}
// vemos si existe un conf.xml o ultimo proyecto utilizado...
project pr = new project();
pr = project.loadProject(Path.Combine(util.conf_dir, "conf.xml"));
if (pr != null)
{
this.Text = "myWay " + pr.name;
groupBox1.Text = pr.name;
this.Text = "myWay " + pr.name;
general.actualProject = pr;
refreshDataWithActualProject();
}
}
//done button to insert values in database
protected void Btndone_Click(object sender, EventArgs e)
{
//here we are getting follow people values(asptokeninput) from ItemList.aspx page,it can be multiple so we are entering multiple values by '/'
for (int i = 0; i <= lbList2.Items.Count - 1; i++)
{
listid = lbList2.Items[i].Value.Split('-');
string name = listid[0];
eco += listid[0] + "/";
}
if (eco != "")
{
eco = eco.Remove(eco.Length - 1);
}
namesplit = LblFLName.Text.Split(' ');
if (p)
{
var pp = new product
{
FirstName = namesplit[0],
LastName=namesplit[1],
Password = Hiddpass.Value,
University = LblUni.Text,
Course = LblCourse.Text,
Year = LblYear.Text,
Location = LblCity.Text,
SuaveID = Label2.Text + TxtSuaveid.Text,
About = TxtAbout.Text,
FollowPpl = eco,
Project = TxtCreateproj.Text,
Emailid=TxtEmailid.Text
};
//inserting user details in table admin
var hh = a1.GetCollection<product>("admin");
hh.Insert(pp);
//here we are creating projectid,it is a combination of suaveid+first 3 letters of project name
proid = TxtCreateproj.Text.Substring(0,3);
var pp2 = new project
{
Project = TxtCreateproj.Text,
ProjectId=Label2.Text + TxtSuaveid.Text+proid,
SuaveID = Label2.Text + TxtSuaveid.Text
};
//inserting project details in table ProjectDet
var hh2 = a1.GetCollection<project>("ProjectDet");
hh2.Insert(pp2);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Alert", "alert('Inserted ');", true);
//here we move forward for dash board page by passing suaveid as a parameter
string su=Label2.Text + TxtSuaveid.Text;
Session["SuaveID"] = su;
Response.Redirect("Default.aspx");
TxtFirstname.Text = "";
Txtlastname.Text = "";
txtPwd.Text = "";
txtRePwd.Text = "";
TxtUniversity.Text = "";
TxtCourse.Text = "";
DdlYear.Items.Clear();
TxtLocation.Text = "";
TxtSuaveid.Text = "";
TxtAbout.Text = "";
tiTest2.Items.Clear();
TxtCreateproj.Text = "";
}
}
// return the name of the keyField of the parent table from a foreign key
public String getKeyFieldByForeignKey(project pr, string fieldName)
{
foreach (table item in pr.GetTables)
{
if (item.GetKey.ToLower().Equals(fieldName.ToLower()))
return item.GetKey;
}
return "";
}
private void saveData()
{
try
{
project pr = new project();
pr = general.actualProject;
//pr.templateSelectedFullUri = general.templateSelectedFullUri;
pr.targetDirectory = general.actualProject.targetDirectory;
// save the project template from the listbox
if (lbProjectTemplate.Items.Count != 0)
{
string pt = lbProjectTemplate.SelectedItem.ToString();
foreach (projectconfigfiles item in ctes.listaProjectConfigFiles)
{
if (item.Name == pt)
{
pr.projectTemplatesDirectory = item.Directory;
}
}
pr.projectTemplatesDirectorySmall = pt;
}
pr.saveProject(Path.Combine(util.conf_dir, "conf.xml"));
pr.saveProject(Path.Combine(util.projects_dir, general.actualProject.name) + ".xml");
}
catch (Exception)
{
//throw;
}
}
//private void cmbGoToCode_SelectedIndexChanged(object sender, EventArgs e)
//{
// string st = "";
// int numLinea = 0;
// st = cmbGoToCode.SelectedItem.ToString().Trim();
// // get the control of editor
// ElementHost pp = new ElementHost();
// TextEditor te = new TextEditor();
// pp = (ElementHost)panel1.Controls.Find("editor", true)[0];
// te = (TextEditor)pp.Child;
// foreach (ICSharpCode.AvalonEdit.Document.DocumentLine item in te.Document.Lines)
// {
// if (item.Text.IndexOf(st) != -1)
// {
// numLinea = item.LineNumber;
// }
// }
// te.ScrollTo(numLinea, 0);
//} // cmbGoToCode_SelectedIndexChanged
private void txtNameSpace_TextChanged(object sender, EventArgs e)
{
project pr = new project();
pr = general.actualProject;
pr.nameSpace = txtNameSpace.Text;
pr.saveProject(Path.Combine(util.conf_dir, "conf.xml"));
pr.saveProject(Path.Combine(util.projects_dir, general.actualProject.name) + ".xml");
}
