/// <summary>
/// It will Update new info.into Project Table
/// </summary>
/// <param name="pmod"></param>
/// <returns></returns>
public int updateProject(ProjectModelCSD pmod)
{
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@projectID", SqlDbType.Int);
param[0].Value = pmod.projectId;
param[1] = new SqlParameter("@projectName", SqlDbType.VarChar);
param[1].Value = pmod.projectName;
param[2] = new SqlParameter("@projectDesc ", SqlDbType.VarChar);
param[2].Value = pmod.projectDescription;
param[3] = new SqlParameter("@client", SqlDbType.VarChar);
param[3].Value = pmod.client;
param[4] = new SqlParameter("@startDate", SqlDbType.DateTime);
param[4].Value = pmod.startDate;
param[5] = new SqlParameter("@endDate", SqlDbType.DateTime);
param[5].Value = pmod.endDate;
param[6] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
param[6].Value = pmod.lastModifiedBy;
string con = "Data Source=.;Initial Catalog=HRS;Integrated Security=True";
int i = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spUpdateProject", param);
return(i);
}
public int CreateProject(string projName, string projectDesc, string clientName, DateTime projStartDate,
DateTime projEndDate, int projCreatedBy)
{
ProjectModelCSD pmod = new ProjectModelCSD()
{
projectName = projName,
projectDescription = projectDesc,
client = clientName,
startDate = projStartDate,
endDate = projEndDate,
createdBy = projCreatedBy
};
return(new ProjectManagerCSD().createProject(pmod));
}
public int updateProject(int projId, string projName, string projectDesc, string clientName, DateTime projStartDate,
DateTime projEndDate, int LastModifiedBy)
{
ProjectModelCSD pmod = new ProjectModelCSD()
{
projectId = projId,
projectName = projName,
projectDescription = projectDesc,
client = clientName,
startDate = projStartDate,
endDate = projEndDate,
lastModifiedBy = LastModifiedBy
};
return(new ProjectManagerCSD().updateProject(pmod));
}
public int updateProject(ProjectModelCSD pmod)
{
return(new ProjectDAOCSD().updateProject(pmod));
}
public int updateProject(ProjectModelCSD pmod)
{
return(new ProjectBusinessComponentCSD().updateProject(pmod));
}
