/// <summary>
/// Update Project Details
/// </summary>
/// <param name="projectDetailsEntity">Object for update data into database</param>
/// <returns>system.int32</returns>
public int UpdateProjectDetailsDAL(ProjectDetailsEntity projectDetailsEntity)
{
int result = 0;
try
{
connection.Open();
SqlCommand cmd = new SqlCommand();
SqlParameter[] sqlparams = {
//new SqlParameter("@candidateId",projectDetailsEntity.CandidateId),
new SqlParameter("@companyName",projectDetailsEntity.CompanyName),
new SqlParameter("@projectTitle",projectDetailsEntity.ProjectTitle),
new SqlParameter("@roleId",projectDetailsEntity.YourRole),
new SqlParameter("@clientName",projectDetailsEntity.ClientName),
new SqlParameter("@projectLocation",projectDetailsEntity.ProjectLocation),
new SqlParameter("@duration",projectDetailsEntity.Duration),
new SqlParameter("@employmentType",projectDetailsEntity.EmploymentType),
new SqlParameter("@projectDescription",projectDetailsEntity.ProjectDescription),
new SqlParameter("@teamSize",projectDetailsEntity.TeamSize),
new SqlParameter("@skillUsed",projectDetailsEntity.SkillUsed),
new SqlParameter("@rolesandResponsibility",projectDetailsEntity.RolesandResponsibility),
new SqlParameter("@projectLive",projectDetailsEntity.ProjectLive),
new SqlParameter("@projectLink", projectDetailsEntity.ProjectLink),
new SqlParameter("@projectId",projectDetailsEntity.ProjectId),
new SqlParameter("@degree",projectDetailsEntity.Degree),
new SqlParameter("@projectFor",projectDetailsEntity.ProjectFor),
};
result = SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, Constants.sp_JS_UpdateProjectDetails, sqlparams);
}
catch (Exception)
{
// throw;
}
finally
{
connection.Close();
}
return result;
}
/// <summary>
/// Update Project Details
/// </summary>
/// <param name="projectDetailsEntity">ProjectDetailsEntity</param>
/// <returns>system.Int32</returns>
public int UpdateProjectDetailsBAL(ProjectDetailsEntity projectDetailsEntity)
{
ProjectDetailsDAL projectDetailsDAL = new ProjectDetailsDAL();
return projectDetailsDAL.UpdateProjectDetailsDAL(projectDetailsEntity);
}
protected void rptrProjectDetails_ItemCommand(object source, RepeaterCommandEventArgs e)
{
LinkButton lnkUpdate = (LinkButton)e.Item.FindControl("lnkUpdate");
LinkButton lnkCancel = (LinkButton)e.Item.FindControl("lnkCancel");
LinkButton lnkEdit = (LinkButton)e.Item.FindControl("lnkEdit");
LinkButton lnkDelete = (LinkButton)e.Item.FindControl("lnkDelete");
Label lblrptID = (Label)e.Item.FindControl("lblID");
Label lblProjectFor = (Label)e.Item.FindControl("lblProjectFor");
Label lblProjectTiltle = (Label)e.Item.FindControl("lblProjectTiltle");
Label lblCompanyName = (Label)e.Item.FindControl("lblCompanyName");
Label lblClientName = (Label)e.Item.FindControl("lblClientName");
Label lblDuration = (Label)e.Item.FindControl("lblDuration");
Label lblProjectLocation = (Label)e.Item.FindControl("lblProjectLocation");
Label lblEmploymentType = (Label)e.Item.FindControl("lblEmploymentType");
Label lblProjectDetails = (Label)e.Item.FindControl("lblProjectDetails");
Label lblRolesandResponsibility = (Label)e.Item.FindControl("lblRolesandResponsibility");
Label lblSkillUsed = (Label)e.Item.FindControl("lblSkillUsed");
Label lblProjectLive = (Label)e.Item.FindControl("lblProjectLive");
Label lblProjectLink = (Label)e.Item.FindControl("lblProjectLink");
TextBox txtProjectTiltle = (TextBox)e.Item.FindControl("txtProjectTiltle");
TextBox txtCompanyName = (TextBox)e.Item.FindControl("txtCompanyName");
TextBox txtClientName = (TextBox)e.Item.FindControl("txtClientName");
TextBox txtDuration = (TextBox)e.Item.FindControl("txtDuration");
TextBox txtProjectLocation = (TextBox)e.Item.FindControl("txtProjectLocation");
TextBox txtEmploymentType = (TextBox)e.Item.FindControl("txtEmploymentType");
TextBox txtProjectDetails = (TextBox)e.Item.FindControl("txtProjectDetails");
TextBox txtRolesandResponsibility = (TextBox)e.Item.FindControl("txtRolesandResponsibility");
TextBox txtSkillUsed = (TextBox)e.Item.FindControl("txtSkillUsed");
TextBox txtProjectLive = (TextBox)e.Item.FindControl("txtProjectLive");
TextBox txtProjectLink = (TextBox)e.Item.FindControl("txtProjectLink");
DropDownList ddlRole = (DropDownList)e.Item.FindControl("ddlRole");
DropDownList ddlTeamSize = (DropDownList)e.Item.FindControl("ddlTeamSize");
DropDownList ddlProjectFor = (DropDownList)e.Item.FindControl("ddlProjectFor");
DropDownList ddlDegree = (DropDownList)e.Item.FindControl("ddlDegree");
CheckBox chkDelete = (CheckBox)e.Item.FindControl("chkDelete");
// Check commond for edit
if (e.CommandName == "edit")
{
lnkCancel.Visible = true;
lnkUpdate.Visible = true;
lnkEdit.Visible = false;
txtProjectTiltle.Visible = true;
txtCompanyName.Visible = true;
txtClientName.Visible = true;
txtDuration.Visible = true;
txtEmploymentType.Visible = true;
txtRolesandResponsibility.Visible = true;
txtProjectLive.Visible = true;
txtProjectLocation.Visible = true;
txtProjectLink.Visible = true;
txtSkillUsed.Visible = true;
txtProjectDetails.Visible = true;
txtProjectLink.Visible = true;
ddlProjectFor.Visible = true;
lblProjectFor.Visible = false;
lblProjectTiltle.Visible = false;
lblCompanyName.Visible = false;
lblClientName.Visible = false;
lblDuration.Visible = false;
lblProjectLocation.Visible = false;
lblEmploymentType.Visible = false;
lblProjectDetails.Visible = false;
lblRolesandResponsibility.Visible = false;
lblSkillUsed.Visible = false;
lblProjectLive.Visible = false;
lblProjectLink.Visible = false;
}
// Check commond for update
if (e.CommandName == "cancel")
{
BindRepeater();
}
// Check commond for update
if (e.CommandName == "update")
{
try
{
ProjectDetailsBAL projectDetailsBAL = new ProjectDetailsBAL();
ProjectDetailsEntity projectDetailsEntity = new ProjectDetailsEntity();
projectDetailsEntity.ProjectTitle = txtProjectTiltle.Text;
projectDetailsEntity.CompanyName = txtCompanyName.Text;
projectDetailsEntity.YourRole = Convert.ToInt32(ddlRole.SelectedValue);
projectDetailsEntity.ClientName = txtClientName.Text;
projectDetailsEntity.Duration = txtDuration.Text;
projectDetailsEntity.ProjectLocation = txtProjectLocation.Text;
projectDetailsEntity.EmploymentType = txtEmploymentType.Text;
projectDetailsEntity.ProjectDescription = txtProjectDetails.Text;
projectDetailsEntity.RolesandResponsibility = txtRolesandResponsibility.Text;
projectDetailsEntity.TeamSize = ddlTeamSize.SelectedValue;
projectDetailsEntity.SkillUsed = txtSkillUsed.Text;
projectDetailsEntity.ProjectLive = txtProjectLive.Text;
projectDetailsEntity.ProjectLink = txtProjectLink.Text;
projectDetailsEntity.Degree = ddlDegree.SelectedValue;
projectDetailsEntity.ProjectFor = ddlProjectFor.SelectedValue;
projectDetailsEntity.ProjectId = Convert.ToInt32(e.CommandArgument);
projectDetailsBAL.UpdateProjectDetailsBAL(projectDetailsEntity);
}
catch (Exception ex)
{
// throw;
}
BindRepeater();
}
// Check commond for delete
if (e.CommandName == "delete")
{
try
{
ProjectDetailsBAL projectDetailsBAL = new ProjectDetailsBAL();
int projectId = Convert.ToInt32(e.CommandArgument);
projectDetailsBAL.DeleteProjectDetailsBAL(projectId);
}
catch (Exception)
{
// throw;
}
BindRepeater();
}
}