/// <summary> /// Used to get the drop Domain List /// </summary> /// <returns></returns> public JsonResult GetDomain() { try { BLMaster objMaster = new BLMaster(); ProjectMasterModel objprojectdomain = new ProjectMasterModel(); objprojectdomain.Company_Code = _objcurrentInfo.GetCompanyCode(); IEnumerable <ProjectMasterModel> lstprojectdomain = objMaster.GetDomain(objprojectdomain); var DivisionList = (from division in lstprojectdomain.AsEnumerable() select new ProjectMasterModel() { Domain_Name = division.Domain_Name, Domain_Code = division.Domain_Code }).ToList <ProjectMasterModel>(); return(Json(DivisionList)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return(null); } }
public ActionResult Delete(int?id) { try { if (id == null) { return(Json(new { success = false })); } ViewBag.GrantList = DropdownList.GrantList(); ViewBag.ResearchList = DropdownList.ResearchList(); ViewBag.ResearchTypeList = DropdownList.ResearchTypeList(); ProjectMasterModel existingModel = DB.ProjectMaster.Where(x => x.ProjectID == id).FirstOrDefault(); existingModel.IsActive = false; DB.ProjectMaster.Attach(existingModel); DB.Entry(existingModel).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); return(Json(new { success = true })); } catch (Exception ex) { LogHelper.ErrorLog(ex); throw ex; } }
public ActionResult ProjectEdit(int id) { ProjectMasterModel data = new ProjectMasterModel(); data.AllProjects = data.GetAllProjectList(id); CallList(); return(View(data)); }
public ActionResult ProjectList() { //GetPropertyData propertydata = new GetPropertyData(); ProjectMasterModel data = new ProjectMasterModel(); data.AllProjects = data.GetAllProjectList(); return(View(data)); }
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()); } }
public ActionResult SearchEmployee(ProjectMasterModel PMM) { try { return(null); } catch (Exception ex) { LogHelper.ErrorLog(ex); throw ex; } }
public ActionResult ProjectEdit(ProjectMasterModel PMM) { //MainPageModel data = new MainPageModel(); //GetPropertyData propertydata = new GetPropertyData(); int id = PMM.AllProjects[0].ProjectID; bool status = false; try { //if (ModelState.IsValid) //{ ProjectMasterModel pm = new ProjectMasterModel(); status = pm.UpdateProject(PMM); ModelState.Clear(); //} //else //{ //} } catch { } if (status == true) { ProjectMasterModel data = new ProjectMasterModel(); data.AllProjects = data.GetAllProjectList(id); CallList(); //Contact(); ViewBag.Message = "Data Saved Sucessfuly"; return(View(data)); } else { ProjectMasterModel data = new ProjectMasterModel(); data.AllProjects = data.GetAllProjectList(id); CallList(); ViewBag.Message = "Ah... somthing wrong, Please try after sometime"; return(View(data)); } }
/// <summary> /// Method is Used to Get the Project Master Details /// </summary> /// <returns></returns> private IEnumerable <ProjectMasterModel> GetProjectDetails() { try { ProjectMasterModel objprojectmastermodel = new ProjectMasterModel(); objprojectmastermodel.Company_Code = _objcurrentInfo.GetCompanyCode(); BLMaster objMaster = new BLMaster(); return(objMaster.GetProjectDetails(objprojectmastermodel)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return(null); } }
public ActionResult Edit() { try { int ProjectId = Convert.ToInt16(Session["ProjectId"]); ViewBag.GrantList = DropdownList.GrantList(); ViewBag.ResearchList = DropdownList.ResearchList(); ViewBag.ResearchTypeList = DropdownList.ResearchTypeList(); ProjectMasterModel projectmasterlist = DB.ProjectMaster.Where(x => x.ProjectID == ProjectId).FirstOrDefault(); Session["ProjectDetails"] = projectmasterlist; //return Json(new { data= projectmasterlist }); return(RedirectToAction("ProjectEdit", "ProjectMaster")); } catch (Exception ex) { LogHelper.ErrorLog(ex); throw ex; } }
public ActionResult ProjectCreate(ProjectMasterModel PMM) { //MainPageModel data = new MainPageModel(); //GetPropertyData propertydata = new GetPropertyData(); bool status = false; try { if (ModelState.IsValid) { ProjectMasterModel pm = new ProjectMasterModel(); status = pm.InsertProject(PMM); ModelState.Clear(); } else { } } catch { } if (status == true) { CallList(); //Contact(); ViewBag.Message = "Data Saved Sucessfuly"; return(View()); } else { CallList(); ViewBag.Message = "Ah... somthing wrong, Please try after sometime"; return(View()); } }
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 ActionResult Save(ProjectMasterModelNew model) { try { GetDefaults(); List <KeyValuePair <KeyValuePair <long, string>, KeyValuePair <decimal, int> > > empPercentageStatus = new List <KeyValuePair <KeyValuePair <long, string>, KeyValuePair <decimal, int> > >(); if (!string.IsNullOrEmpty(model.ProjectMembers)) { string[] empList = model.ProjectMembers.Split(','); string[] empNames = model.ProjectMembersNames.Split(','); for (int i = 0; i < empList.Length; i++) { long empId = Convert.ToInt64(empList[i]); string empName = empNames[i]; List <int> totalInvolvement = DB.Employee.Where(x => x.EmployeeID == empId).Select(x => x.TotalInvolvement ?? 100).ToList(); decimal? currentInvolvement = (from x in DB.ProjectEmployee join y in DB.ProjectMaster on x.ProjectID equals y.ProjectID where x.EmployeeID == empId && (x.EndDate >= DateTime.Now || !x.EndDate.HasValue) && x.ProjectID != model.ProjectID select x.InvPercentage).Sum(); // = currentInvolvement + EPL.InvPercentage; if (currentInvolvement + model.InvPercentage > totalInvolvement[0]) { empPercentageStatus.Add(new KeyValuePair <KeyValuePair <long, string>, KeyValuePair <decimal, int> >(new KeyValuePair <long, string>(empId, empName), new KeyValuePair <decimal, int>(currentInvolvement.Value, totalInvolvement[0]))); } } } StringBuilder errorMessage = new StringBuilder(); if (empPercentageStatus.Any()) { foreach (KeyValuePair <KeyValuePair <long, string>, KeyValuePair <decimal, int> > item in empPercentageStatus) { errorMessage.Append($"Emplyee {item.Key.Value} has exceeded the maximum allocation , current allocation is {item.Value.Key} , maximum allocation is {item.Value.Value} and Available allocation is { item.Value.Value - item.Value.Key } line line"); } ViewBag.Message = errorMessage.ToString(); } else { ModelState.Remove("ProjectID"); // model.ValidateModel(ModelState); model.MemberProjectGrant = model.ProjectGrant; Session["ProjectGrant"] = model.ProjectGrant; model.IsActive = true; if (model.Theme.HasValue) { var eligibleThemeGrants = ConfigurationManager.AppSettings["ThemeGrandCodes"].ToString().Split(',').ToList(); var themeMstType = Convert.ToInt32(ConfigurationManager.AppSettings["TypeGrant"]); var themes = DB.MasterData.Where(x => x.MstTypeID == themeMstType && eligibleThemeGrants.Contains(x.MstCode)).Select(x => x.MstID); if (!themes.Contains(model.ProjectGrant)) { model.Theme = null; } } ProjectMasterModel newModel = new ProjectMasterModel { ProjectID = model.ProjectID, ProjectCode = model.ProjectCode, ProjectName = model.ProjectName, ProjectDesc = model.ProjectDesc, InternalOrder = model.InternalOrder, CostCentre = model.CostCentre, ProjectGrant = model.ProjectGrant, ResearchArea = model.ResearchArea, TypeofResearch = model.TypeofResearch, StartDate = model.StartDate, EndDate = model.EndDate, ProjectDuration = model.ProjectDuration, IsActive = true, IsRDProject = model.IsRDProject, Theme = model.Theme }; DB.ProjectMaster.Add(newModel); DB.SaveChanges(); long projectId = DB.ProjectMaster.Where(x => x.ProjectCode == model.ProjectCode).Select(x => x.ProjectID).FirstOrDefault(); string projectName = DB.ProjectMaster.Where(x => x.ProjectCode == model.ProjectCode).Select(x => x.ProjectName).FirstOrDefault(); Session["pId"] = projectId; Session["pName"] = projectName; TempData["projectid"] = 1; TempData["Success"] = ResourceMessage.NewProjectAdd; Session["ProjectGrant"] = model.ProjectGrant; if (!string.IsNullOrEmpty(model.ProjectMembers)) { model.ProjectID = projectId; model.IsActive = true; foreach (string item in model.ProjectMembers.Split(',')) { EmployeeModel refRole = DB.Employee.FirstOrDefault(x => x.EmployeeID.ToString() == item); List <EmployeeProjectList> GetDetails = DB.Database.SqlQuery <EmployeeProjectList>( @"exec " + Constants.P_InsertProjectEmployee + " @ProjectId,@EmployeeID,@CheckRole,@InvPercentage,@RefRole,@StartDate,@EndDate,@Grant,@IsActive,@CreatedBy", new object[] { new SqlParameter("@ProjectId", model.ProjectID), new SqlParameter("@EmployeeID", item), new SqlParameter("@CheckRole", model.CheckRole), new SqlParameter("@InvPercentage", model.InvPercentage), new SqlParameter("@RefRole", model.IsRDProject == 1 ? (refRole.RoleID ?? 0) : 0), new SqlParameter("@StartDate", model.StartDate), new SqlParameter("@EndDate", model.EndDate), new SqlParameter("@Grant", model.ProjectGrant), new SqlParameter("@IsActive", model.IsActive), new SqlParameter("@CreatedBy", Session["EmployeeId"].ToString()) }).ToList(); if (model.IsRDProject == 1 && refRole.RoleID == null) { ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } Role is blank, please modify manually or contact administrator"; } if (!string.IsNullOrEmpty(refRole.Email)) { if (!DB.User.Any(x => x.Email == refRole.Email)) { UserModel user = new UserModel { Email = refRole.Email, CreatedBy = 1, CreatedDate = DateTime.Now, IsActive = true, Password = "******", RoleID = model.CheckRole ? Convert.ToInt64(ReadConfig.GetValue("RolePM")) : Convert.ToInt64(ReadConfig.GetValue("RoleEmployee")) }; DB.User.Add(user); DB.SaveChanges(); refRole.UserID = user.UserID; DB.Employee.Attach(refRole); DB.Entry(refRole).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } } else { ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } email is blank, please contact administrator"; } } } TempData.Add("ProjectCreated", $"{model.ProjectName } is created successfully"); return(RedirectToAction("Index", "ProjectMain")); } } catch (Exception ex) { TempData["Error"] = ex.ToString(); LogHelper.ErrorLog(ex); } return(View("Index", model)); }
public ActionResult Save(ProjectMasterModelNew model) { try { GetDefaults(); JavaScriptSerializer json_serializer = new JavaScriptSerializer(); var modifiedOrNewEmpList = json_serializer.Deserialize <EmployeeProjectList[]>(model.EmployeeProjectList); ModelState.Remove("ProjectID"); // model.ValidateModel(ModelState); model.MemberProjectGrant = model.ProjectGrant; Session["ProjectGrant"] = model.ProjectGrant; model.IsActive = true; if (model.Theme.HasValue) { var eligibleThemeGrants = ConfigurationManager.AppSettings["ThemeGrandCodes"].ToString().Split(',').ToList(); var themeMstType = Convert.ToInt32(ConfigurationManager.AppSettings["TypeGrant"]); var themes = DB.MasterData.Where(x => x.MstTypeID == themeMstType && eligibleThemeGrants.Contains(x.MstCode)).Select(x => x.MstID); if (!themes.Contains(model.ProjectGrant)) { model.Theme = null; } } ProjectMasterModel newModel = new ProjectMasterModel { ProjectID = model.ProjectID, ProjectCode = model.ProjectCode, ProjectName = model.ProjectName, ProjectDesc = model.ProjectDesc, InternalOrder = model.InternalOrder, CostCentre = model.CostCentre, ProjectGrant = model.ProjectGrant, ResearchArea = model.ResearchArea, TypeofResearch = model.TypeofResearch, StartDate = model.StartDate, EndDate = model.EndDate, ProjectDuration = model.ProjectDuration, IsActive = true, IsRDProject = model.IsRDProject, Theme = model.Theme }; DB.ProjectMaster.Add(newModel); DB.SaveChanges(); long projectId = DB.ProjectMaster.Where(x => x.ProjectCode == model.ProjectCode).Select(x => x.ProjectID).FirstOrDefault(); string projectName = DB.ProjectMaster.Where(x => x.ProjectCode == model.ProjectCode).Select(x => x.ProjectName).FirstOrDefault(); Session["pId"] = projectId; Session["pName"] = projectName; TempData["projectid"] = 1; TempData["Success"] = ResourceMessage.NewProjectAdd; Session["ProjectGrant"] = model.ProjectGrant; if (modifiedOrNewEmpList.Any()) { model.ProjectID = projectId; model.IsActive = true; foreach (var item in modifiedOrNewEmpList) { EmployeeModel refRole = DB.Employee.FirstOrDefault(x => x.EmployeeID == item.EmployeeID); List <EmployeeProjectList> GetDetails = DB.Database.SqlQuery <EmployeeProjectList>( @"exec " + Constants.P_InsertProjectEmployee + " @ProjectId,@EmployeeID,@CheckRole,@InvPercentage,@RefRole,@StartDate,@EndDate,@Grant,@IsActive,@CreatedBy", new object[] { new SqlParameter("@ProjectId", model.ProjectID), new SqlParameter("@EmployeeID", item.EmployeeID), new SqlParameter("@CheckRole", item.IsManager), new SqlParameter("@InvPercentage", item.InvPercentage), new SqlParameter("@RefRole", model.IsRDProject == 1 ? (refRole.RoleID ?? 0) : 0), new SqlParameter("@StartDate", item.StartDate), new SqlParameter("@EndDate", item.EndDate), new SqlParameter("@Grant", model.ProjectGrant), new SqlParameter("@IsActive", model.IsActive), new SqlParameter("@CreatedBy", Session["EmployeeId"].ToString()) }).ToList(); if (model.IsRDProject == 1 && refRole.RoleID == null) { ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } Role is blank, please modify manually or contact administrator"; } if (!string.IsNullOrEmpty(refRole.Email)) { if (!DB.User.Any(x => x.Email == refRole.Email)) { UserModel user = new UserModel { Email = refRole.Email, CreatedBy = 1, CreatedDate = DateTime.Now, IsActive = true, Password = "******", RoleID = item.IsManager ? Convert.ToInt64(ReadConfig.GetValue("RolePM")) : Convert.ToInt64(ReadConfig.GetValue("RoleEmployee")) }; DB.User.Add(user); DB.SaveChanges(); refRole.UserID = user.UserID; DB.Employee.Attach(refRole); DB.Entry(refRole).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } } else { ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } email is blank, please contact administrator"; } } } TempData.Add("ProjectCreated", $"{model.ProjectName } is created successfully"); return(RedirectToAction("Index", "ProjectMain")); } catch (Exception ex) { TempData["Error"] = ex.ToString(); LogHelper.ErrorLog(ex); } return(View("Index", model)); }
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; } }
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" }; //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 ProjectMasterModel Get(int id) { List <PI_Master> piList = new List <PI_Master>(); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = @"Data Source=192.168.0.110;Initial Catalog=TTSHTemp;User ID=sa;Password=ROOT#123"; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = System.Data.CommandType.StoredProcedure; sqlCmd.CommandText = "spProjectMasterDML"; sqlCmd.Parameters.Add("@StatementType", SqlDbType.VarChar); sqlCmd.Parameters["@StatementType"].Value = "select"; sqlCmd.Parameters.Add("@i_ID", SqlDbType.Int); sqlCmd.Parameters["@i_ID"].Value = id; sqlCmd.Connection = myConnection; myConnection.Open(); reader = sqlCmd.ExecuteReader(); ProjectMasterModel project_Master = null; project_Master = new ProjectMasterModel(); project_Master.DEPT_PI = new List <PI_Master>(); project_Master.pcd = new List <Project_Coordinator_Details>(); while (reader.Read()) { if (reader["i_Dept_ID"] != DBNull.Value) { project_Master.DEPT_PI.Add(new PI_Master() { i_Dept_ID = (reader["i_Dept_ID"] != DBNull.Value)? Convert.ToInt32(reader["i_Dept_ID"]):0, i_ID = (reader["PI_ID"] != DBNull.Value)? Convert.ToInt32(reader["PI_ID"]):0, s_Email = (reader["s_Email"] != DBNull.Value) ? reader["s_Email"].ToString() : "", s_Phone_no = (reader["s_Phone_no"] != DBNull.Value) ?reader["s_Phone_no"].ToString():"", s_MCR_No = (reader["s_MCR_No"] != DBNull.Value ? reader["s_MCR_No"].ToString():""), s_DeptName = (reader["Dept_Name"] != DBNull.Value ? reader["Dept_Name"].ToString():""), s_PIName = (reader["s_PI_Name"] != DBNull.Value ? reader["s_PI_Name"].ToString() : "") }); } if (reader["i_Coordinator_ID"] != DBNull.Value) { project_Master.pcd.Add(new Project_Coordinator_Details() { i_Coordinator_ID = reader["i_Coordinator_ID"] != DBNull.Value ? reader["i_Coordinator_ID"].ToString() : "", s_Coordinator_name = reader["s_Coordinator_name"] != DBNull.Value ? reader["s_Coordinator_name"].ToString() : "" }); } project_Master._Project_Master = new tblProject_Master(); project_Master._Project_Master.i_ID = (reader["i_ID"] != DBNull.Value ? Convert.ToInt32(reader["i_ID"]) : 0); project_Master._Project_Master.s_Display_Project_ID = (reader["s_Display_Project_ID"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Display_Project_ID"])); project_Master._Project_Master.s_Project_Title = (reader["s_Project_Title"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Project_Title"])); project_Master._Project_Master.s_Short_Title = (reader["s_Short_Title"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Short_Title"])); project_Master._Project_Master.i_Project_Category_ID = (reader["i_Project_Category_ID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["i_Project_Category_ID"])); project_Master._Project_Master.i_Project_Type_ID = (reader["i_Project_Type_ID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["i_Project_Type_ID"])); project_Master._Project_Master.i_Project_Subtype_ID = (reader["i_Project_Subtype_ID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["i_Project_Subtype_ID"])); project_Master._Project_Master.b_Collaboration_Involved = (reader["b_Collaboration_Involved"] == DBNull.Value ? false : Convert.ToBoolean(reader["b_Collaboration_Involved"])); project_Master._Project_Master.b_StartBy_TTSH = (reader["b_StartBy_TTSH"] == DBNull.Value ? false : Convert.ToBoolean(reader["b_StartBy_TTSH"])); project_Master._Project_Master.b_Funding_req = (reader["b_Funding_req"] == DBNull.Value ? false : Convert.ToBoolean(reader["b_Funding_req"])); project_Master._Project_Master.b_Ischild = (reader["b_Ischild"] == DBNull.Value ? false : Convert.ToBoolean(reader["b_Ischild"])); project_Master._Project_Master.i_Parent_ProjectID = (reader["i_Parent_ProjectID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["i_Parent_ProjectID"])); project_Master._Project_Master.s_Project_Alias1 = (reader["s_Project_Alias1"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Project_Alias1"])); project_Master._Project_Master.s_Project_Alias2 = (reader["s_Project_Alias2"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Project_Alias2"])); project_Master._Project_Master.s_Project_Desc = (reader["s_Project_Desc"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Project_Desc"])); project_Master._Project_Master.Project_Category_Name = (reader["Project_Category_Name"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Project_Category_Name"])); project_Master._Project_Master.b_IsFeasible = (reader["b_IsFeasible"] == DBNull.Value ? 0 : Convert.ToInt32(reader["b_IsFeasible"])); project_Master._Project_Master.b_Isselected_project = (reader["b_Isselected_project"] == DBNull.Value ? false : Convert.ToBoolean(reader["b_Isselected_project"])); project_Master._Project_Master.s_IRB_No = (reader["s_IRB_No"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_IRB_No"])); project_Master._Project_Master.s_Research_IO = (reader["s_Research_IO"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Research_IO"])); project_Master._Project_Master.s_Research_IP = (reader["s_Research_IP"] == DBNull.Value ? string.Empty : Convert.ToString(reader["s_Research_IP"])); project_Master._Project_Master.Project_StartDate = reader["dt_ProjectStartDate"] == DBNull.Value? string.Empty : Convert.ToString(reader["dt_ProjectStartDate"]); project_Master._Project_Master.i_ProjectStatus = (reader["i_ProjectStatusID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["i_ProjectStatusID"])); project_Master._Project_Master.Dt_ProjectEndDate = reader["dt_ProjectEndDate"] == DBNull.Value ? string.Empty : Convert.ToString(reader["dt_ProjectEndDate"]); //project_Master._Project_Master.s_Coinvestigator = (reader["s_Coinvestigator") ? string.Empty : Convert.ToString(reader["s_Coinvestigator"])); //project_Master._Project_Master.s_Contract_DataOwner = (reader["DO_Contract") ? string.Empty : Convert.ToString(reader["DO_Contract"])); //project_Master._Project_Master.s_Ethics_DataOwner = (reader["DO_Ethics") ? string.Empty : Convert.ToString(reader["DO_Ethics"])); //project_Master._Project_Master.s_Grant_DataOwner = (reader["DO_Grant") ? string.Empty : Convert.ToString(reader["DO_Grant"])); //project_Master._Project_Master.s_Feasibility_DataOwner = (reader["DO_Feasibility") ? string.Empty : Convert.ToString(reader["DO_Feasibility"])); //project_Master._Project_Master.s_Regulatory_DataOwner = (reader["DO_Regulatory") ? string.Empty : Convert.ToString(reader["DO_Regulatory"])); // project_Master._Project_Master.s_Selected_DataOwner = (reader["DO_Selected") ? string.Empty : Convert.ToString(reader["DO_Selected"])); //project_Master._Project_Master.Dt_ProjectEndDate = (reader["dt_ProjectEndDate") ? string.Empty : Convert.ToString(reader["dt_ProjectEndDate"])); //project_Master._Project_Master.b_EthicsNeeded = (reader["b_EthicsNeeded") ? false : Convert.ToBoolean(reader["b_EthicsNeeded"])); } myConnection.Close(); return(project_Master); }
//public void Post([FromBody]string value) // public string Post(tblProject_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); tblProject_Master _Project_Master = pmm1._Project_Master; //Newtonsoft.Json.JsonConvert.DeserializeObject<tblProject_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 = @"Data Source=192.168.0.110;Initial Catalog=TTSHTemp;User ID=sa;Password=ROOT#123"; // myConnection.ConnectionString=System.Con 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==""? 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; }
/// <summary> /// Insert and Update /// </summary> /// <param name="projectName"></param> /// <param name="ProjectLeadcode"></param> /// <param name="ProjectLeadName"></param> /// <param name="client"></param> /// <param name="domain"></param> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="remarks"></param> /// <param name="Mode"></param> /// <param name="projectCodeVal"></param> /// <returns></returns> public int InsertandUpdateProjectDetails(string projectName, string ProjectLeadcode, string ProjectLeadName, string client, string domain, string startDate, string endDate, string remarks, string Mode, string projectCodeVal) { try { BLMaster Master = new BLMaster(); ProjectMasterModel objprojectmastermodel = new ProjectMasterModel(); List <ProjectMasterModel> lstprojectmaster = new List <ProjectMasterModel>(); if (Mode.ToUpper() == "I") // Insert Data { if (string.IsNullOrEmpty(remarks)) { remarks = ""; } objprojectmastermodel.Company_Code = _objcurrentInfo.GetCompanyCode(); objprojectmastermodel.Project_Name = projectName; objprojectmastermodel.Project_Lead_Code = ProjectLeadcode; objprojectmastermodel.Project_Lead_Name = ProjectLeadName; objprojectmastermodel.Client_Code = client; objprojectmastermodel.Domain_Code = domain; objprojectmastermodel.Start_Date = startDate; objprojectmastermodel.End_Date = endDate; objprojectmastermodel.Status = "1"; objprojectmastermodel.Remarks = remarks; objprojectmastermodel.Created_By = _objcurrentInfo.GetUserName(); objprojectmastermodel.Created_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstprojectmaster.Add(objprojectmastermodel); int result = Master.InsertforProjectMaster(lstprojectmaster); return(result); } else { if (string.IsNullOrEmpty(remarks)) { remarks = ""; } objprojectmastermodel.Company_Code = _objcurrentInfo.GetCompanyCode(); objprojectmastermodel.Project_Code = projectCodeVal; objprojectmastermodel.Project_Name = projectName; objprojectmastermodel.Project_Lead_Code = ProjectLeadcode; objprojectmastermodel.Project_Lead_Name = ProjectLeadName; objprojectmastermodel.Client_Code = client; objprojectmastermodel.Domain_Code = domain; objprojectmastermodel.Start_Date = startDate; objprojectmastermodel.End_Date = endDate; objprojectmastermodel.Remarks = remarks; objprojectmastermodel.Updated_By = _objcurrentInfo.GetUserName(); objprojectmastermodel.Updated_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstprojectmaster.Add(objprojectmastermodel); int result = Master.UpdateforProjectMaster(lstprojectmaster); return(result); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:projectName", projectName); dicContext.Add("Filter:startDate", startDate); dicContext.Add("Filter:endDate", endDate); dicContext.Add("Filter:Mode", Mode); dicContext.Add("Filter:ProjectLeadcode", ProjectLeadcode); dicContext.Add("Filter:ProjectLeadName", ProjectLeadName); dicContext.Add("Filter:v", client); dicContext.Add("Filter:domain", domain); dicContext.Add("Filter:ProjectLeadName", ProjectLeadName); dicContext.Add("Filter:client", client); dicContext.Add("Filter:remarks", remarks); dicContext.Add("Filter:projectCodeVal", projectCodeVal); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(0); } }
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 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; } }