private void BindImages(int id)
{
try
{
DataTable dt = new DataTable();
ProjectsBLL objPro = new ProjectsBLL();
objPro.ID = id;
dt = objPro.GetPrtojects();
if (dt.Rows.Count > 0)
{
string thumbnail = dt.Rows[0]["project_images"].ToString();
if (thumbnail != "")
{
Session["ProjectImages"] = thumbnail;
string[] strImages = thumbnail.Split(',');
Array.Sort(strImages);
DataTable dtt = new DataTable("MyDataTable");
dtt.Columns.Add("project_images");
foreach (string value in strImages)
{
dtt.Rows.Add(value);
}
Repeater1.DataSource = dtt;
Repeater1.DataBind();
}
}
}
catch { }
}
protected void ProjectDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
if (ProjectDropDownList.SelectedIndex == 0)
{
EnablePhase(false);
PhaseDropDown.SelectedIndex = 0;
}
else
{
ProjectsBLL project = new ProjectsBLL();
TimeKeeper.ProjectsDataTable prj = project.GetProjectByProjectID(Convert.ToInt32(ProjectDropDownList.SelectedValue));
TimeKeeper.ProjectsRow prjRow = prj[0];
if (prjRow.PhaseID >= 0)
{
PhaseDropDown.SelectedValue = prjRow.PhaseID.ToString();
}
else
{
PhaseDropDown.SelectedValue = "None";
}
EnablePhase(true);
}
ScriptManager.SetFocus(ProjectDropDownList);
}
void ButtonSaveClick(object sender, EventArgs e)
{
//根据是修改还是新增确定操作
if (this.Text == "项目信息-新增")
{
//确定关闭窗口，将数据保存到数据库中
Projects tProject = new Projects();
tProject.ProjectName = textBoxProjectName.Text.Trim();
tProject.ProjectContractor = textBoxContractor.Text.Trim();
tProject.ProjectDeveloper = textBoxDevelpoer.Text.Trim();
tProject.ProjectAbstract = textBoxProjectAbstract.Text.Trim();
ProjectsBLL.AddProjects(tProject);
this.Close();
}
else
{
//确定关闭窗口，将数据修改后保存到数据库中
Projects tProject = new Projects();
tProject.ProjectID = i_ProjectID;
tProject.ProjectName = textBoxProjectName.Text.Trim();
tProject.ProjectContractor = textBoxContractor.Text.Trim();
tProject.ProjectDeveloper = textBoxDevelpoer.Text.Trim();
tProject.ProjectAbstract = textBoxProjectAbstract.Text.Trim();
ProjectsBLL.UpdateProjects(tProject);
this.Close();
}
BLL.ProjectsBLL.FillProjects();
}
private void btnAddProject_Click(object sender, EventArgs e)
{
ProjectsBLL.AddProject(new Project {
Id = Guid.NewGuid(), ProjectName = txtAddProject.Text
});
PnlAddProjectVissible(false);
Form1_Load(sender, e);
}
private void btnDeleteProject_Click(object sender, EventArgs e)
{
if (!timer1.Enabled)
{
DialogResult result = MessageBox.Show("Delete Project " + lstProjects.Text, "Delete Project ", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
var projectId = (Guid)lstProjects.SelectedValue;
ProjectsBLL.DeleteProperty(projectId);
Bind_lstProjects();
}
}
}
public ResponseDTO LoadProjects(APICredentials request)
{
ResponseDTO resp = new ResponseDTO();
using (ProjectManagementBLL objProjectManagementBLL = new ProjectManagementBLL())
{
try {
APICredentialsBLL credentialsBLL = new APICredentialsBLL();
credentialsBLL.UserName = request.APIUserName;
credentialsBLL.Password = request.APIPassword;
if (!new CommonMethods().ValidateRequest(credentialsBLL))
{
resp.ResponseCode = ResponseCodes.Failed;
resp.ResponseMessage = ResponseMessages.InvalidCredentials;
}
else
{
DataTable dtRecord = new ProjectsBLL().GetAllProjects(objProjectManagementBLL);
List <Projects> projects = new List <Projects>();
if (dtRecord.Rows.Count > 0)
{
foreach (DataRow row in dtRecord.Rows)
{
Projects proj = new Projects();
proj.ProjectID = int.Parse(row["ProjectID"].ToString());
proj.ProjectName = row["ProjectName"].ToString();
projects.Add(proj);
}
}
resp.ResponseCode = ResponseCodes.Success;
resp.ResponseMessage = ResponseMessages.Success;
resp.ResponseData = new ResponseData();
resp.ResponseData.projects = projects;
}
}
catch (Exception ex)
{
resp.ResponseCode = ResponseCodes.Failed;
resp.ResponseMessage = ex.Message;
}
}
return(resp);
}
private void Bind_lstProjects()
{
var projects = ProjectsBLL.GetProjects();
if (projects.Any())
{
lstProjects.DataSource = null;
lstProjects.DataSource = projects;
lstProjects.DisplayMember = "ProjectName";
lstProjects.ValueMember = "Id";
lstProjects.Enabled = true;
btnStartEnd.Enabled = true;
txtAddProject.Text = "";
pnlAddProject.Visible = false;
}
else
{
lstProjects.Enabled = false;
btnStartEnd.Enabled = false;
pnlAddProject.Visible = true;
}
}
protected int PullPrjBoard(bool PullActiveOnly, bool UpdateProjects)
{
string output = ""; //holds label output
int count = 0; //count of number of projects pulled, will return this value
Lists listService = new Lists();
ProjectsBLL project = new ProjectsBLL();
listService.PreAuthenticate = true;
listService.Credentials = System.Net.CredentialCache.DefaultCredentials;
XmlDocument xmlDoc = new XmlDocument();
XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element, "Query", "");
XmlNode ndViewFields = xmlDoc.CreateNode(XmlNodeType.Element, "ViewFields", "");
XmlNode ndQueryOptions = xmlDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "");
ndQueryOptions.InnerXml = "";// "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" + "<DateInUtc>TRUE</DateInUtc>";
ndViewFields.InnerXml = "";// "<FieldRef Name='Title'/><FieldRef Name='Column5'/><FieldRef Name='Column4'/><FieldRef Name='Completed'/><FieldRef Name='Column12'/><FieldRef Name='Project_x0020_Site_x0020_URL'/><FieldRef Name='Project_x0020_Manager2'/><FieldRef Name='IT_x0020_Technical_x0020_Lead'/><FieldRef Name='Project_x0020_Phase'/>";
//query XML with only completed items or all items?
if (PullActiveOnly)
ndQuery.InnerXml = "<Where><Eq><FieldRef Name='Completed'/><Value Type='Number'>0</Value></Eq></Where>";
else
ndQuery.InnerXml = "";
try
{
XmlNode ndListItems;
Hashtable prjHash = new Hashtable();
//call web service to get all the projects from the PMO Project Board
ndListItems = listService.GetListItems(PROJECT_BOARD_GUID, PROJECT_BOARD_VIEW_GUID, ndQuery, ndViewFields, null, ndQueryOptions);
//create xml document so we can process
XmlDocument doc = new XmlDocument();
doc.LoadXml(ndListItems.OuterXml);
foreach (XmlNode element in doc.ChildNodes[0].ChildNodes[0].ChildNodes)
{
if (element.Attributes != null)
{
foreach (XmlAttribute attr in element.Attributes)
{
switch (attr.Name)
{
//TODO: This will be different based on the fields in your SharePoint list.
case "ows_Title":
prjHash.Add("ProjectNumber", attr.Value);
break;
case "ows_NSR_x002f_Project_x0020_Name":
prjHash.Add("Name", attr.Value);
break;
case "ows_Completed":
//list contains 0 if not compeleted and -1 if completed
if (Convert.ToInt32(attr.Value) == 0)
prjHash.Add("Active", true);
else
prjHash.Add("Active", false);
break;
case "ows_Approved":
prjHash.Add("Approved", attr.Value);
break;
case "ows_Current_x0020_Status":
prjHash.Add("Status", attr.Value);
break;
case "ows_Project_x0020_Site_x0020_URL":
//list returns value as url,url. we only need it once, so using split we take the first one
prjHash.Add("SiteURL", attr.Value.Split(',')[0]);
break;
case "ows_Project_x0020_Manager":
prjHash.Add("ProjectManager", attr.Value.Split('#')[1]);
break;
case "ows_Project_x0020_Phase":
prjHash.Add("PhaseID", attr.Value);
break;
case "ows_ID":
//once the attribute equals "ows_ID" we know we can process
//setup some temp holders
int projectID = Convert.ToInt32(attr.Value);
string number = prjHash["ProjectNumber"].ToString();
string name = prjHash["Name"].ToString();
string projectManager;
if (prjHash.ContainsKey("ProjectManager"))
projectManager = prjHash["ProjectManager"].ToString();
else
projectManager = "";
string siteURL;
if (prjHash.ContainsKey("SiteURL"))
siteURL = prjHash["SiteURL"].ToString();
else
siteURL = null;
int phaseID;
if (prjHash.ContainsKey("PhaseID"))
{
switch (prjHash["PhaseID"].ToString())
{
case "Initiating":
phaseID = 0;
break;
case "Planning":
phaseID = 1;
break;
case "Execution":
phaseID = 2;
break;
case "Monitoring":
phaseID = 3;
break;
case "Closing":
phaseID = 4;
break;
case "Proposals":
phaseID = 5;
break;
case "Startups/Turndowns":
phaseID = 6;
break;
case "Startup":
phaseID = 7;
break;
case "Turndown":
phaseID = 8;
break;
case "Win-awaiting NTP":
phaseID = 9;
break;
default:
phaseID = -1;
break;
}
}
else
phaseID = -1;
bool active;
if (Convert.ToBoolean(prjHash["Active"]) && (prjHash["Approved"].ToString() == "Approved as Project" || prjHash["Approved"].ToString() == "NSR Analysis"))
active = true;
else
active = false;
//DEBUG PRINT
//output += "<tr><td>Debug: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
//first we check to see if this project already exists
if (project.ProjectIDExists(projectID) < 1)
{
output += "<tr><td>Adding: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
//add the project to the db, first checking to see if SiteURL exists and is not empty
if (prjHash.ContainsKey("SiteURL") && (string)prjHash["SiteURL"] != String.Empty)
project.AddProject(projectID, number, name, siteURL, active, phaseID, projectManager);
else
project.AddProject(projectID, number, name, null, active, phaseID, projectManager);
output += "<td>Complete!</td></tr>";
count++;
}
else
{
//otherwise the project already exists and we can update it
if (UpdateProjects)
{
TimeKeeper.ProjectsDataTable prj = project.GetProjectByProjectID(projectID);
TimeKeeper.ProjectsRow prjRow = prj[0];
//output += "<tr><td>Update - " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
//output += "<tr><td>active = " + active.ToString() + "</tr></td>";
//count++;
if (prjRow.Active != active)
{
//RUN DEACTIVATE PROJECT CODE HERE
if (active == false)
{
ProjectMembersBLL projectMembers = new ProjectMembersBLL();
int membersDeleted = projectMembers.DeleteProjectMembersByProjectID(projectID);
output += "<tr><td>Deactivating: " + number + " - " + name + ", Removed " + membersDeleted.ToString() + " member(s)</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
project.UpdateProject(projectID, number, name, null, false, phaseID, projectManager);
output += "<td>Complete!</td></tr>";
}
else
{
output += "<tr><td>Activating: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
project.UpdateProject(projectID, number, name, null, true, phaseID, projectManager);
output += "<td>Complete!</td></tr>";
}
count++;
}
if (prjRow.ProjectNumber != number || prjRow.Name != name || prjRow.PhaseID != phaseID || prjRow.ProjectManager.ToString() != projectManager)
{
//it does exist, print message
output += "<tr><td>Updating: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
if (prjHash.ContainsKey("SiteURL") && (string)prjHash["SiteURL"] != String.Empty)
{
project.UpdateProject(projectID, number, name, siteURL, active, phaseID, projectManager);
}
else
{
project.UpdateProject(projectID, number, name, null, active, phaseID, projectManager);
}
output += "<td>Complete!</td></tr>";
count++;
}
if (prjRow.IsTeamSiteURLNull() && prjHash.ContainsKey("SiteURL") && (string)prjHash["SiteURL"] != String.Empty)
{
//there is a new team site that we need to add
output += "<tr><td>Team Site added: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
project.UpdateProject(projectID, number, name, siteURL, active, phaseID, projectManager);
output += "<td>Complete!</td></tr>";
count++;
}
}
}
break;
}
}
}
//clear the hash for the next element
prjHash.Clear();
}
}
catch (System.Web.Services.Protocols.SoapException ex)
{
output = ex.StackTrace;
}
//set label
PullOutputLabel.Text = output;
return count;
}
protected int PullPrjBoard(bool PullActiveOnly, bool UpdateProjects)
{
string output = ""; //holds label output
int count = 0; //count of number of projects pulled, will return this value
Lists listService = new Lists();
ProjectsBLL project = new ProjectsBLL();
listService.PreAuthenticate = true;
listService.Credentials = System.Net.CredentialCache.DefaultCredentials;
XmlDocument xmlDoc = new XmlDocument();
XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element, "Query", "");
XmlNode ndViewFields = xmlDoc.CreateNode(XmlNodeType.Element, "ViewFields", "");
XmlNode ndQueryOptions = xmlDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "");
ndQueryOptions.InnerXml = ""; // "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" + "<DateInUtc>TRUE</DateInUtc>";
ndViewFields.InnerXml = ""; // "<FieldRef Name='Title'/><FieldRef Name='Column5'/><FieldRef Name='Column4'/><FieldRef Name='Completed'/><FieldRef Name='Column12'/><FieldRef Name='Project_x0020_Site_x0020_URL'/><FieldRef Name='Project_x0020_Manager2'/><FieldRef Name='IT_x0020_Technical_x0020_Lead'/><FieldRef Name='Project_x0020_Phase'/>";
//query XML with only completed items or all items?
if (PullActiveOnly)
{
ndQuery.InnerXml = "<Where><Eq><FieldRef Name='Completed'/><Value Type='Number'>0</Value></Eq></Where>";
}
else
{
ndQuery.InnerXml = "";
}
try
{
XmlNode ndListItems;
Hashtable prjHash = new Hashtable();
//call web service to get all the projects from the PMO Project Board
ndListItems = listService.GetListItems(PROJECT_BOARD_GUID, PROJECT_BOARD_VIEW_GUID, ndQuery, ndViewFields, null, ndQueryOptions);
//create xml document so we can process
XmlDocument doc = new XmlDocument();
doc.LoadXml(ndListItems.OuterXml);
foreach (XmlNode element in doc.ChildNodes[0].ChildNodes[0].ChildNodes)
{
if (element.Attributes != null)
{
foreach (XmlAttribute attr in element.Attributes)
{
switch (attr.Name)
{
//TODO: This will be different based on the fields in your SharePoint list.
case "ows_Title":
prjHash.Add("ProjectNumber", attr.Value);
break;
case "ows_NSR_x002f_Project_x0020_Name":
prjHash.Add("Name", attr.Value);
break;
case "ows_Completed":
//list contains 0 if not compeleted and -1 if completed
if (Convert.ToInt32(attr.Value) == 0)
{
prjHash.Add("Active", true);
}
else
{
prjHash.Add("Active", false);
}
break;
case "ows_Approved":
prjHash.Add("Approved", attr.Value);
break;
case "ows_Current_x0020_Status":
prjHash.Add("Status", attr.Value);
break;
case "ows_Project_x0020_Site_x0020_URL":
//list returns value as url,url. we only need it once, so using split we take the first one
prjHash.Add("SiteURL", attr.Value.Split(',')[0]);
break;
case "ows_Project_x0020_Manager":
prjHash.Add("ProjectManager", attr.Value.Split('#')[1]);
break;
case "ows_Project_x0020_Phase":
prjHash.Add("PhaseID", attr.Value);
break;
case "ows_ID":
//once the attribute equals "ows_ID" we know we can process
//setup some temp holders
int projectID = Convert.ToInt32(attr.Value);
string number = prjHash["ProjectNumber"].ToString();
string name = prjHash["Name"].ToString();
string projectManager;
if (prjHash.ContainsKey("ProjectManager"))
{
projectManager = prjHash["ProjectManager"].ToString();
}
else
{
projectManager = "";
}
string siteURL;
if (prjHash.ContainsKey("SiteURL"))
{
siteURL = prjHash["SiteURL"].ToString();
}
else
{
siteURL = null;
}
int phaseID;
if (prjHash.ContainsKey("PhaseID"))
{
switch (prjHash["PhaseID"].ToString())
{
case "Initiating":
phaseID = 0;
break;
case "Planning":
phaseID = 1;
break;
case "Execution":
phaseID = 2;
break;
case "Monitoring":
phaseID = 3;
break;
case "Closing":
phaseID = 4;
break;
case "Proposals":
phaseID = 5;
break;
case "Startups/Turndowns":
phaseID = 6;
break;
case "Startup":
phaseID = 7;
break;
case "Turndown":
phaseID = 8;
break;
case "Win-awaiting NTP":
phaseID = 9;
break;
default:
phaseID = -1;
break;
}
}
else
{
phaseID = -1;
}
bool active;
if (Convert.ToBoolean(prjHash["Active"]) && (prjHash["Approved"].ToString() == "Approved as Project" || prjHash["Approved"].ToString() == "NSR Analysis"))
{
active = true;
}
else
{
active = false;
}
//DEBUG PRINT
//output += "<tr><td>Debug: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
//first we check to see if this project already exists
if (project.ProjectIDExists(projectID) < 1)
{
output += "<tr><td>Adding: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
//add the project to the db, first checking to see if SiteURL exists and is not empty
if (prjHash.ContainsKey("SiteURL") && (string)prjHash["SiteURL"] != String.Empty)
{
project.AddProject(projectID, number, name, siteURL, active, phaseID, projectManager);
}
else
{
project.AddProject(projectID, number, name, null, active, phaseID, projectManager);
}
output += "<td>Complete!</td></tr>";
count++;
}
else
{
//otherwise the project already exists and we can update it
if (UpdateProjects)
{
TimeKeeper.ProjectsDataTable prj = project.GetProjectByProjectID(projectID);
TimeKeeper.ProjectsRow prjRow = prj[0];
//output += "<tr><td>Update - " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
//output += "<tr><td>active = " + active.ToString() + "</tr></td>";
//count++;
if (prjRow.Active != active)
{
//RUN DEACTIVATE PROJECT CODE HERE
if (active == false)
{
ProjectMembersBLL projectMembers = new ProjectMembersBLL();
int membersDeleted = projectMembers.DeleteProjectMembersByProjectID(projectID);
output += "<tr><td>Deactivating: " + number + " - " + name + ", Removed " + membersDeleted.ToString() + " member(s)</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
project.UpdateProject(projectID, number, name, null, false, phaseID, projectManager);
output += "<td>Complete!</td></tr>";
}
else
{
output += "<tr><td>Activating: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
project.UpdateProject(projectID, number, name, null, true, phaseID, projectManager);
output += "<td>Complete!</td></tr>";
}
count++;
}
if (prjRow.ProjectNumber != number || prjRow.Name != name || prjRow.PhaseID != phaseID || prjRow.ProjectManager.ToString() != projectManager)
{
//it does exist, print message
output += "<tr><td>Updating: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
if (prjHash.ContainsKey("SiteURL") && (string)prjHash["SiteURL"] != String.Empty)
{
project.UpdateProject(projectID, number, name, siteURL, active, phaseID, projectManager);
}
else
{
project.UpdateProject(projectID, number, name, null, active, phaseID, projectManager);
}
output += "<td>Complete!</td></tr>";
count++;
}
if (prjRow.IsTeamSiteURLNull() && prjHash.ContainsKey("SiteURL") && (string)prjHash["SiteURL"] != String.Empty)
{
//there is a new team site that we need to add
output += "<tr><td>Team Site added: " + number + " - " + name + "</td><td style=\"color: #FFFFE0;\"> (ID = " + attr.Value + ")</td>";
project.UpdateProject(projectID, number, name, siteURL, active, phaseID, projectManager);
output += "<td>Complete!</td></tr>";
count++;
}
}
}
break;
}
}
}
//clear the hash for the next element
prjHash.Clear();
}
}
catch (System.Web.Services.Protocols.SoapException ex)
{
output = ex.StackTrace;
}
//set label
PullOutputLabel.Text = output;
return(count);
}
private void GetProjects(int id)
{
ProjectsBLL objPro = new ProjectsBLL();
objPro.ID = id;
DataTable dt = new DataTable();
dt = objPro.GetPrtojects();
if (dt.Rows.Count > 0)
{
DDLClub.SelectedItem.Text = dt.Rows[0]["club_name"].ToString();
DDLClub.SelectedValue = dt.Rows[0]["club_id"].ToString();
DDLYears.SelectedItem.Text = dt.Rows[0]["project_year"].ToString();
txtProName.Text = dt.Rows[0]["project_title"].ToString();
dtStartDate.DbSelectedDate = dt.Rows[0]["start_date"].ToString();
dtEndDate.DbSelectedDate = dt.Rows[0]["end_date"].ToString();
//DDLClubName2.SelectedValue = dt.Rows[0]["club_id"].ToString();
rbtnProjectType.SelectedItem.Text = dt.Rows[0]["project_type"].ToString();
txtProjectLocation.Text = dt.Rows[0]["project_location"].ToString();
txtDesc.Text = dt.Rows[0]["project_description"].ToString();
txtProjectCost.Text = dt.Rows[0]["project_cost"].ToString();
ddlAvenueCovered.SelectedItem.Text = dt.Rows[0]["avenue_of_covered"].ToString();
DDLChairperson.SelectedItem.Text = dt.Rows[0]["project_chairperson"].ToString();
string strComMembers = dt.Rows[0]["committee_members"].ToString();
if (strComMembers != "")
{
string[] mems = strComMembers.Split(',');
for (int i = 0; i <= mems.Length - 1; i++)
{
listTopics.Items.Add(mems[i]);
}
}
txtBeneficiaries.Text = dt.Rows[0]["beneficiaries"].ToString();
// txtProName.Text = dt.Rows[0]["project_images"].ToString();
// txtProName.Text = dt.Rows[0]["partner_club_district_no"].ToString();
// txtProName.Text = dt.Rows[0]["partner_club_name"].ToString();
txtDistGrantNo.Text = dt.Rows[0]["district_grant_no"].ToString();
txtGlobalGrantNo.Text = dt.Rows[0]["district_global_no"].ToString();
txtAdd1.Text = dt.Rows[0]["add1"].ToString();
txtAdd2.Text = dt.Rows[0]["add2"].ToString();
txtCity.Text = dt.Rows[0]["city"].ToString();
txtPin.Text = dt.Rows[0]["pin"].ToString();
txtState.Text = dt.Rows[0]["state"].ToString();
txtCountry.Text = dt.Rows[0]["country"].ToString();
txtPhCC1.Text = dt.Rows[0]["ph1_cc"].ToString();
txtPhAC1.Text = dt.Rows[0]["ph1_ac"].ToString();
txtPh1.Text = dt.Rows[0]["phone1"].ToString();
txtPhCC2.Text = dt.Rows[0]["ph2_cc"].ToString();
txtPhAC2.Text = dt.Rows[0]["ph2_ac"].ToString();
txtPh2.Text = dt.Rows[0]["phone2"].ToString();
txtFaxCC.Text = dt.Rows[0]["fax_cc"].ToString();
txtFaxAC.Text = dt.Rows[0]["fax_ac"].ToString();
txtFax.Text = dt.Rows[0]["fax"].ToString();
txtWebsite.Text = dt.Rows[0]["website"].ToString();
txtGeoLatitude.Text = dt.Rows[0]["geo_latitude"].ToString();
txtGeoLongitude.Text = dt.Rows[0]["geo_longitude"].ToString();
txtProjectDrection.Text = dt.Rows[0]["direction_project_site"].ToString();
//objPro.Project_Chairperson = DDLMemNameSpouse.SelectedItem.Text.ToString();
//objPro.Committee_Members = strTopics; // Multiple members comes here
//objPro.Beneficiaries = txtBeneficiaries.Text.ToString();
string strImages = dt.Rows[0]["project_images"].ToString();
if (strImages != "")
{
Session["ProjectImages"] = strImages;
}
//BindContacts(id);
}
}
private void UpdateProjects(int id)
{
if (RadAsyncUpload1.UploadedFiles.Count > 0)
{
if (Session["ProjectImages"] != null)
{
Session["ProjectImages"] = Session["ProjectImages"] + ",";
}
UploadImages();
}
int clubNo = int.Parse(DDLClub.SelectedValue.ToString());
ProjectsBLL objPro = new ProjectsBLL();
objPro.ClubName = DDLClub.SelectedItem.Text.Trim();
objPro.ClubPresident = "";
objPro.ID = id;
objPro.Project_Year = DDLYears.SelectedItem.Text.Trim();
objPro.Project_Title = txtProName.Text.ToString();
objPro.Start_Date = DateTime.Parse(dtStartDate.SelectedDate.ToString());
objPro.End_Date = DateTime.Parse(dtEndDate.SelectedDate.ToString());
objPro.ClubNo = clubNo;
objPro.Project_Type = rbtnProjectType.SelectedItem.Text.Trim();
objPro.Project_Location = txtProjectLocation.Text.ToString();
objPro.Project_Description = txtDesc.Text.ToString();
objPro.Project_Cost = decimal.Parse(txtProjectCost.Text.ToString());
objPro.Avenue_of_Covered = ddlAvenueCovered.SelectedItem.Text.ToString();
objPro.Project_Chairperson = DDLChairperson.SelectedItem.Text.ToString();
string strTopics = "";
foreach (ListItem li in listTopics.Items)
{
strTopics = strTopics + li.Text + ",";
}
objPro.Committee_Members = strTopics; // Multiple members comes here
objPro.Beneficiaries = txtBeneficiaries.Text.ToString();
try
{
string strImages = Session["ProjectImages"].ToString();
//strImages = strImages.Remove(strImages.Length - 1);
objPro.Project_Images = strImages;
}
catch { objPro.Project_Images = ""; }
objPro.Partner_Club_District_no = "";
string strPartnerClub = "";
foreach (ListItem li in listPartnerClub.Items)
{
strPartnerClub = strPartnerClub + li.Text + ",";
}
objPro.Partner_Club_Name = strPartnerClub;
objPro.District_Grant_no = txtDistGrantNo.Text.ToString();
objPro.District_Global_no = txtGlobalGrantNo.Text.ToString();
objPro.Address1 = txtAdd1.Text.ToString();
objPro.Address2 = txtAdd2.Text.ToString();
objPro.Pin = int.Parse(txtPin.Text.ToString());
objPro.City = txtCity.Text.ToString();
objPro.State = txtState.Text.ToString();
objPro.Country = txtCountry.Text.ToString();
objPro.Ph1_AC = txtPhAC1.Text.ToString();
objPro.Ph1_CC = txtPhCC1.Text.ToString();
objPro.Phone1 = txtPh1.Text.ToString();
objPro.Ph2_AC = txtPhAC2.Text.ToString();
objPro.Ph2_CC = txtPhCC2.Text.ToString();
objPro.Phone2 = txtPh2.Text.ToString();
objPro.Fax_CC = txtFaxCC.Text.ToString();
objPro.Fax_AC = txtFaxAC.Text.ToString();
objPro.Fax = txtFax.Text.ToString();
objPro.Website = txtWebsite.Text.ToString();
objPro.GEO_Latitude = txtGeoLatitude.Text.ToString();
objPro.GEO_longitude = txtGeoLongitude.Text.ToString();
objPro.Direction_Project_Site = txtProjectDrection.Text.ToString();
int exe = objPro.UpdatePrtoject();
if (exe > 0)
{
ShowMsg("Record Updated Successfully", "view_rotary_projects.aspx");
}
}
private void AddProjects()
{
if (RadAsyncUpload1.UploadedFiles.Count > 0)
{
Session["ProjectImages"] = null;
UploadImages();
}
/************Code for find IP address of user's machine**********/
string ipaddress;
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
/***************************************************************/
ProjectsBLL objPro = new ProjectsBLL();
int clubNo = int.Parse(DDLClub.SelectedValue.ToString());
objPro.ClubName = DDLClub.SelectedItem.Text.Trim();
objPro.ClubPresident = "";
objPro.Project_Year = DDLYears.SelectedItem.Text.Trim();
objPro.Project_Title = txtProName.Text.ToString();
objPro.Start_Date = DateTime.Parse(dtStartDate.SelectedDate.ToString());
objPro.End_Date = DateTime.Parse(dtEndDate.SelectedDate.ToString());
objPro.ClubNo = clubNo;
objPro.Project_Type = rbtnProjectType.SelectedItem.Text.Trim();
objPro.Project_Location = txtProjectLocation.Text.ToString();
objPro.Project_Description = txtDesc.Text.ToString();
objPro.Project_Cost = decimal.Parse(txtProjectCost.Text.ToString());
objPro.Avenue_of_Covered = ddlAvenueCovered.SelectedItem.Text.ToString();
objPro.Project_Chairperson = DDLChairperson.SelectedItem.Text.ToString();
string strTopics = "";
foreach (ListItem li in listTopics.Items)
{
strTopics = strTopics + li.Text + ",";
}
objPro.Committee_Members = strTopics; // Multiple members comes here
objPro.Beneficiaries = txtBeneficiaries.Text.ToString();
try
{
string strImages = Session["ProjectImages"].ToString();
objPro.Project_Images = strImages;
}
catch { objPro.Project_Images = ""; }
objPro.Partner_Club_District_no = "";
string strPartnerClub = "";
foreach (ListItem li in listPartnerClub.Items)
{
strPartnerClub = strPartnerClub + li.Text + ",";
}
objPro.Partner_Club_Name = strPartnerClub;
objPro.District_Grant_no = txtDistGrantNo.Text.ToString();
objPro.District_Global_no = txtGlobalGrantNo.Text.ToString();
objPro.Address1 = txtAdd1.Text.ToString();
objPro.Address2 = txtAdd2.Text.ToString();
try
{
objPro.Pin = int.Parse(txtPin.Text.ToString());
}
catch { objPro.Pin = 0; }
objPro.City = txtCity.Text.ToString();
objPro.State = txtState.Text.ToString();
objPro.Country = txtCountry.Text.ToString();
objPro.Ph1_AC = txtPhAC1.Text.ToString();
objPro.Ph1_CC = txtPhCC1.Text.ToString();
objPro.Phone1 = txtPh1.Text.ToString();
objPro.Ph2_AC = txtPhAC2.Text.ToString();
objPro.Ph2_CC = txtPhCC2.Text.ToString();
objPro.Phone2 = txtPh2.Text.ToString();
objPro.Fax_CC = txtFaxCC.Text.ToString();
objPro.Fax_AC = txtFaxAC.Text.ToString();
objPro.Fax = txtFax.Text.ToString();
objPro.Website = txtWebsite.Text.ToString();
objPro.GEO_Latitude = txtGeoLatitude.Text.ToString();
objPro.GEO_longitude = txtGeoLongitude.Text.ToString();
objPro.Direction_Project_Site = txtProjectDrection.Text.ToString();
objPro.Ipaddress = ipaddress;
int exe = objPro.AddPrtoject();
if (exe > 0)
{
try
{
string jv = "<script>alert('Record Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
catch { }
int pid = GetProjectId();
UpdateProjectContacts(pid);
Clear();
}
}
private void GetProjects(int id)
{
ProjectsBLL objPro = new ProjectsBLL();
objPro.ID = id;
DataTable dt = new DataTable();
dt = objPro.GetPrtojects();
if (dt.Rows.Count > 0)
{
lblProjectYear.Text = dt.Rows[0]["project_year"].ToString();
lblProjectTitle.Text = dt.Rows[0]["project_title"].ToString();
lblStartDate.Text = dt.Rows[0]["start_date"].ToString();
lblEndDate.Text = dt.Rows[0]["end_date"].ToString();
lblProjectType.Text = dt.Rows[0]["project_type"].ToString();
lblProjectLocation.Text = dt.Rows[0]["project_location"].ToString();
lblProjectDescription.Text = dt.Rows[0]["project_description"].ToString();
lblProjectCost.Text = dt.Rows[0]["project_cost"].ToString();
lblAvenueOfCovered.Text = dt.Rows[0]["avenue_of_covered"].ToString();
lblProjectChairperson.Text = dt.Rows[0]["project_chairperson"].ToString();
lblCommitteeMembers.Text = dt.Rows[0]["committee_members"].ToString();
lblBeneficiaries.Text = dt.Rows[0]["beneficiaries"].ToString();
// txtProName.Text = dt.Rows[0]["project_images"].ToString();
// txtProName.Text = dt.Rows[0]["partner_club_district_no"].ToString();
// txtProName.Text = dt.Rows[0]["partner_club_name"].ToString();
lblDistrictGrantNo.Text = dt.Rows[0]["district_grant_no"].ToString();
lblDistrictGlobalNo.Text = dt.Rows[0]["district_global_no"].ToString();
lblAdd.Text = dt.Rows[0]["add1"].ToString() + " " + dt.Rows[0]["add2"].ToString();
//txtAdd2.Text = dt.Rows[0]["add2"].ToString();
lblCity.Text = dt.Rows[0]["city"].ToString();
lblPin.Text = dt.Rows[0]["pin"].ToString();
lblState.Text = dt.Rows[0]["state"].ToString();
lblCountry.Text = dt.Rows[0]["country"].ToString();
lblPhone1.Text = dt.Rows[0]["ph1_cc"].ToString() + " " + dt.Rows[0]["ph1_ac"].ToString() + " " + dt.Rows[0]["phone1"].ToString();
lblPhone2.Text = dt.Rows[0]["ph2_cc"].ToString() + " " + dt.Rows[0]["ph2_ac"].ToString() + " " + dt.Rows[0]["phone2"].ToString();
lblFax.Text = dt.Rows[0]["fax_cc"].ToString() + " " + dt.Rows[0]["fax_ac"].ToString() + " " + dt.Rows[0]["fax"].ToString();
//txtPhAC1.Text = dt.Rows[0]["ph1_ac"].ToString();
//txtPh1.Text = dt.Rows[0]["phone1"].ToString();
//txtPhCC2.Text = dt.Rows[0]["ph2_cc"].ToString();
//txtPhAC2.Text = dt.Rows[0]["ph2_ac"].ToString();
//txtPh2.Text = dt.Rows[0]["phone2"].ToString();
//txtFaxCC.Text = dt.Rows[0]["fax_cc"].ToString();
//txtFaxAC.Text = dt.Rows[0]["fax_ac"].ToString();
//txtFax.Text = dt.Rows[0]["fax"].ToString();
//txtWebsite.Text = dt.Rows[0]["website"].ToString();
//txtGeoLatitude.Text = dt.Rows[0]["geo_latitude"].ToString();
//txtGeoLongitude.Text = dt.Rows[0]["geo_longitude"].ToString();
//txtProjectDrection.Text = dt.Rows[0]["direction_project_site"].ToString();
//objPro.Project_Chairperson = DDLMemNameSpouse.SelectedItem.Text.ToString();
//objPro.Committee_Members = strTopics; // Multiple members comes here
//objPro.Beneficiaries = txtBeneficiaries.Text.ToString();
string strImages = dt.Rows[0]["project_images"].ToString();
if (strImages != "")
{
Session["ProjectImages"] = strImages;
}
}
}
protected void ProjectDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
if (ProjectDropDownList.SelectedIndex == 0)
{
EnablePhase(false);
PhaseDropDown.SelectedIndex = 0;
}
else
{
ProjectsBLL project = new ProjectsBLL();
TimeKeeper.ProjectsDataTable prj = project.GetProjectByProjectID(Convert.ToInt32(ProjectDropDownList.SelectedValue));
TimeKeeper.ProjectsRow prjRow = prj[0];
if (prjRow.PhaseID >= 0)
PhaseDropDown.SelectedValue = prjRow.PhaseID.ToString();
else
PhaseDropDown.SelectedValue = "None";
EnablePhase(true);
}
ScriptManager.SetFocus(ProjectDropDownList);
}
