//Function to update Project
private void updateProject(string projectID)
{
objProjDtls = new PipelineDeatils();
string prjNumber = txtPipeLineNumber.Text;
string prjName = txtPipeLineName.Text;
string dtStartDate = txtClosingDate.Text;
string dtEndDate = txtReviseClosingDate.Text;
int docCatID = int.Parse(ddlWSSector.SelectedValue.ToString());
string deaFileNum = txtPipeLineFileNo.Text;
//decimal camount = Convert.ToDecimal(txtPipeLineAmount.Text);
decimal camount = 0;
if (txtPipeLineAmount.Text != "")
{
camount = Convert.ToDecimal(txtPipeLineAmount.Text);
}
else
{
camount = 0;
}
string dtSigningDate = txtSigningDate.Text;
string dtApprovalDate = txtApprovalDate.Text;
string dtNegotiationDate = txtNegotiationDate.Text;
string iTeamLeader = ddlTeamMember.SelectedValue;
objProjDtls.updatePipelineDetailsMaster(Convert.ToInt32(projectID), prjNumber, prjName, dtStartDate, dtEndDate, docCatID, deaFileNum, camount, ((UserDetails)Session[clsConstant.TOKEN]).UserID, Convert.ToInt32(ddlSector.SelectedValue), Convert.ToInt32(ddlStatus.SelectedValue), Convert.ToInt32(ddlType.SelectedValue), Convert.ToInt32(ddlWBAgency.SelectedValue), dtSigningDate, dtApprovalDate, dtNegotiationDate, Convert.ToInt32(iTeamLeader));
//}
}
//reader for Edit
private clsEntPipelineDetails readForEdit(int Id, string projectNo, int Type, int Status)
{
clsEntPipelineDetails objEnt = new clsEntPipelineDetails();
objProjDtls = new PipelineDeatils();
objEnt = objProjDtls.readInfo(Id, projectNo, Type, Status);
return(objEnt);
}
protected void grdProjectDetailsMaster_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
objProj = new PipelineDeatils();
try
{
//Storing the Row Index of Deleted Row
int rowIndex = int.Parse(grdProjectDetailsMaster.DataKeys[e.RowIndex].Value.ToString());
//Function call for row delete
if (objProj.DeletePipelineDetails(rowIndex))
{
UrlParameterPasser urlWrapper = new UrlParameterPasser("PipelineDetailsList.aspx");
// Add some values
urlWrapper.PassParameters();
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
//Function to Save
private void saveProject()
{
objProjDtls = new PipelineDeatils();
string prjNumber = txtPipeLineNumber.Text;
string prjName = txtPipeLineName.Text;
//int agencyID = int.Parse(drpAgency.SelectedValue.ToString());
string dtStartDate = txtClosingDate.Text;
string dtEndDate = txtReviseClosingDate.Text;
int docCatID = int.Parse(ddlWSSector.SelectedValue.ToString());
string DEAREFNo = txtPipeLineFileNo.Text;
decimal Amount = 0;
if (txtPipeLineAmount.Text != "")
{
Amount = Convert.ToDecimal(txtPipeLineAmount.Text);
}
else
{
Amount = 0;
}
string dtSigningDate = txtSigningDate.Text;
string dtApprovalDate = txtApprovalDate.Text;
string dtNegotiationDate = txtNegotiationDate.Text;
int iTeamLeader = 0;
iTeamLeader = Convert.ToInt32(ddlTeamMember.SelectedValue);
//function call for storing information in database
objProjDtls.AddPipelineDetailsMaster(prjNumber, prjName, dtStartDate, dtEndDate, docCatID, DEAREFNo, Amount,
((UserDetails)Session[clsConstant.TOKEN]).UserID, Convert.ToInt32(ddlSector.SelectedValue),
Convert.ToInt32(ddlStatus.SelectedValue), Convert.ToInt32(ddlType.SelectedValue), Convert.ToInt32(ddlWBAgency.SelectedValue),
dtSigningDate, dtApprovalDate, dtNegotiationDate, iTeamLeader);
}
