public int DeleteProjectSync(ProjectSync item)
{
using (var cmd = new SqlCommand("DevTrkr..DeleteProjectSync"))
{
cmd.Parameters.AddWithValue("@ID", item.ID);
return(UpdateDatabase(cmd));
}
}
public int UpdateProjetSyncWithProjectCount(ProjectSync item)
{
using (var cmd = new SqlCommand("DevTrkr..UpdateProjetSyncWithProjectCount"))
{
cmd.Parameters.AddWithValue("@ID", item.ID);
cmd.Parameters.AddWithValue("@DevProjectCount", item.DevProjectCount);
return(UpdateDatabase(cmd));
}
}
public int UpdateProjectSyncWithGitURL(ProjectSync ps)
{
using (var cmd = new SqlCommand("DevTrkr..UpdateProjectSyncWithGitURL"))
{
cmd.Parameters.AddWithValue("@ID", ps.ID);
cmd.Parameters.AddWithValue("@GitURL", ps.GitURL);
return(UpdateDatabase(cmd));
}
}
public int InsertUpdateProjectSync(ProjectSync item)
{
using (var cmd = new SqlCommand("DevTrkr..InsertUpdateProjectSync"))
{
cmd.Parameters.AddWithValue("@ID", item.ID);
cmd.Parameters.AddWithValue("@DevProjectName", item.DevProjectName);
cmd.Parameters.AddWithValue("@CreatedDate", item.CreatedDate);
cmd.Parameters.AddWithValue("@DevProjectCount", item.DevProjectCount);
cmd.Parameters.AddWithValue("@GitURL", item.GitURL);
return(UpdateDatabase(cmd));
}
}
