protected void gridViewOrganisms_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName != "Page")
{
ProjectBLL projectBLL = new ProjectBLL();
Project project = projectBLL.GetProjectByProjectID(Convert.ToInt32(Page.RouteData.Values["project_id"]));
OrganismBLL organismBLL = new OrganismBLL();
Organism organism = organismBLL.GetOrganismByOrganismID(Convert.ToInt32(e.CommandArgument));
Project_OrganismsBLL project_OrganismsBLL = new Project_OrganismsBLL();
Project_Organisms project_Organism = new Project_Organisms();
project_Organism.ProjectID = project.ProjectID;
project_Organism.ProjectReference.EntityKey = project.EntityKey;
project_Organism.OrganismID = organism.OrganismID;
project_Organism.OrganismReference.EntityKey = organism.EntityKey;
project_Organism.CreatedDate = DateTime.Now;
project_Organism.EditedDate = DateTime.Now;
project_OrganismsBLL.CreateNewProject_Organisms(project_Organism);
Response.RedirectToRoute("organismsinproject", new { project_id = (Page.RouteData.Values["project_id"] as string) });
}
}
private void GetProjectDetails()
{
ProjectBLL objProjectBLL = new ProjectBLL();
ProjectBO objProject = objProjectBLL.GetProjectByProjectID(Convert.ToInt32(Session["PROJECT_ID"]));
ddlProject.Text = objProject.ProjectCode;
}
/// <summary>
/// Method to fetch currency format from database
/// </summary>
public void getBudgetEstimationfromProject()
{
ProjectBLL objProjectBLL = new ProjectBLL();
ProjectBO objProject = objProjectBLL.GetProjectByProjectID(Convert.ToInt32(Session["PROJECT_ID"]));
TBSTextBox.Text = UtilBO.CurrencyFormat(objProject.TotalEstBudget);
BudgetEstimationIDTextBox.Text = "0";
}
protected void Page_Load(object sender, EventArgs e)
{
string projectID = (Page.RouteData.Values["project_id"] as string);
this.hfProjectID.Value = projectID;
ProjectBLL projectBLL = new ProjectBLL();
Project project = projectBLL.GetProjectByProjectID(Convert.ToInt32(projectID));
lblProjectName.Text = project.ProjectName;
}
/// <summary>
/// To get the Project Deatails
/// </summary>
private void GetProjectDetails()
{
ProjectBO oProjectBO = new ProjectBO();
ProjectBLL oProjectBLL = new ProjectBLL();
int ProjectID = 0;
if (Session["PROJECT_ID"] != null)
{
ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
oProjectBO = oProjectBLL.GetProjectByProjectID(ProjectID);
hdnProjectStartDate.Value = oProjectBO.projectStartDate.ToString("dd/MM/yyyy");
hdnProjectEndDate.Value = oProjectBO.ProjectEndDate.ToString("dd/MM/yyyy");
}
}
/// <summary>
/// getProjectDtaes
/// </summary>
private void getProjectDtaes()
{
ProjectBLL objProjectBLL = new ProjectBLL();
ProjectBO objProject = objProjectBLL.GetProjectByProjectID(Convert.ToInt32(Session["PROJECT_ID"]));
if (objProject.ProjectStartDate != DateTime.MinValue)
{
hfProjStartDate.Value = Convert.ToString(objProject.ProjectStartDate.ToString(UtilBO.DateFormat));
}
if (objProject.ProjectEndDate != DateTime.MinValue)
{
hfProjEndDate.Value = Convert.ToString(objProject.ProjectEndDate.ToString(UtilBO.DateFormat));
}
}
private void GetRelevantDetails()
{
int ProjectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
int HHID = Convert.ToInt32(Request.QueryString["HHID"]);
ProjectBLL ProjectBLL = new ProjectBLL();
PAP_HouseholdBLL PAP_HouseholdBLL = new PAP_HouseholdBLL();
ProjectBO ProjectBO = new ProjectBO();
PAP_HouseholdBO PAP_HouseholdBO = new PAP_HouseholdBO();
ProjectBO = ProjectBLL.GetProjectByProjectID(ProjectID);
PAP_HouseholdBO = PAP_HouseholdBLL.GetHouseHoldData(HHID);
txtHHID.Text = PAP_HouseholdBO.HhId.ToString();
txtPapName.Text = PAP_HouseholdBO.PapName.ToString();
txtProjectName.Text = ProjectBO.ProjectName.ToString();
}
/// <summary>
/// Get the Pap Details For Tooltip
/// </summary>
/// <returns></returns>
public string GetPapData()
{
string sPapdata = "";
int HHID = 0;
if (Request.QueryString["HHID"] != null)
{
HHID = Convert.ToInt32(Request.QueryString["HHID"].ToString());
}
if (HHID > 0)
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHousehold = objHouseHoldBLL.GetHouseHoldData(HHID);
if (objHousehold != null)
{
ProjectBLL objProjectBLL = new ProjectBLL();
ProjectBO objProject = objProjectBLL.GetProjectByProjectID(objHousehold.ProjectedId);
sPapdata += "<b>PROJECT CODE:</b> " + objProject.ProjectCode;
sPapdata += "<br /><b>PAP UID:</b> " + objHousehold.Pap_UId;
sPapdata += "<br /><b>HHID:</b> " + objHousehold.HhId;
if (objHousehold.PapName == null)
{
sPapdata += "<br /><b>PAP Name:</b> " + objHousehold.Surname + objHousehold.Firstname;
}
else
{
sPapdata += "<br /><b>PAP Name:</b> " + objHousehold.PapName;
}
sPapdata += "<br /><b>Plot Reference:</b> " + objHousehold.PlotReference;
sPapdata += "<br /><b>Designation:</b> " + objHousehold.Designation;
sPapdata += "<br /><b>District:</b> " + objHousehold.District;
sPapdata += "<br /><b>County:</b> " + objHousehold.County;
sPapdata += "<br /><b>SubCounty:</b> " + objHousehold.SubCounty;
sPapdata += "<br /><b>Village:</b> " + objHousehold.Village;
sPapdata += "<br /><b>Parish:</b> " + objHousehold.Parish;
sPapdata += "<br /><b>Rightofway (Acres):</b> " + objHousehold.Rightofway;
sPapdata += "<br /><b>Wayleaves (Acres):</b> " + objHousehold.Wayleaves;
}
}
return(sPapdata);
}
/// <summary>
/// To generate mail to the user
/// </summary>
/// <param name="Status"></param>
/// <param name="UID"></param>
/// <param name="objTemporaryAuthorizationBO"></param>
private void SendMailForUser(string Status, int UID, TemporaryAuthorizationBO objTemporaryAuthorizationBO)
{
UserBLL objUserBLL = new UserBLL();
UserBO objUser = new UserBO();
objUser = objUserBLL.GetUserById(UID);
ProjectBLL objProjectBLL = new ProjectBLL();
ProjectBO objProject = objProjectBLL.GetProjectByProjectID(Convert.ToInt32(Session["PROJECT_ID"]));
string fileName = string.Empty;
//NotificationObj.SendChangeRequestEmail(EmailToTextBox.Text, EmailSubjectTextBox.Text, EmailBodyTextBox.Text);
MailMessage mailMessage = new MailMessage();
SmtpClient smtp = new SmtpClient();
mailMessage.To.Add(objUser.EmailID.Trim());
mailMessage.From = new MailAddress(ConfigurationManager.AppSettings.Get("FromMailAddress"));
if (Status == "INS")
{
mailMessage.Subject = Session["userName"].ToString() + " assign you as a Temporary authorized person for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project.";
mailMessage.Body = "Dear Sir <br/><br/> " + Session["userName"].ToString() + " assign you as a Temporary authorized person for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project. <br/><br/> ProjectCode : " + Session["PROJECT_CODE"].ToString()
+ "<br/> ProjectName : " + objProject.ProjectName + "<br/>" +
"<br/> From Date : " + objTemporaryAuthorizationBO.Fromdate.ToString(UtilBO.DateFormat) + "<br/>" +
"<br/> To Date : " + objTemporaryAuthorizationBO.Todate.ToString(UtilBO.DateFormat) + "<br/><br/>" +
"<br/> Remarks : " + objTemporaryAuthorizationBO.Remarks + "<br/><br/>" +
"Thanks and Regards <br/> WIS - UETCL Team";
}
else
{
mailMessage.Subject = Session["userName"].ToString() + " is available now. Your Temporary authorization for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project was canceled.";
mailMessage.Body = "Dear Sir <br/><br/> " + Session["userName"].ToString() + " is available now. Your Temporary authorization for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project was canceled. <br/><br/> ProjectCode : " + Session["PROJECT_CODE"].ToString()
+ "<br/> ProjectName : " + objProject.ProjectName + "<br/>" +
"<br/> From Date : " + objTemporaryAuthorizationBO.Fromdate.ToString(UtilBO.DateFormat) + "<br/>" +
"<br/> To Date : " + objTemporaryAuthorizationBO.Todate.ToString(UtilBO.DateFormat) + "<br/><br/>" +
"<br/> Remarks : " + objTemporaryAuthorizationBO.Remarks + "<br/><br/>" +
"Thanks and Regards <br/> WIS - UETCL Team";
}
mailMessage.IsBodyHtml = true;
smtp.Send(mailMessage);
}
protected void ButtonDeleteSelected_Click(object sender, System.EventArgs e)
{
try
{
// Create a List to hold the ProjectID values to delete
List <Int32> ProjectIDsToDelete = new List <Int32>();
// Iterate through the Projects.Rows property
foreach (GridViewRow row in gridViewProjects.Rows)
{
// Access the CheckBox
CheckBox cb = (CheckBox)(row.FindControl("chkProjectSelector"));
if (cb != null && cb.Checked)
{
// Save the ProjectID value for deletion
// First, get the ProjectID for the selected row
Int32 ProjectID = (Int32)gridViewProjects.DataKeys[row.RowIndex].Value;
ProjectBLL scientificNameBLL = new ProjectBLL();
Eisk.BusinessEntities.Project project = scientificNameBLL.GetProjectByProjectID(ProjectID);
// Add it to the List...
ProjectIDsToDelete.Add(ProjectID);
// Add a confirmation message
ltlMessage.Text += String.Format(MessageFormatter.GetFormattedSuccessMessage("Delete successful. Project <b>{0}</b> has been deleted"), project.ProjectName);
}
}
//perform the actual delete
new ProjectBLL().DeleteProjects(ProjectIDsToDelete);
}
catch (Exception ex)
{
ltlMessage.Text = ExceptionManager.DoLogAndGetFriendlyMessageForException(ex);
}
//binding the grid
gridViewProjects.PageIndex = 0;
gridViewProjects.DataBind();
}
/// <summary>
/// Method to fetch project details and assign to textbox
/// </summary>
protected void GetProjectDetails()
{
ProjectBLL objProjectBLL = new ProjectBLL();
ProjectBO objProject = objProjectBLL.GetProjectByProjectID(Convert.ToInt32(Session["PROJECT_ID"]));
if (!string.IsNullOrEmpty(objProject.ProjectCode))
{
Session["PROJECT_CODE"] = objProject.ProjectCode.ToString();
}
txtpercentage.Text = Convert.ToString(objProject.PercentageofPAP);
txtProjectCode.Text = objProject.ProjectCode;
Master.PageHeader = objProject.ProjectCode + " - Project Details";
txtProjectName.Text = objProject.ProjectName;
txtObjective.Text = objProject.Objective;
if (objProject.ProjectStartDate != DateTime.MinValue)
{
dpProjectStartDate.Text = Convert.ToString(objProject.ProjectStartDate.ToString(UtilBO.DateFormat));
}
if (objProject.ProjectEndDate != DateTime.MinValue)
{
dpProjectEndDate.Text = Convert.ToString(objProject.ProjectEndDate.ToString(UtilBO.DateFormat));
}
txtTotalEstBudget.Text = UtilBO.CurrencyFormat(objProject.TotalEstBudget);
txtLabouCost.Text = UtilBO.CurrencyFormat(objProject.Labourcost);
txtBulMatCost.Text = UtilBO.CurrencyFormat(objProject.BUILDINGMATCOST);
txtDollervalue.Text = Convert.ToString(objProject.Dollervalue);
//String.Format("{0:C0}", objProject.TotalEstBudget).Replace("$", "");
LoadCurrencyTotalEstimate();
ddlCurrencyTypeTotalEstBudget.ClearSelection();
if (ddlCurrencyTypeTotalEstBudget.Items.FindByValue(objProject.BudgetCurrency.ToString()) != null)
{
ddlCurrencyTypeTotalEstBudget.Items.FindByValue(objProject.BudgetCurrency.ToString()).Selected = true;
}
ViewState["BudgetCurrency"] = objProject.BudgetCurrency;
//LoadCurrencyEstimate();
//ddlCurrencyTypeEstBudget.ClearSelection();
//if (ddlCurrencyTypeEstBudget.Items.FindByValue(objProject.BudgetCurrency.ToString()) != null)
//{
// ddlCurrencyTypeEstBudget.Items.FindByValue(objProject.BudgetCurrency.ToString()).Selected = true;
//}
//ddlCurrencyTypeEstBudget.Enabled = false;
DisplayEstBudget();
ddlProjectStatus.ClearSelection();
if (ddlProjectStatus.Items.FindByValue(objProject.ProjectStatus.ToUpper()) != null)
{
ddlProjectStatus.Items.FindByValue(objProject.ProjectStatus.ToUpper()).Selected = true;
}
//Loading Segments
if (Session["PROJECT_ID"] != null)
{
int ProjectId = Convert.ToInt32(Session["PROJECT_ID"]);
LoadProjectSegmentGV(ProjectId);
}
}
