// ////////////////////////////////////////////////////////////////////////
// PRIVATE METHODS
//
private void Save()
{
bool exists = false;
// Validate page
if (Page.IsValid)
{
int projectIdToSave = Int32.Parse(hdfSelectedProjectId.Value);
ProjectSelectProjectLastUsedProjectsGateway projectSelectProjectLastUsedProjectsVerifyGateway = new ProjectSelectProjectLastUsedProjectsGateway(projectSelectProjectTDS);
ProjectSelectProjectLastUsedProjects projectSelectProjectLastUsedProjectsVerify = new ProjectSelectProjectLastUsedProjects(projectSelectProjectLastUsedProjectsVerifyGateway.Data);
exists = projectSelectProjectLastUsedProjectsVerify.ExistProject(projectIdToSave);
if (exists)
{
// New Data
DateTime newLastLoggedInDate = DateTime.Now;
// Update if exists
ProjectSelectProjectLastUsedProjects model = new ProjectSelectProjectLastUsedProjects(projectSelectProjectTDS);
model.UpdateLogginDate(projectIdToSave, newLastLoggedInDate);
Session["projectSelectProjectTDS"] = projectSelectProjectTDS;
Session["projectLastUsedProjects"] = projectSelectProjectTDS.LastUsedProjects;
}
// If doesn't exists at grid
if (!exists)
{
if (projectSelectProjectLastUsedProjectsVerifyGateway.Table.Rows.Count < 5)
{
// Add data if exist at grid's
ProjectAdd();
}
else
{
if (projectSelectProjectLastUsedProjectsVerifyGateway.Table.Rows.Count == 5)
{
// New Data
int newProjectId = Int32.Parse(hdfSelectedProjectId.Value);
int newCompanyId = Int32.Parse(hdfCompanyId.Value);
int newUserId = Convert.ToInt32(Session["loginID"]);
DateTime newLastLoggedInDate = DateTime.Now;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(newProjectId);
string newProjectName = projectGateway.GetName(newProjectId) + " (" + projectGateway.GetProjectNumber(newProjectId) + ")";
// Update if exists
ProjectSelectProjectLastUsedProjects model = new ProjectSelectProjectLastUsedProjects(projectSelectProjectTDS);
model.Update(newProjectId, newUserId, newLastLoggedInDate, newCompanyId, false, newProjectName);
Session["projectSelectProjectTDS"] = projectSelectProjectTDS;
Session["projectLastUsedProjects"] = projectSelectProjectTDS.LastUsedProjects;
}
}
}
// Update data at bd
UpdateDatabase();
}
}
private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
// Update
ProjectSelectProjectLastUsedProjects projectSelectProjectLastUsedProjects = new ProjectSelectProjectLastUsedProjects(projectSelectProjectTDS);
projectSelectProjectLastUsedProjects.Save(companyId);
DB.CommitTransaction();
// Store datasets
projectSelectProjectTDS.AcceptChanges();
Session["projectSelectProjectTDS"] = projectSelectProjectTDS;
Session["projectLastUsedProjects"] = projectSelectProjectTDS.LastUsedProjects;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void ProjectAdd()
{
if (Page.IsValid)
{
int projectId = Int32.Parse(hdfSelectedProjectId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int loginId = Convert.ToInt32(Session["loginID"]);
DateTime lastLoggedInDate = DateTime.Now;
bool deleted = false;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
string projectName = projectGateway.GetName(projectId) + " (" + projectGateway.GetProjectNumber(projectId) + ")";
ProjectSelectProjectLastUsedProjects model = new ProjectSelectProjectLastUsedProjects(projectSelectProjectTDS);
model.Insert(projectId, loginId, lastLoggedInDate, companyId, deleted, projectName, false);
Session.Remove("lastUsedProjectsDummy");
Session["projectSelectProjectTDS"] = projectSelectProjectTDS;
Session["projectLastUsedProjects"] = projectSelectProjectTDS.LastUsedProjects;
}
}
