protected void delete_Click(object sender, EventArgs e) { string rs = ""; // TTSHWCFServiceClient cl = new TTSHWCFServiceClient(); try { Project_Master pm = new Project_Master(); pm.i_ID = Int32.Parse(HdnId.Value); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, mode = "Delete" }; var baseAddress = Session["WebApiUrl"].ToString() + "api/ProjectMaster/"; var http = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(new Uri(baseAddress)); http.Accept = "application/json"; http.ContentType = "application/json"; http.Method = "POST"; string parsedContent = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(pmm); ASCIIEncoding encoding = new ASCIIEncoding(); Byte[] bytes = encoding.GetBytes(parsedContent); System.IO.Stream newStream = http.GetRequestStream(); newStream.Write(bytes, 0, bytes.Length); newStream.Close(); var response = http.GetResponse(); var stream = response.GetResponseStream(); var sr = new StreamReader(stream); rs = sr.ReadToEnd(); if (rs != "" && rs.ToLower().Contains("success")) { this.MsgBox("Project Details Deleted Successfully..!!"); ShowPanel(); FillGridMain(); } // rs = cl.GetValidate("Delete_Project", "1", "admin", HdnId.Value, ""); //if (rs != "") //{ // this.MsgBox("Project Details Deleted Successfully..!!"); // ShowPanel(); // FillGridMain(); //} } catch (Exception ex) { this.MsgBox(ex.Message.ToString()); } }
protected void delete_Click(object sender, EventArgs e) { string rs = ""; // TTSHWCFServiceClient cl = new TTSHWCFServiceClient(); try { Project_Master pm = new Project_Master(); pm.i_ID = Int32.Parse(HdnId.Value); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, mode = "Delete" }; using (var client = new System.Net.Http.HttpClient()) { //client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/"); client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/ProjectMaster/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var json = Newtonsoft.Json.JsonConvert.SerializeObject(pmm); HttpContent content = new StringContent(json); content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result; var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", content).Result; if (response.IsSuccessStatusCode) { // by calling .Result you are performing a synchronous call var responseContent = response.Content; // by calling .Result you are synchronously reading the result rs = responseContent.ReadAsStringAsync().Result; } } if (rs != "") { this.MsgBox("Project Details Deleted Successfully..!!"); ShowPanel(); FillGridMain(); } // rs = cl.GetValidate("Delete_Project", "1", "admin", HdnId.Value, ""); //if (rs != "") //{ // this.MsgBox("Project Details Deleted Successfully..!!"); // ShowPanel(); // FillGridMain(); //} } catch (Exception ex) { this.MsgBox(ex.Message.ToString()); } }
/// <summary> /// Ad update user /// </summary> /// <returns></returns> public string AddOrUpdateProject(ProjectrManagerContext projModel) { string result = string.Empty; Project_Master addProject = new Project_Master(); addProject.Project = projModel.Project; addProject.Project_ID = projModel.Project_ID; addProject.Priority = projModel.Priority; addProject.Start_Date = projModel.Start_Date; addProject.End_Date = projModel.End_Date; addProject.Completed = projModel.Manager; result = dataAccess.AddUpdateProject(addProject); return(result); }
protected void GetProjectDetailsAtNew() { TTSHWCFServiceClient cl = new TTSHWCFServiceClient(); Project_Master plist = new Project_Master(); List <PI_Master> List_DEPT_PI = new List <PI_Master>(); try { plist = cl.GetProject_MasterDetailsByID(Convert.ToInt32(Common.iffBlank(HdnProject_Id.Value, 0))); TxtProjTitle.Text = plist.s_Project_Title; TxtAlias1.Text = plist.s_Project_Alias1; TxtShortTitle.Text = plist.s_Short_Title; TxtprojCategory.Text = plist.Project_Category_Name; TxtAlias2.Text = plist.s_Project_Alias2; TxtIrbNo.Text = plist.s_IRB_No; DispProjectId.InnerText = plist.s_Display_Project_ID; List_DEPT_PI = plist.DEPT_PI.ToList(); rptrPIDetails.DataSource = List_DEPT_PI; rptrPIDetails.DataBind(); } catch (Exception) { throw; } }
protected async void FillControl() { Project_Master plist = new Project_Master(); List<PI_Master> List_DEPT_PI = new List<PI_Master>(); List<Project_Coordinator_Details> List_Co_Ord = new List<Project_Coordinator_Details>(); try { ShowPanel("entry"); // plist = cl.GetProject_MasterDetailsByID(Convert.ToInt32(Common.iffBlank(HdnId.Value, 0))); ProjectMasterModel pmm = new ProjectMasterModel(); using (var client = new HttpClient()) { // client.BaseAddress = new Uri(ConfigurationManager.AppSettings["WebApiUrl"].ToString()); client.BaseAddress = new Uri(Session["WebApiUrl"].ToString()); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response =await client.GetAsync(string.Format("api/ProjectMaster/{0}", Convert.ToInt32(Common.iffBlank(HdnId.Value, 0)))); JavaScriptSerializer serializer = new JavaScriptSerializer(); pmm = serializer.Deserialize<ProjectMasterModel>(response.Content.ReadAsStringAsync().Result); } // BindCombo(); BindCoOrdinator(); plist = pmm._Project_Master; TxtDispProjId.Text = Common.GetReplace(plist.s_Display_Project_ID); DispProjectId.InnerText = TxtDispProjId.Text; TxtstartDate.Text = plist.Project_StartDate; TxtprojTitle.Text = Common.GetReplace(plist.s_Project_Title); TxtShortTitle.Text = Common.GetReplace(plist.s_Short_Title); TxtProjTitleAlias1.Text = Common.GetReplace(plist.s_Project_Alias1); TxtProjTitleAlias2.Text = Common.GetReplace(plist.s_Project_Alias2); TxtProjDescription.Text = Common.GetReplace(plist.s_Project_Desc); TxtIRBno.Text = Common.GetReplace(plist.s_IRB_No); ddlProjCategory.SelectedIndex = ddlProjCategory.Items.IndexOf(ddlProjCategory.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_Project_Category_ID, "")))); ddlProjType.SelectedIndex = ddlProjType.Items.IndexOf(ddlProjType.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_Project_Type_ID, "")))); ddlProjType_SelectedIndexChanged(null, null); ddlProjSubType.SelectedIndex = ddlProjSubType.Items.IndexOf(ddlProjSubType.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_Project_Subtype_ID, "")))); ddlProjSubType.Enabled = (ddlProjSubType.SelectedIndex > 0) ? true : false; ddlFeasibilityStatus.SelectedIndex = ddlFeasibilityStatus.Items.IndexOf(ddlFeasibilityStatus.Items.FindByValue(Convert.ToString(plist.b_IsFeasible))); HdnFeasibilityStatus.Value = Convert.ToString(plist.b_IsFeasible); ddlselectedproject.SelectedIndex = ddlselectedproject.Items.IndexOf(ddlselectedproject.Items.FindByValue(Convert.ToString(plist.b_Isselected_project == true ? "1" : "0"))); ddlCollbrationInv.SelectedIndex = ddlCollbrationInv.Items.IndexOf(ddlCollbrationInv.Items.FindByValue(Convert.ToString(plist.b_Collaboration_Involved == true ? "1" : "0"))); if (ddlProjCategory.SelectedItem.Text.ToLower() == "pharma") { ddlCollbrationInv.Enabled = false; } ddlstartbyTTSH.SelectedIndex = ddlstartbyTTSH.Items.IndexOf(ddlstartbyTTSH.Items.FindByValue(Convert.ToString(plist.b_StartBy_TTSH == true ? "1" : "0"))); ddlfundingReq.SelectedIndex = ddlfundingReq.Items.IndexOf(ddlfundingReq.Items.FindByValue(Convert.ToString(plist.b_Funding_req == true ? "1" : "0"))); ddlChildParent.SelectedIndex = ddlChildParent.Items.IndexOf(ddlChildParent.Items.FindByValue(Convert.ToString(plist.b_Ischild == true ? "0" : "1"))); if (ddlChildParent.SelectedValue == "0") { ddlParentProjName.Enabled = true; txtParentProjId.Enabled = true; ddlParentProjName.SelectedIndex = ddlParentProjName.Items.IndexOf(ddlParentProjName.Items.FindByValue(Convert.ToString(plist.i_Parent_ProjectID))); ddlParentProjName_SelectedIndexChanged(null, null); } else { ddlParentProjName.Enabled = false; txtParentProjId.Enabled = false; } //-------Newly Added 31-08-2015------------ ddlProjectStatus.SelectedIndex = ddlProjectStatus.Items.IndexOf(ddlProjectStatus.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_ProjectStatus, "")))); TxtProjectEndDate.Text = Convert.ToString(plist.Dt_ProjectEndDate); ddlEthicsNeeded.SelectedValue = (plist.b_EthicsNeeded == true) ? "1" : "0"; //---- END--------------------------------- ScriptManager.RegisterStartupScript(Page, typeof(Page), "Enable", "BindDoObjects();", true); /*dataowner fill*/ ddlDO_Ethics.SelectedIndex = ddlDO_Ethics.Items.IndexOf(ddlDO_Ethics.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Ethics_DataOwner, "")))); ddlDO_Feasibility.SelectedIndex = ddlDO_Feasibility.Items.IndexOf(ddlDO_Feasibility.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Feasibility_DataOwner, "")))); ddlDO_Contract.SelectedIndex = ddlDO_Contract.Items.IndexOf(ddlDO_Contract.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Contract_DataOwner, "")))); ddlDO_Selected.SelectedIndex = ddlDO_Selected.Items.IndexOf(ddlDO_Ethics.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Selected_DataOwner, "")))); ddlDO_Regulatory.SelectedIndex = ddlDO_Regulatory.Items.IndexOf(ddlDO_Regulatory.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Regulatory_DataOwner, "")))); ddlDO_Grant.SelectedIndex = ddlDO_Grant.Items.IndexOf(ddlDO_Grant.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Grant_DataOwner, "")))); //Page.ClientScript.RegisterStartupScript(this.GetType(), "enable", "alert('Hello!')", true); //ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "enable", "BindDoObjects();", true); /**/ List_DEPT_PI = pmm.DEPT_PI.ToList(); //plist.DEPT_PI.ToList(); var q = (from i in List_DEPT_PI select new { i.i_Dept_ID, i.i_ID }).ToList().ListToDatatable(); rptrPIDetails.DataSource = List_DEPT_PI; rptrPIDetails.DataBind(); txtResearchOrder.Text = Common.GetReplace(plist.s_Research_IO); txtReserchInsurance.Text = Common.GetReplace(plist.s_Research_IP); List_Co_Ord = pmm.pcd.ToList(); //plist.COORDINATOR.ToList(); for (int j = 0; j < chkboxlist.Items.Count; j++) { for (int i = 0; i < List_Co_Ord.Count; i++) { if (chkboxlist.Items[j].Value == Convert.ToString(List_Co_Ord[i].i_Coordinator_ID)) { chkboxlist.Items[j].Selected = true; TextSearch.Text += chkboxlist.Items[j].Text + ","; } } } if (TextSearch.Text != "") { TextSearch.Text = TextSearch.Text.TrimEnd(','); } // TxtDispProjId.Attributes.Add("onblur", "javascript:return GetValidatefrmDB('" + HdnError.ClientID + "','ValidateDispID' ,'" + TxtDispProjId.ClientID + "','" + HdnId.Value + "');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", "ClearAll('" + HdnMode.Value + "');", true); if (HdnMode.Value.ToLower() == "update") { // String s = cl.GetValidate("RestrictChild", HdnId.Value, "", "", ""); //if (s != "") //{ // ddlChildParent.Enabled = false; // ddlChildParent.Attributes.Add("title", "Child Project is Created for this Project..!!"); //} } ChangeButtonText(); MakeControlValidate(); } catch (Exception ex) { throw ex; } }
public bool Save() { string result = string.Empty; Project_Master pm = new Project_Master(); Project_Dept_PI pdi = new Project_Dept_PI(); List<Project_Dept_PI> pdlist = new List<Project_Dept_PI>(); Project_Coordinator_Details pcd = new Project_Coordinator_Details(); List<Project_Coordinator_Details> pcdList = new List<Project_Coordinator_Details>(); try { pm.i_ID = Convert.ToInt32(Common.iffBlank(HdnId.Value, 0)); TxtstartDate.Enabled = true; TxtDispProjId.Enabled = true; pm.Project_StartDate = TxtstartDate.Text; pm.s_Display_Project_ID = TxtDispProjId.Text; pm.s_Project_Title = Common.SetReplace(TxtprojTitle.Text); pm.s_Short_Title = Common.SetReplace(TxtShortTitle.Text); pm.s_Project_Alias1 = Common.SetReplace(TxtProjTitleAlias1.Text); pm.s_Project_Alias2 = Common.SetReplace(TxtProjTitleAlias2.Text); pm.s_Project_Desc = Common.SetReplace(TxtProjDescription.Text); pm.s_IRB_No = Common.SetReplace(TxtIRBno.Text); pm.i_Project_Category_ID = Convert.ToInt32(Common.iffBlank(ddlProjCategory.SelectedValue, 0)); pm.i_Project_Type_ID = Convert.ToInt32(Common.iffBlank(ddlProjType.SelectedValue, 0)); pm.i_Project_Subtype_ID = Convert.ToInt32(Common.iffBlank(ddlProjSubType.SelectedValue, 0)); pm.i_Parent_ProjectID = Convert.ToInt32(ddlParentProjName.SelectedValue); pm.b_IsFeasible = Convert.ToInt32(ddlFeasibilityStatus.SelectedValue); pm.b_Isselected_project = ddlselectedproject.SelectedValue == "0" ? false : true; pm.b_Collaboration_Involved = ddlCollbrationInv.SelectedValue == "0" ? false : true; pm.b_StartBy_TTSH = ddlstartbyTTSH.SelectedValue == "0" ? false : true; pm.b_Funding_req = ddlfundingReq.SelectedValue == "0" ? false : true; pm.b_Ischild = ddlChildParent.SelectedValue == "1" ? false : true; pm.s_Research_IO = txtResearchOrder.Text; pm.s_Research_IP = txtReserchInsurance.Text; //-------------pass tables to Sp------------------------- string[] PiIds = HdnPi_ID.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < PiIds.Length; i++) { pdlist.Add(new Project_Dept_PI { i_PI_ID = Convert.ToInt32(PiIds[i]) }); } string[] coOrIds = HdnCoordinatorId.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); string[] CoText = HdnCoordinatorText.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < coOrIds.Length; i++) { pcdList.Add(new Project_Coordinator_Details { i_Coordinator_ID = Convert.ToString(coOrIds[i]), s_Coordinator_name = CoText[i] }); } //--------UID and UName---- pm.UName = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserName"]), "").ToString(); pm.UID = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserID"]), "").ToString(); pm.i_ProjectStatus = Convert.ToInt32(ddlProjectStatus.SelectedValue); pm.Dt_ProjectEndDate = Convert.ToString(TxtProjectEndDate.Text); pm.b_EthicsNeeded = (ddlEthicsNeeded.SelectedItem.Text.ToLower() == "yes") ? true : false; //----------- END ------------ /*data owner*/ //pm.s_Ethics_DataOwner = (ddlDO_Ethics.SelectedValue != "0") ? ddlDO_Ethics.SelectedValue : null; //pm.s_Selected_DataOwner = (ddlDO_Selected.SelectedValue != "0") ? ddlDO_Selected.SelectedValue : null; //pm.s_Regulatory_DataOwner = (ddlDO_Regulatory.SelectedValue != "0") ? ddlDO_Regulatory.SelectedValue : null; //pm.s_Feasibility_DataOwner = (ddlDO_Feasibility.SelectedValue != "0") ? ddlDO_Feasibility.SelectedValue : null; //pm.s_Contract_DataOwner = (ddlDO_Contract.SelectedValue != "0") ? ddlDO_Contract.SelectedValue : null; //pm.s_Grant_DataOwner = (ddlDO_Grant.SelectedValue != "0") ? ddlDO_Grant.SelectedValue : null; /*data owner*/ //--------------------------------------------------------- //result = cl.Project_Master(pm, pdlist.ToArray(), pcdList.ToArray(), HdnMode.Value); //const string url = "http://localhost/ConsumingAPI/api/Products"; System.Collections.ArrayList paraMeters = new System.Collections.ArrayList(); paraMeters.Add(pm); paraMeters.Add(pdlist.ToArray()); paraMeters.Add(pcdList.ToArray()); paraMeters.Add(HdnMode.Value.ToString()); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, pdi = pdlist, pcd = pcdList, mode = HdnMode.Value }; using (var client = new System.Net.Http.HttpClient()) { // client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/"); client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/ProjectMaster/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var json = Newtonsoft.Json.JsonConvert.SerializeObject(pmm); HttpContent content = new StringContent(json); content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result; var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", content).Result; if (response.IsSuccessStatusCode) { // by calling .Result you are performing a synchronous call var responseContent = response.Content; // by calling .Result you are synchronously reading the result result = responseContent.ReadAsStringAsync().Result; } } //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Add", string.Format("javascript:AddProjectMaster({0},{1})",pmm, System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/"), true); if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true) { switch (HdnMode.Value.ToLower()) { case "update": this.MsgBox("Project Details Updated Successfully"); break; case "delete": this.MsgBox("Project Details Deleted Successfully"); break; case "insert": this.MsgBox(" Project Details Saved Successfully"); break; } ShowPanel(); FillGridMain(); } else { this.MsgBox(result.Split('|')[1]); return false; } } catch (Exception ex) { this.MsgBox(ex.ToString()); return false; } return true; }
protected void delete_Click(object sender, EventArgs e) { string rs = ""; // TTSHWCFServiceClient cl = new TTSHWCFServiceClient(); try { Project_Master pm = new Project_Master(); pm.i_ID =Int32.Parse(HdnId.Value); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, mode = "Delete" }; using (var client = new System.Net.Http.HttpClient()) { //client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/"); client.BaseAddress = new Uri(Session["WebApiUrl"].ToString()+ "api/ProjectMaster/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var json = Newtonsoft.Json.JsonConvert.SerializeObject(pmm); HttpContent content = new StringContent(json); content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result; var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", content).Result; if (response.IsSuccessStatusCode) { // by calling .Result you are performing a synchronous call var responseContent = response.Content; // by calling .Result you are synchronously reading the result rs = responseContent.ReadAsStringAsync().Result; } } if (rs != "") { this.MsgBox("Project Details Deleted Successfully..!!"); ShowPanel(); FillGridMain(); } // rs = cl.GetValidate("Delete_Project", "1", "admin", HdnId.Value, ""); //if (rs != "") //{ // this.MsgBox("Project Details Deleted Successfully..!!"); // ShowPanel(); // FillGridMain(); //} } catch (Exception ex) { this.MsgBox(ex.Message.ToString()); } }
protected void NewLink_Command(object sender, CommandEventArgs e) { projectGrid.Visible = false; //To reset all the controls ResetControls(); FeasibilityContainer.Visible = true; PopulateDropDown(); btnUpdateFeasibility.Visible = false; btnSaveFeasibility.Visible = true; TTSHWCFReference.Project_Master project = new Project_Master(); int project_id = Convert.ToInt32(e.CommandArgument); Session["ProjectID"] = project_id; bProjectID.InnerText = "Project ID: " + project_id; TTSHWCFServiceClient client = new TTSHWCFServiceClient(); project = client.GetProject_MasterDetailsByID(project_id); txtProjectTitle.Text = project.s_Project_Title; txtFeasibilityTitle.Text = project.s_Project_Title; txtShortTitle.Text = project.s_Short_Title; ddlProjectCategory.SelectedValue = project.i_Project_Category_ID.ToString(); txtAlias1.Text = project.s_Project_Alias1; txtAlias2.Text = project.s_Project_Alias2; bProjectID.InnerText = "Project ID: " + project.s_Display_Project_ID; //Set Update By and Updated date txtLastUpdatedBy.Text = LoginUser; txtDateUpdated.Text = DateTime.Now.ToString("dd-MMM-yy"); FillPIGrid(project.DEPT_PI.ToList()); ddlConfidentialAgreement.SelectedValue = "1"; txtFeasibilityStartDate.Text = DateTime.Now.ToString("dd-MMM-yy"); if (ddlConfidentialAgreement.SelectedValue == "1") { hdnAgreementFileEnabled.Value = "Yes"; } else { hdnAgreementFileEnabled.Value = "No"; } }
public bool Save() { string result = string.Empty; Project_Master pm = new Project_Master(); Project_Dept_PI pdi = new Project_Dept_PI(); List<Project_Dept_PI> pdlist = new List<Project_Dept_PI>(); Project_Coordinator_Details pcd = new Project_Coordinator_Details(); List<Project_Coordinator_Details> pcdList = new List<Project_Coordinator_Details>(); try { pm.i_ID = Convert.ToInt32(Common.iffBlank(HdnId.Value, 0)); TxtstartDate.Enabled = true; TxtDispProjId.Enabled = true; pm.Project_StartDate = TxtstartDate.Text; pm.s_Display_Project_ID = TxtDispProjId.Text==""? Session["NewProjectId"].ToString():TxtDispProjId.Text; pm.s_Project_Title = Common.SetReplace(TxtprojTitle.Text); pm.s_Short_Title = Common.SetReplace(TxtShortTitle.Text); pm.s_Project_Alias1 = Common.SetReplace(TxtProjTitleAlias1.Text); pm.s_Project_Alias2 = Common.SetReplace(TxtProjTitleAlias2.Text); pm.s_Project_Desc = Common.SetReplace(TxtProjDescription.Text); pm.s_IRB_No = Common.SetReplace(TxtIRBno.Text); pm.i_Project_Category_ID = Convert.ToInt32(Common.iffBlank(ddlProjCategory.SelectedValue, 0)); pm.i_Project_Type_ID = Convert.ToInt32(Common.iffBlank(ddlProjType.SelectedValue, 0)); pm.i_Project_Subtype_ID = Convert.ToInt32(Common.iffBlank(ddlProjSubType.SelectedValue, 0)); pm.i_Parent_ProjectID = Convert.ToInt32(ddlParentProjName.SelectedValue); pm.b_IsFeasible = Convert.ToInt32(ddlFeasibilityStatus.SelectedValue); pm.b_Isselected_project = ddlselectedproject.SelectedValue == "0" ? false : true; pm.b_Collaboration_Involved = ddlCollbrationInv.SelectedValue == "0" ? false : true; pm.b_StartBy_TTSH = ddlstartbyTTSH.SelectedValue == "0" ? false : true; pm.b_Funding_req = ddlfundingReq.SelectedValue == "0" ? false : true; pm.b_Ischild = ddlChildParent.SelectedValue == "1" ? false : true; pm.s_Research_IO = txtResearchOrder.Text; pm.s_Research_IP = txtReserchInsurance.Text; //-------------pass tables to Sp------------------------- string[] PiIds = HdnPi_ID.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < PiIds.Length; i++) { pdlist.Add(new Project_Dept_PI { i_PI_ID = Convert.ToInt32(PiIds[i]) }); } string[] coOrIds = HdnCoordinatorId.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Where(i=>Int32.Parse(i)>0).Select(i => i.ToString()).ToArray(); string[] CoText = HdnCoordinatorText.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < coOrIds.Length; i++) { pcdList.Add(new Project_Coordinator_Details { i_Coordinator_ID = Convert.ToString(coOrIds[i]), s_Coordinator_name = CoText[i] }); } //--------UID and UName---- pm.UName = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserName"]), "").ToString(); pm.UID = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserID"]), "").ToString(); pm.i_ProjectStatus = Convert.ToInt32(ddlProjectStatus.SelectedValue); pm.Dt_ProjectEndDate = Convert.ToString(TxtProjectEndDate.Text); pm.b_EthicsNeeded = (ddlEthicsNeeded.SelectedItem.Text.ToLower() == "yes") ? true : false; //----------- END ------------ /*data owner*/ //pm.s_Ethics_DataOwner = (ddlDO_Ethics.SelectedValue != "0") ? ddlDO_Ethics.SelectedValue : null; //pm.s_Selected_DataOwner = (ddlDO_Selected.SelectedValue != "0") ? ddlDO_Selected.SelectedValue : null; //pm.s_Regulatory_DataOwner = (ddlDO_Regulatory.SelectedValue != "0") ? ddlDO_Regulatory.SelectedValue : null; //pm.s_Feasibility_DataOwner = (ddlDO_Feasibility.SelectedValue != "0") ? ddlDO_Feasibility.SelectedValue : null; //pm.s_Contract_DataOwner = (ddlDO_Contract.SelectedValue != "0") ? ddlDO_Contract.SelectedValue : null; //pm.s_Grant_DataOwner = (ddlDO_Grant.SelectedValue != "0") ? ddlDO_Grant.SelectedValue : null; /*data owner*/ //--------------------------------------------------------- //result = cl.Project_Master(pm, pdlist.ToArray(), pcdList.ToArray(), HdnMode.Value); //const string url = "http://localhost/ConsumingAPI/api/Products"; System.Collections.ArrayList paraMeters = new System.Collections.ArrayList(); paraMeters.Add(pm); paraMeters.Add(pdlist.ToArray()); paraMeters.Add(pcdList.ToArray()); paraMeters.Add(HdnMode.Value.ToString()); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, pdi = pdlist, pcd = pcdList, mode = HdnMode.Value }; var baseAddress = Session["WebApiUrl"].ToString() + "api/ProjectMaster/"; var http = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(new Uri(baseAddress)); http.Accept = "application/json"; http.ContentType = "application/json"; http.Method = "POST"; string parsedContent = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(pmm); ASCIIEncoding encoding = new ASCIIEncoding(); Byte[] bytes = encoding.GetBytes(parsedContent); System.IO.Stream newStream = http.GetRequestStream(); newStream.Write(bytes, 0, bytes.Length); newStream.Close(); var response = http.GetResponse(); var stream = response.GetResponseStream(); var sr = new StreamReader(stream); result = sr.ReadToEnd(); if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true) { switch (HdnMode.Value.ToLower()) { case "update": this.MsgBox("Project Details Updated Successfully"); break; case "delete": this.MsgBox("Project Details Deleted Successfully"); break; case "insert": this.MsgBox(" Project Details Saved Successfully"); break; } ShowPanel(); FillGridMain(); } else { this.MsgBox(result.Split('|')[1]); return false; } } catch (Exception ex) { this.MsgBox(ex.ToString()); return false; } return true; }
protected void FillControl() { Project_Master plist = new Project_Master(); List <PI_Master> List_DEPT_PI = new List <PI_Master>(); List <Project_Coordinator_Details> List_Co_Ord = new List <Project_Coordinator_Details>(); try { ShowPanel("entry"); // plist = cl.GetProject_MasterDetailsByID(Convert.ToInt32(Common.iffBlank(HdnId.Value, 0))); ProjectMasterModel pmm = new ProjectMasterModel(); System.Net.WebClient client = new System.Net.WebClient(); client.Headers.Add("content-type", "application/json");//set your header here, you can add multiple headers string arr = client.DownloadString(string.Format("{0}api/ProjectMaster/{1}", Session["WebApiUrl"].ToString(), Convert.ToInt32(Common.iffBlank(HdnId.Value, 0)))); JavaScriptSerializer serializer = new JavaScriptSerializer(); pmm = serializer.Deserialize <ProjectMasterModel>(arr); // using (var client = new HttpClient()) //{ // // client.BaseAddress = new Uri(ConfigurationManager.AppSettings["WebApiUrl"].ToString()); // client.BaseAddress = new Uri(Session["WebApiUrl"].ToString()); // client.DefaultRequestHeaders.Accept.Clear(); // client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // HttpResponseMessage response = await client.GetAsync(string.Format("api/ProjectMaster/{0}", Convert.ToInt32(Common.iffBlank(HdnId.Value, 0)))); // JavaScriptSerializer serializer = new JavaScriptSerializer(); // pmm = serializer.Deserialize<ProjectMasterModel>(response.Content.ReadAsStringAsync().Result); //} // BindCombo(); BindCoOrdinator(); plist = pmm._Project_Master; TxtDispProjId.Text = Common.GetReplace(plist.s_Display_Project_ID); DispProjectId.InnerText = TxtDispProjId.Text; TxtstartDate.Text = plist.Project_StartDate; TxtprojTitle.Text = Common.GetReplace(plist.s_Project_Title); TxtShortTitle.Text = Common.GetReplace(plist.s_Short_Title); TxtProjTitleAlias1.Text = Common.GetReplace(plist.s_Project_Alias1); TxtProjTitleAlias2.Text = Common.GetReplace(plist.s_Project_Alias2); TxtProjDescription.Text = Common.GetReplace(plist.s_Project_Desc); TxtIRBno.Text = Common.GetReplace(plist.s_IRB_No); ddlProjCategory.SelectedIndex = ddlProjCategory.Items.IndexOf(ddlProjCategory.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_Project_Category_ID, "")))); ddlProjType.SelectedIndex = ddlProjType.Items.IndexOf(ddlProjType.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_Project_Type_ID, "")))); ddlProjType_SelectedIndexChanged(null, null); ddlProjSubType.SelectedIndex = ddlProjSubType.Items.IndexOf(ddlProjSubType.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_Project_Subtype_ID, "")))); ddlProjSubType.Enabled = (ddlProjSubType.SelectedIndex > 0) ? true : false; ddlFeasibilityStatus.SelectedIndex = ddlFeasibilityStatus.Items.IndexOf(ddlFeasibilityStatus.Items.FindByValue(Convert.ToString(plist.b_IsFeasible))); HdnFeasibilityStatus.Value = Convert.ToString(plist.b_IsFeasible); ddlselectedproject.SelectedIndex = ddlselectedproject.Items.IndexOf(ddlselectedproject.Items.FindByValue(Convert.ToString(plist.b_Isselected_project == true ? "1" : "0"))); ddlCollbrationInv.SelectedIndex = ddlCollbrationInv.Items.IndexOf(ddlCollbrationInv.Items.FindByValue(Convert.ToString(plist.b_Collaboration_Involved == true ? "1" : "0"))); if (ddlProjCategory.SelectedItem.Text.ToLower() == "pharma") { ddlCollbrationInv.Enabled = false; } ddlstartbyTTSH.SelectedIndex = ddlstartbyTTSH.Items.IndexOf(ddlstartbyTTSH.Items.FindByValue(Convert.ToString(plist.b_StartBy_TTSH == true ? "1" : "0"))); ddlfundingReq.SelectedIndex = ddlfundingReq.Items.IndexOf(ddlfundingReq.Items.FindByValue(Convert.ToString(plist.b_Funding_req == true ? "1" : "0"))); ddlChildParent.SelectedIndex = ddlChildParent.Items.IndexOf(ddlChildParent.Items.FindByValue(Convert.ToString(plist.b_Ischild == true ? "0" : "1"))); if (ddlChildParent.SelectedValue == "0") { ddlParentProjName.Enabled = true; txtParentProjId.Enabled = true; ddlParentProjName.SelectedIndex = ddlParentProjName.Items.IndexOf(ddlParentProjName.Items.FindByValue(Convert.ToString(plist.i_Parent_ProjectID))); ddlParentProjName_SelectedIndexChanged(null, null); } else { ddlParentProjName.Enabled = false; txtParentProjId.Enabled = false; } //-------Newly Added 31-08-2015------------ ddlProjectStatus.SelectedIndex = ddlProjectStatus.Items.IndexOf(ddlProjectStatus.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.i_ProjectStatus, "")))); TxtProjectEndDate.Text = Convert.ToString(plist.Dt_ProjectEndDate); ddlEthicsNeeded.SelectedValue = (plist.b_EthicsNeeded == true) ? "1" : "0"; //---- END--------------------------------- ScriptManager.RegisterStartupScript(Page, typeof(Page), "Enable", "BindDoObjects();", true); /*dataowner fill*/ ddlDO_Ethics.SelectedIndex = ddlDO_Ethics.Items.IndexOf(ddlDO_Ethics.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Ethics_DataOwner, "")))); ddlDO_Feasibility.SelectedIndex = ddlDO_Feasibility.Items.IndexOf(ddlDO_Feasibility.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Feasibility_DataOwner, "")))); ddlDO_Contract.SelectedIndex = ddlDO_Contract.Items.IndexOf(ddlDO_Contract.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Contract_DataOwner, "")))); ddlDO_Selected.SelectedIndex = ddlDO_Selected.Items.IndexOf(ddlDO_Ethics.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Selected_DataOwner, "")))); ddlDO_Regulatory.SelectedIndex = ddlDO_Regulatory.Items.IndexOf(ddlDO_Regulatory.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Regulatory_DataOwner, "")))); ddlDO_Grant.SelectedIndex = ddlDO_Grant.Items.IndexOf(ddlDO_Grant.Items.FindByValue(Convert.ToString(Common.iffBlank(plist.s_Grant_DataOwner, "")))); //Page.ClientScript.RegisterStartupScript(this.GetType(), "enable", "alert('Hello!')", true); //ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "enable", "BindDoObjects();", true); /**/ List_DEPT_PI = pmm.DEPT_PI.ToList(); //plist.DEPT_PI.ToList(); var q = (from i in List_DEPT_PI select new { i.i_Dept_ID, i.i_ID }).ToList().ListToDatatable(); rptrPIDetails.DataSource = List_DEPT_PI; rptrPIDetails.DataBind(); txtResearchOrder.Text = Common.GetReplace(plist.s_Research_IO); txtReserchInsurance.Text = Common.GetReplace(plist.s_Research_IP); List_Co_Ord = pmm.pcd.ToList(); //plist.COORDINATOR.ToList(); for (int j = 0; j < chkboxlist.Items.Count; j++) { for (int i = 0; i < List_Co_Ord.Count; i++) { if (chkboxlist.Items[j].Value == Convert.ToString(List_Co_Ord[i].i_Coordinator_ID)) { chkboxlist.Items[j].Selected = true; TextSearch.Text += chkboxlist.Items[j].Text + ","; } } } if (TextSearch.Text != "") { TextSearch.Text = TextSearch.Text.TrimEnd(','); } // TxtDispProjId.Attributes.Add("onblur", "javascript:return GetValidatefrmDB('" + HdnError.ClientID + "','ValidateDispID' ,'" + TxtDispProjId.ClientID + "','" + HdnId.Value + "');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", "ClearAll('" + HdnMode.Value + "');", true); if (HdnMode.Value.ToLower() == "update") { // String s = cl.GetValidate("RestrictChild", HdnId.Value, "", "", ""); //if (s != "") //{ // ddlChildParent.Enabled = false; // ddlChildParent.Attributes.Add("title", "Child Project is Created for this Project..!!"); //} } ChangeButtonText(); MakeControlValidate(); } catch (Exception ex) { throw ex; } }
protected void NewLink_Command(object sender, CommandEventArgs e) { projectGrid.Visible = false; //To reset all the controls ResetControls(); HideAllContainer(); SelectedContainer.Visible = true; monthButton_Container.InnerHtml = ""; PopulateDropDown(); btnUpdateSelected.Visible = false; btnSaveSelected.Visible = true; txtSelectedStartDate.Text = DateTime.Now.ToString("dd-MMM-yy"); txtSelectedStartDate.Enabled = true; txtUpdatedBy.Text = LoginUser; txtDateUpdated.Text = DateTime.Now.ToString("dd-MMM-yy"); txtDateUpdated.Enabled = false; txtUpdatedBy.Enabled = false; TTSHWCFReference.Project_Master project = new Project_Master(); int project_id = Convert.ToInt32(e.CommandArgument); bProjectID.InnerText = "Project ID: " + project_id; HdnProjectID.Value = Convert.ToString(project_id); TTSHWCFServiceClient client = new TTSHWCFServiceClient(); project = client.GetProject_MasterDetailsByID(project_id); txtProjectTitle.Text = project.s_Project_Title; txtShortTitle.Text = project.s_Short_Title; ddlProjectCategory.SelectedValue = project.i_Project_Category_ID.ToString(); txtAlias1.Text = project.s_Project_Alias1; txtAlias2.Text = project.s_Project_Alias2; FillPIGrid(project.DEPT_PI.ToList()); //If Login User is Selected Team User if (isSelectedTeamUser) { SelectedSetting(); } //End of If Login User is Selected Team User //If Login User is Blinded Team User if (isBlindedUser) { BlindedSetting(); } //End of If Login User is Blinded Team User //If Login User is UnBlinded Team User if (isUnblinded) { UnblindedSetting(); } //End of If Login User is UnBlinded Team User }
protected void delete_Click(object sender, EventArgs e) { string rs = ""; // TTSHWCFServiceClient cl = new TTSHWCFServiceClient(); try { Project_Master pm = new Project_Master(); pm.i_ID = Int32.Parse(HdnId.Value); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, mode = "Delete" }; //var baseAddress =Session["WebApiUrl"].ToString() + "api/ProjectMaster/"; //var http = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(new Uri(baseAddress)); //http.Accept = "application/json"; //http.ContentType = "application/json"; //http.Method = "POST"; //string parsedContent =new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(pmm); //ASCIIEncoding encoding = new ASCIIEncoding(); //Byte[] bytes = encoding.GetBytes(parsedContent); //System.IO.Stream newStream = http.GetRequestStream(); //newStream.Write(bytes, 0, bytes.Length); //newStream.Close(); //var response = http.GetResponse(); //var stream = response.GetResponseStream(); //var sr = new StreamReader(stream); //var content = sr.ReadToEnd(); //System.Net.WebClient client = new System.Net.WebClient(); ////client.Headers.Add("content-type", "application/json");//set your header here, you can add multiple headers //client.Headers["Content-Type"] = "application/x-www-form-urlencoded"; //System.Collections.Specialized.NameValueCollection formData = new System.Collections.Specialized.NameValueCollection(); //formData["ProjectMasterModel"] = pmm; //byte[] responseBytes = client.UploadValues(new Uri(Session["WebApiUrl"].ToString() + "api/ProjectMaster/"), "POST", formData); //string Result =System.Text.Encoding.UTF8.GetString(responseBytes); // string arr = client.DownloadString(string.Format("{0}api/User/{1}?&passWord={2}", Session["WebApiUrl"].ToString(), txtUserName.Text, txtPassword.Text)); // JavaScriptSerializer serializer = new JavaScriptSerializer(); // tbl_User user = serializer.Deserialize<tbl_User>(arr); //using (var client = new System.Net.Http.HttpClient()) //{ // //client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/"); // client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/ProjectMaster/"); // client.DefaultRequestHeaders.Accept.Clear(); // client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // var json = Newtonsoft.Json.JsonConvert.SerializeObject(pmm); // HttpContent content = new StringContent(json); // content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); // // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result; // var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", content).Result; // if (response.IsSuccessStatusCode) // { // // by calling .Result you are performing a synchronous call // var responseContent = response.Content; // // by calling .Result you are synchronously reading the result // rs = responseContent.ReadAsStringAsync().Result; // } //} //if (rs != "") //{ // this.MsgBox("Project Details Deleted Successfully..!!"); // ShowPanel(); // FillGridMain(); //} // rs = cl.GetValidate("Delete_Project", "1", "admin", HdnId.Value, ""); //if (rs != "") //{ // this.MsgBox("Project Details Deleted Successfully..!!"); // ShowPanel(); // FillGridMain(); //} } catch (Exception ex) { this.MsgBox(ex.Message.ToString()); } }
public bool Save() { string result = string.Empty; Project_Master pm = new Project_Master(); Project_Dept_PI pdi = new Project_Dept_PI(); List <Project_Dept_PI> pdlist = new List <Project_Dept_PI>(); Project_Coordinator_Details pcd = new Project_Coordinator_Details(); List <Project_Coordinator_Details> pcdList = new List <Project_Coordinator_Details>(); try { pm.i_ID = Convert.ToInt32(Common.iffBlank(HdnId.Value, 0)); TxtstartDate.Enabled = true; TxtDispProjId.Enabled = true; pm.Project_StartDate = TxtstartDate.Text; pm.s_Display_Project_ID = TxtDispProjId.Text == ""? Session["NewProjectId"].ToString():TxtDispProjId.Text; pm.s_Project_Title = Common.SetReplace(TxtprojTitle.Text); pm.s_Short_Title = Common.SetReplace(TxtShortTitle.Text); pm.s_Project_Alias1 = Common.SetReplace(TxtProjTitleAlias1.Text); pm.s_Project_Alias2 = Common.SetReplace(TxtProjTitleAlias2.Text); pm.s_Project_Desc = Common.SetReplace(TxtProjDescription.Text); pm.s_IRB_No = Common.SetReplace(TxtIRBno.Text); pm.i_Project_Category_ID = Convert.ToInt32(Common.iffBlank(ddlProjCategory.SelectedValue, 0)); pm.i_Project_Type_ID = Convert.ToInt32(Common.iffBlank(ddlProjType.SelectedValue, 0)); pm.i_Project_Subtype_ID = Convert.ToInt32(Common.iffBlank(ddlProjSubType.SelectedValue, 0)); pm.i_Parent_ProjectID = Convert.ToInt32(ddlParentProjName.SelectedValue); pm.b_IsFeasible = Convert.ToInt32(ddlFeasibilityStatus.SelectedValue); pm.b_Isselected_project = ddlselectedproject.SelectedValue == "0" ? false : true; pm.b_Collaboration_Involved = ddlCollbrationInv.SelectedValue == "0" ? false : true; pm.b_StartBy_TTSH = ddlstartbyTTSH.SelectedValue == "0" ? false : true; pm.b_Funding_req = ddlfundingReq.SelectedValue == "0" ? false : true; pm.b_Ischild = ddlChildParent.SelectedValue == "1" ? false : true; pm.s_Research_IO = txtResearchOrder.Text; pm.s_Research_IP = txtReserchInsurance.Text; //-------------pass tables to Sp------------------------- string[] PiIds = HdnPi_ID.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < PiIds.Length; i++) { pdlist.Add(new Project_Dept_PI { i_PI_ID = Convert.ToInt32(PiIds[i]) }); } string[] coOrIds = HdnCoordinatorId.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Where(i => Int32.Parse(i) > 0).Select(i => i.ToString()).ToArray(); string[] CoText = HdnCoordinatorText.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < coOrIds.Length; i++) { pcdList.Add(new Project_Coordinator_Details { i_Coordinator_ID = Convert.ToString(coOrIds[i]), s_Coordinator_name = CoText[i] }); } //--------UID and UName---- pm.UName = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserName"]), "").ToString(); pm.UID = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserID"]), "").ToString(); pm.i_ProjectStatus = Convert.ToInt32(ddlProjectStatus.SelectedValue); pm.Dt_ProjectEndDate = Convert.ToString(TxtProjectEndDate.Text); pm.b_EthicsNeeded = (ddlEthicsNeeded.SelectedItem.Text.ToLower() == "yes") ? true : false; //----------- END ------------ /*data owner*/ //pm.s_Ethics_DataOwner = (ddlDO_Ethics.SelectedValue != "0") ? ddlDO_Ethics.SelectedValue : null; //pm.s_Selected_DataOwner = (ddlDO_Selected.SelectedValue != "0") ? ddlDO_Selected.SelectedValue : null; //pm.s_Regulatory_DataOwner = (ddlDO_Regulatory.SelectedValue != "0") ? ddlDO_Regulatory.SelectedValue : null; //pm.s_Feasibility_DataOwner = (ddlDO_Feasibility.SelectedValue != "0") ? ddlDO_Feasibility.SelectedValue : null; //pm.s_Contract_DataOwner = (ddlDO_Contract.SelectedValue != "0") ? ddlDO_Contract.SelectedValue : null; //pm.s_Grant_DataOwner = (ddlDO_Grant.SelectedValue != "0") ? ddlDO_Grant.SelectedValue : null; /*data owner*/ //--------------------------------------------------------- //result = cl.Project_Master(pm, pdlist.ToArray(), pcdList.ToArray(), HdnMode.Value); //const string url = "http://localhost/ConsumingAPI/api/Products"; System.Collections.ArrayList paraMeters = new System.Collections.ArrayList(); paraMeters.Add(pm); paraMeters.Add(pdlist.ToArray()); paraMeters.Add(pcdList.ToArray()); paraMeters.Add(HdnMode.Value.ToString()); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, pdi = pdlist, pcd = pcdList, mode = HdnMode.Value }; var baseAddress = Session["WebApiUrl"].ToString() + "api/ProjectMaster/"; var http = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(new Uri(baseAddress)); http.Accept = "application/json"; http.ContentType = "application/json"; http.Method = "POST"; string parsedContent = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(pmm); ASCIIEncoding encoding = new ASCIIEncoding(); Byte[] bytes = encoding.GetBytes(parsedContent); System.IO.Stream newStream = http.GetRequestStream(); newStream.Write(bytes, 0, bytes.Length); newStream.Close(); var response = http.GetResponse(); var stream = response.GetResponseStream(); var sr = new StreamReader(stream); result = sr.ReadToEnd(); if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true) { switch (HdnMode.Value.ToLower()) { case "update": this.MsgBox("Project Details Updated Successfully"); break; case "delete": this.MsgBox("Project Details Deleted Successfully"); break; case "insert": this.MsgBox(" Project Details Saved Successfully"); break; } ShowPanel(); FillGridMain(); } else { this.MsgBox(result.Split('|')[1]); return(false); } } catch (Exception ex) { this.MsgBox(ex.ToString()); return(false); } return(true); }
//public void Post([FromBody]string value) // public string Post(Project_Master _Project_Master, List<Project_Dept_PI> pdi, List<Project_Coordinator_Details> pcd, string mode) public string Post([FromBody] ProjectMasterModel pmm) { string result = string.Empty; try { ProjectMasterModel pmm1 = pmm as ProjectMasterModel; //Newtonsoft.Json.JsonConvert.DeserializeObject<ProjectMasterModel>(parameters); Project_Master _Project_Master = pmm1._Project_Master; //Newtonsoft.Json.JsonConvert.DeserializeObject<Project_Master>(parameters[0].ToString()); string mode = pmm.mode; //Newtonsoft.Json.JsonConvert.DeserializeObject(parameters[4].ToString()).ToString(); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = Files.Config.ConnectionString; SqlCommand sqlCmd = new SqlCommand(); myConnection.Open(); sqlCmd.Connection = myConnection; sqlCmd.CommandType = System.Data.CommandType.StoredProcedure; sqlCmd.CommandText = "spProjectMasterDML"; sqlCmd.Parameters.Add("@StatementType", SqlDbType.VarChar); sqlCmd.Parameters["@StatementType"].Value = mode; sqlCmd.Parameters.Add("@i_ID", SqlDbType.Int); sqlCmd.Parameters["@i_ID"].Value = _Project_Master.i_ID; if (mode.ToString() != "Delete") { sqlCmd.Parameters.Add("@s_Display_Project_ID", SqlDbType.VarChar); sqlCmd.Parameters["@s_Display_Project_ID"].Value = _Project_Master.s_Display_Project_ID; sqlCmd.Parameters.Add("@s_Project_Title", SqlDbType.VarChar); sqlCmd.Parameters["@s_Project_Title"].Value = _Project_Master.s_Project_Title; sqlCmd.Parameters.Add("@s_Short_Title", SqlDbType.VarChar); sqlCmd.Parameters["@s_Short_Title"].Value = _Project_Master.s_Short_Title; sqlCmd.Parameters.Add("@i_Project_Category_ID", SqlDbType.Int); sqlCmd.Parameters["@i_Project_Category_ID"].Value = _Project_Master.i_Project_Category_ID; sqlCmd.Parameters.Add("@i_Project_Subtype_ID", SqlDbType.Int); sqlCmd.Parameters["@i_Project_Subtype_ID"].Value = _Project_Master.i_Project_Subtype_ID; sqlCmd.Parameters.Add("@b_Collaboration_Involved", SqlDbType.Bit); sqlCmd.Parameters["@b_Collaboration_Involved"].Value = _Project_Master.b_Collaboration_Involved; sqlCmd.Parameters.Add("@b_StartBy_TTSH", SqlDbType.Bit); sqlCmd.Parameters["@b_StartBy_TTSH"].Value = _Project_Master.b_StartBy_TTSH; sqlCmd.Parameters.Add("@i_Project_Type_ID", SqlDbType.Int); sqlCmd.Parameters["@i_Project_Type_ID"].Value = _Project_Master.i_Project_Type_ID; sqlCmd.Parameters.Add("@b_Funding_req", SqlDbType.Bit); sqlCmd.Parameters["@b_Funding_req"].Value = _Project_Master.b_Funding_req; sqlCmd.Parameters.Add("@b_Ischild", SqlDbType.Bit); sqlCmd.Parameters["@b_Ischild"].Value = _Project_Master.b_Ischild; sqlCmd.Parameters.Add("@i_Parent_ProjectID", SqlDbType.Int); sqlCmd.Parameters["@i_Parent_ProjectID"].Value = _Project_Master.i_Parent_ProjectID; sqlCmd.Parameters.Add("@s_Project_Alias1", SqlDbType.VarChar); sqlCmd.Parameters["@s_Project_Alias1"].Value = _Project_Master.s_Project_Alias1; sqlCmd.Parameters.Add("@s_Project_Alias2", SqlDbType.VarChar); sqlCmd.Parameters["@s_Project_Alias2"].Value = _Project_Master.s_Project_Alias2; sqlCmd.Parameters.Add("@s_Project_Desc", SqlDbType.VarChar); sqlCmd.Parameters["@s_Project_Desc"].Value = _Project_Master.s_Project_Desc; sqlCmd.Parameters.Add("@b_IsFeasible", SqlDbType.Int); sqlCmd.Parameters["@b_IsFeasible"].Value = _Project_Master.b_IsFeasible; sqlCmd.Parameters.Add("@b_Isselected_project", SqlDbType.Bit); sqlCmd.Parameters["@b_Isselected_project"].Value = _Project_Master.b_Isselected_project; sqlCmd.Parameters.Add("@s_IRB_No", SqlDbType.VarChar); sqlCmd.Parameters["@s_IRB_No"].Value = _Project_Master.s_IRB_No; sqlCmd.Parameters.Add("@s_Research_IO", SqlDbType.VarChar); sqlCmd.Parameters["@s_Research_IO"].Value = _Project_Master.s_Research_IO; sqlCmd.Parameters.Add("@s_Research_IP", SqlDbType.VarChar); sqlCmd.Parameters["@s_Research_IP"].Value = _Project_Master.s_Research_IP; sqlCmd.Parameters.Add("@Project_Dept_PI1", SqlDbType.VarChar); sqlCmd.Parameters["@Project_Dept_PI1"].Value = string.Join(",", pmm1.pdi.Select(x => x.i_PI_ID)).ToString(); sqlCmd.Parameters.Add("@i_ProjectStatusId", SqlDbType.Int); sqlCmd.Parameters["@i_ProjectStatusId"].Value = _Project_Master.i_ProjectStatus; sqlCmd.Parameters.Add("@Dt_ProjectEndDate", SqlDbType.VarChar); sqlCmd.Parameters["@Dt_ProjectEndDate"].Value = _Project_Master.Dt_ProjectEndDate; sqlCmd.Parameters.Add("@dt_ProjectStartDate1", SqlDbType.VarChar); sqlCmd.Parameters["@dt_ProjectStartDate1"].Value = _Project_Master.Project_StartDate; //parameter[parameter.Count - 1].Value = _Project_Master.Project_StartDate; //parameter[parameter.Count - 1].ParameterName = "@Dt_ProjectEndDate"; //parameter[parameter.Count - 1].Value = _Project_Master.Dt_ProjectEndDate; //----------Added by Atul //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@UserCID"; //parameter[parameter.Count - 1].Value = _Project_Master.UID; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@Username"; //parameter[parameter.Count - 1].Value = _Project_Master.UName; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@i_ProjectStatusId"; //parameter[parameter.Count - 1].Value = _Project_Master.i_ProjectStatus; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@Dt_ProjectEndDate"; //parameter[parameter.Count - 1].Value = _Project_Master.Dt_ProjectEndDate; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@b_EthicsNeeded"; //parameter[parameter.Count - 1].Value = _Project_Master.b_EthicsNeeded; ////----------End by Atul //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@dt_ProjectStartDate "; //parameter[parameter.Count - 1].Value = _Project_Master.Project_StartDate; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@Project_Dept_PI"; //parameter[parameter.Count - 1].Value = pdi.ListToDatatable().getColumns(1); //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@Project_Coordinator_Details"; //parameter[parameter.Count - 1].Value = pcd.ListToDatatable(); //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@s_Ethics_DO_ID"; //parameter[parameter.Count - 1].Value = _Project_Master.s_Ethics_DataOwner; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@s_Feasibility_DO_ID"; //parameter[parameter.Count - 1].Value = _Project_Master.s_Feasibility_DataOwner; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@s_Selected_DO_ID"; //parameter[parameter.Count - 1].Value = _Project_Master.s_Selected_DataOwner; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@s_Regulatory_DO_ID"; //parameter[parameter.Count - 1].Value = _Project_Master.s_Regulatory_DataOwner; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@s_Contract_DO_ID"; //parameter[parameter.Count - 1].Value = _Project_Master.s_Contract_DataOwner; //parameter.Add(_helper.CreateDbParameter()); //parameter[parameter.Count - 1].ParameterName = "@s_Grant_DO_ID"; //parameter[parameter.Count - 1].Value = _Project_Master.s_Grant_DataOwner; } sqlCmd.Parameters.Add("@Ret_Parameter", SqlDbType.VarChar); sqlCmd.Parameters["@Ret_Parameter"].Size = 500; sqlCmd.Parameters["@Ret_Parameter"].Direction = ParameterDirection.Output; sqlCmd.ExecuteNonQuery(); if (Int32.Parse(sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString()) > 0) { result = "Success" + " | " + sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString(); } else { result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString(); } myConnection.Close(); } catch (Exception ex) { } return(result); }
public bool Save() { string result = string.Empty; Project_Master pm = new Project_Master(); Project_Dept_PI pdi = new Project_Dept_PI(); List <Project_Dept_PI> pdlist = new List <Project_Dept_PI>(); Project_Coordinator_Details pcd = new Project_Coordinator_Details(); List <Project_Coordinator_Details> pcdList = new List <Project_Coordinator_Details>(); try { pm.i_ID = Convert.ToInt32(Common.iffBlank(HdnId.Value, 0)); TxtstartDate.Enabled = true; TxtDispProjId.Enabled = true; pm.Project_StartDate = TxtstartDate.Text; pm.s_Display_Project_ID = TxtDispProjId.Text; pm.s_Project_Title = Common.SetReplace(TxtprojTitle.Text); pm.s_Short_Title = Common.SetReplace(TxtShortTitle.Text); pm.s_Project_Alias1 = Common.SetReplace(TxtProjTitleAlias1.Text); pm.s_Project_Alias2 = Common.SetReplace(TxtProjTitleAlias2.Text); pm.s_Project_Desc = Common.SetReplace(TxtProjDescription.Text); pm.s_IRB_No = Common.SetReplace(TxtIRBno.Text); pm.i_Project_Category_ID = Convert.ToInt32(Common.iffBlank(ddlProjCategory.SelectedValue, 0)); pm.i_Project_Type_ID = Convert.ToInt32(Common.iffBlank(ddlProjType.SelectedValue, 0)); pm.i_Project_Subtype_ID = Convert.ToInt32(Common.iffBlank(ddlProjSubType.SelectedValue, 0)); pm.i_Parent_ProjectID = Convert.ToInt32(ddlParentProjName.SelectedValue); pm.b_IsFeasible = Convert.ToInt32(ddlFeasibilityStatus.SelectedValue); pm.b_Isselected_project = ddlselectedproject.SelectedValue == "0" ? false : true; pm.b_Collaboration_Involved = ddlCollbrationInv.SelectedValue == "0" ? false : true; pm.b_StartBy_TTSH = ddlstartbyTTSH.SelectedValue == "0" ? false : true; pm.b_Funding_req = ddlfundingReq.SelectedValue == "0" ? false : true; pm.b_Ischild = ddlChildParent.SelectedValue == "1" ? false : true; pm.s_Research_IO = txtResearchOrder.Text; pm.s_Research_IP = txtReserchInsurance.Text; //-------------pass tables to Sp------------------------- string[] PiIds = HdnPi_ID.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < PiIds.Length; i++) { pdlist.Add(new Project_Dept_PI { i_PI_ID = Convert.ToInt32(PiIds[i]) }); } string[] coOrIds = HdnCoordinatorId.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); string[] CoText = HdnCoordinatorText.Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => i.ToString()).ToArray(); for (int i = 0; i < coOrIds.Length; i++) { pcdList.Add(new Project_Coordinator_Details { i_Coordinator_ID = Convert.ToString(coOrIds[i]), s_Coordinator_name = CoText[i] }); } //--------UID and UName---- pm.UName = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserName"]), "").ToString(); pm.UID = Common.iffBlank(Convert.ToString(HttpContext.Current.Session["UserID"]), "").ToString(); pm.i_ProjectStatus = Convert.ToInt32(ddlProjectStatus.SelectedValue); pm.Dt_ProjectEndDate = Convert.ToString(TxtProjectEndDate.Text); pm.b_EthicsNeeded = (ddlEthicsNeeded.SelectedItem.Text.ToLower() == "yes") ? true : false; //----------- END ------------ /*data owner*/ //pm.s_Ethics_DataOwner = (ddlDO_Ethics.SelectedValue != "0") ? ddlDO_Ethics.SelectedValue : null; //pm.s_Selected_DataOwner = (ddlDO_Selected.SelectedValue != "0") ? ddlDO_Selected.SelectedValue : null; //pm.s_Regulatory_DataOwner = (ddlDO_Regulatory.SelectedValue != "0") ? ddlDO_Regulatory.SelectedValue : null; //pm.s_Feasibility_DataOwner = (ddlDO_Feasibility.SelectedValue != "0") ? ddlDO_Feasibility.SelectedValue : null; //pm.s_Contract_DataOwner = (ddlDO_Contract.SelectedValue != "0") ? ddlDO_Contract.SelectedValue : null; //pm.s_Grant_DataOwner = (ddlDO_Grant.SelectedValue != "0") ? ddlDO_Grant.SelectedValue : null; /*data owner*/ //--------------------------------------------------------- //result = cl.Project_Master(pm, pdlist.ToArray(), pcdList.ToArray(), HdnMode.Value); //const string url = "http://localhost/ConsumingAPI/api/Products"; System.Collections.ArrayList paraMeters = new System.Collections.ArrayList(); paraMeters.Add(pm); paraMeters.Add(pdlist.ToArray()); paraMeters.Add(pcdList.ToArray()); paraMeters.Add(HdnMode.Value.ToString()); ProjectMasterModel pmm = new ProjectMasterModel() { _Project_Master = pm, pdi = pdlist, pcd = pcdList, mode = HdnMode.Value }; //using (var client = new System.Net.Http.HttpClient()) //{ // // client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/"); // client.BaseAddress = new Uri(Session["WebApiUrl"].ToString() + "api/ProjectMaster/"); // client.DefaultRequestHeaders.Accept.Clear(); // client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // var json = Newtonsoft.Json.JsonConvert.SerializeObject(pmm); // HttpContent content = new StringContent(json); // content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); // // var response = client.PostAsJsonAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", pmm).Result; // var response = client.PostAsync(System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/", content).Result; // if (response.IsSuccessStatusCode) // { // // by calling .Result you are performing a synchronous call // var responseContent = response.Content; // // by calling .Result you are synchronously reading the result // result = responseContent.ReadAsStringAsync().Result; // } //} //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Add", string.Format("javascript:AddProjectMaster({0},{1})",pmm, System.Configuration.ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "api/ProjectMaster/"), true); if (result.Split('|')[0].ToLower().Trim() == "success" && result.Split('|')[1].ToLower().Trim().CheckInt() == true) { switch (HdnMode.Value.ToLower()) { case "update": this.MsgBox("Project Details Updated Successfully"); break; case "delete": this.MsgBox("Project Details Deleted Successfully"); break; case "insert": this.MsgBox(" Project Details Saved Successfully"); break; } ShowPanel(); FillGridMain(); } else { this.MsgBox(result.Split('|')[1]); return(false); } } catch (Exception ex) { this.MsgBox(ex.ToString()); return(false); } return(true); }
protected void NewLink_Command(object sender, CommandEventArgs e) { try { projectGrid.Visible = false; //To reset all the controls ResetControls(); EthicsContainer.Visible = true; PopulateDropDown(); btnUpdateEthics.Visible = false; btnSaveEthics.Visible = true; txtEthicsStartDate.Enabled = true; TTSHWCFReference.Project_Master project = new Project_Master(); int project_id = Convert.ToInt32(e.CommandArgument); HttpContext.Current.Session["ProjectID"] = project_id; TTSHWCFServiceClient client = new TTSHWCFServiceClient(); project = client.GetProject_MasterDetailsByID(project_id); txtProjectTitle.Text = project.s_Project_Title; txtShortTitle.Text = project.s_Short_Title; ddlProjectCategory.SelectedValue = project.i_Project_Category_ID.ToString(); txtAlias1.Text = project.s_Project_Alias1; txtAlias2.Text = project.s_Project_Alias2; bProjectID.InnerText = "Project ID: " + project.s_Display_Project_ID; txtSubRecruited.Text = "0"; txtSubTargeted.Text = "0"; txtGlobalSubRecruited.Text = "0"; txtGlobalSubTargeted.Text = "0"; txtEthicsStartDate.Text = DateTime.Now.ToString("dd-MMM-yyyy"); string CoInvest = project.s_Coinvestigator.ToString(); //Parse xml and bind co investigator details if (CoInvest != string.Empty) { using (XmlReader reader = XmlReader.Create(new StringReader(CoInvest))) { XmlDocument xml = new XmlDocument(); xml.Load(reader); XmlNodeList xmlNodeList = xml.SelectNodes("/COINVESTIGATOR_D/COINVESTIGATOR"); foreach (XmlNode node in xmlNodeList) { string id = node["ID"] == null ? "" : node["ID"].InnerText; if (id == "" || id == "0") { txtCoInvestigator.Enabled = false; } else { txtCoInvestigator.Text = node["Coinves_name"] == null ? "" : node["Coinves_name"].InnerText; txtCoInvestigator.Enabled = true; } } } } else { txtCoInvestigator.Enabled = false; } txtIRBNumber.Text = project.s_IRB_No.ToString(); FillPIGrid(project.DEPT_PI.ToList()); } catch (Exception) { throw; } }
protected void GetProjectDetailsAtNew() { TTSHWCFServiceClient cl = new TTSHWCFServiceClient(); Project_Master plist = new Project_Master(); List<PI_Master> List_DEPT_PI = new List<PI_Master>(); try { plist = cl.GetProject_MasterDetailsByID(Convert.ToInt32(Common.iffBlank(HdnProject_Id.Value, 0))); TxtProjTitle.Text = plist.s_Project_Title; TxtAlias1.Text = plist.s_Project_Alias1; TxtShortTitle.Text = plist.s_Short_Title; TxtprojCategory.Text = plist.Project_Category_Name; TxtAlias2.Text = plist.s_Project_Alias2; TxtIrbNo.Text = plist.s_IRB_No; DispProjectId.InnerText = plist.s_Display_Project_ID; List_DEPT_PI = plist.DEPT_PI.ToList(); rptrPIDetails.DataSource = List_DEPT_PI; rptrPIDetails.DataBind(); } catch (Exception) { throw; } }