/// <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());
}
}
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 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);
}
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;
}
/// <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;
}
}
