/// <summary>
/// Adds a project by current user username to the Db. Adds a default empty index file to the Db.
/// Adds current user as owner of the new project to the Db.
/// </summary>
/// <param name="model">'CreateProjectViewModel'</param>
/// <param name="ownerName">Owner Name</param>
public void addProject(CreateProjectViewModel model, string ownerName)
{
Project newProject = new Project();
newProject._projectName = model._projectName;
newProject._projectFileTypeId = model._projectTypeId;
_db._projects.Add(newProject);
_db.SaveChanges();
string extension = _db._fileTypes.Where(x => x.ID == model._projectTypeId).SingleOrDefault()._extension;
string aceExtension = _db._fileTypes.Where(x => x.ID == model._projectTypeId).SingleOrDefault()._aceExtension;
string defaultData = _db._fileTypes.Where(x => x.ID == model._projectTypeId).SingleOrDefault()._initialCode;
ProjectFile defaultFile = new ProjectFile();
defaultFile._projectFileName = "index" + "." + extension;
defaultFile._projectFileType = "." + extension;
defaultFile._aceExtension = aceExtension;
defaultFile._projectFileData = defaultData;
defaultFile._projectID = _db._projects.OrderByDescending(p => p.ID)
.Select(p => p.ID).FirstOrDefault();
_db._projectFiles.Add(defaultFile);
_db.SaveChanges();
ProjectOwner owner = new ProjectOwner();
owner._projectID = defaultFile._projectID;
owner._userName = ownerName;
_db._projectOwners.Add(owner);
_db.SaveChanges();
}
public string teacherSync_project(string person_id, int type_person)
{
ResponseProjectList r = new ResponseProjectList();
ProjectOwner p = new ProjectOwner();
if (type_person == 0)
{
r.code = 11;
r.msg = "Parameter Wrong";
}
else
{
string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
string sqlRequest = "SELECT * FROM Relation WHERE PersID = '" + person_id + "' AND Status_ID = '1' OR Status_ID = '2'";
SqlCommand qrRequest = new SqlCommand(sqlRequest, con);
SqlDataReader reader = qrRequest.ExecuteReader();
r.projectlist = new List <ProjectOwner>();
while (reader.Read())
{
p = new ProjectOwner();
p.project = getNameProject(reader["ProjID"].ToString());
r.projectlist.Add(p);
}
reader.Close();
con.Close();
}
return(JsonConvert.SerializeObject(r));
}
/// <summary>
/// Delete project. Delete all files included in the project, all members and the owner.
/// </summary>
/// <param name="model">'ProjectViewModel'</param>
public void deleteProject(ProjectViewModel model)
{
// Delete all files in the project.
foreach (ProjectFileViewModel item in model._projectFiles)
{
_projectFileService.deleteProjectFile(item._id);
}
// Delete all members from the project.
foreach (ProjectMemberViewModel item in model._projectMembers)
{
_userService.deleteProjectMember(item._projectID);
}
// Delete the owner of the project.
ProjectOwner ownerInProject = (from owner in _db._projectOwners
where owner._projectID == model._id
select owner).FirstOrDefault();
// Delete the project.
Project projectToDel = (from del in _db._projects
where del.ID == model._id
select del).FirstOrDefault();
_db._projects.Remove(projectToDel);
_db._projectOwners.Remove(ownerInProject);
_db.SaveChanges();
}
//Creates a project with User withc specific username as owner. Returns false if fails, otherwise true
public bool CreateProject(CreateProjectViewModel NewCreateProject, string Username)
{
if (NewCreateProject == null || Username == "")
{
return(false);
}
var ProjectWithSameName = DB.Projects.Where(x => x.Owner.Username == Username &&
x.Name == NewCreateProject.Name).FirstOrDefault();
if (ProjectWithSameName != null) //If user has created a project with same name nothing is created and function returns false
{
return(false);
}
UserInfo Owner = DB.UsersInfo.Where(x => x.Username == Username).SingleOrDefault(); //User that is creating project
Project NewProject = new Project(); //The project that is being made, gets values from viewmodel
NewProject.Name = NewCreateProject.Name;
NewProject.Type = NewCreateProject.Type;
NewProject.Owner = Owner;
NewProject.ReadMe = FService.CreateReadMe(NewCreateProject.ReadMe); //New ReadMe created
NewProject.DateCreated = DateTime.Now;
NewProject.DateModified = DateTime.Now;
//If project is a web application more default files are made
if (NewProject.Type == "Web Application")
{
var Files = FService.CreateWebApplication(); //Gets a list of extra files
FileInProject FIProjectCSS = new FileInProject(); //connection between file and project is made
FIProjectCSS.FileProject = NewProject;
FIProjectCSS.ProjectFile = Files[0]; //css file
FileInProject FIProjectJS = new FileInProject(); //connection between file and project is made
FIProjectJS.FileProject = NewProject;
FIProjectJS.ProjectFile = Files[1]; //js file
DB.FilesInProjects.Add(FIProjectCSS); //added to database
DB.FilesInProjects.Add(FIProjectJS);
}
DB.Projects.Add(NewProject); //Project added to database
DB.SaveChanges();
//Connection between user creating and project is made
ProjectOwner POwner = new ProjectOwner();
POwner.Owner = Owner;
POwner.OwnerProject = NewProject;
//Connection between default file and project is made
FileInProject FIProject = new FileInProject();
FIProject.FileProject = NewProject;
FIProject.ProjectFile = FService.CreateDefaultFile(NewProject.Type); //default file is made
DB.ProjectOwners.Add(POwner); //connections added to database
DB.FilesInProjects.Add(FIProject);
DB.SaveChanges(); //changes saved and function returns true
return(true);
}
public void deleteOwner(ProjectOwner owner)
{
if (owner != null)
{
context.Entry(owner).State = EntityState.Deleted;
context.SaveChanges();
}
}
/// <summary>
/// Checks if username is owner of project by username and project ID, returns a bool value if true or not.
/// </summary>
/// <param name="username">Username</param>
/// <param name="projectID">Project ID</param>
/// <returns>bool</returns>
public bool isProjectOwner(string username, int projectID)
{
ProjectOwner ownerInProject = (from owned in _db._projectOwners
where owned._userName == username && owned._projectID == projectID
select owned).FirstOrDefault();
return(ownerInProject != null);
}
public void AddOwner(Guid userId, int projectId)
{
var projectOwn = new ProjectOwner
{
UserId = userId,
ProjectId = projectId
};
_context.ProjectOwners.Add(projectOwn);
_context.SaveChanges();
}
public IActionResult UpdateProject(long pId, string projectJson)
{
Tuple <Project, IList <User> > newProjTup = ProjectFromJson(projectJson);
if (newProjTup == null)
{
return(BadRequest());
}
Project newProj = newProjTup.Item1;
using (var context = new TodoContext()) {
Project oldProj = context.Projects.Find(pId);
if (oldProj == null)
{
return(NotFound());
}
var entry = context.Entry(oldProj);
context.EnsureDeepLoaded(entry);
foreach (var file in oldProj.Files)
{
context.FileRefs.Remove(file);
}
oldProj.Files.Clear();
foreach (var projOwner in oldProj.OwnerUsers)
{
projOwner.Unjoin(context);
}
oldProj.Name = newProj.Name;
oldProj.Description = newProj.Description;
if (newProj.ValidStatuses != null)
{
oldProj.ValidStatuses = context.StatusSets.Find(newProj.ValidStatuses.Id);
}
else
{
oldProj.ValidStatuses = null;
}
foreach (var newOwner in newProjTup.Item2)
{
ProjectOwner.Join(context, oldProj, newOwner);
}
oldProj.Tags = newProj.Tags;
foreach (var file in newProj.Files)
{
context.FileRefs.Add(file);
newProj.Files.Add(file);
}
context.SaveChanges();
return(NoContent());
}
}
/// <summary>
/// Gets owner of project by project ID, if project ID is not valid return null.
/// </summary>
/// <param name="projectID">Project ID</param>
/// <returns>String</returns>
public string getOwnerName(int projectID)
{
ProjectOwner ownerInProject = (from owned in _db._projectOwners
where owned._projectID == projectID
select owned).FirstOrDefault();
if (ownerInProject == null)
{
return(null);
}
string owner = ownerInProject._userName;
return(owner);
}
public void AddProjectOwner(ProjectOwner owner)
{
if (owner != null)
{
if (owner.Id == 0)
{
context.ProjectOwners.Add(owner);
}
else
{
context.Entry(owner).State = EntityState.Modified;
}
context.SaveChanges();
}
}
public BaseResponse Update(ProjectOwner projectOwner)
{
BaseResponse baseResponse = new BaseResponse();
try
{
_repository.Update(projectOwner);
_unitOfWork.SaveChanges();
baseResponse.SetStatus(ResponseCode.SUCCESS);
return(baseResponse);
}
catch (Exception ex)
{
baseResponse.SetStatus(ResponseCode.FAILED_ON_DB_PROCESS, ex.Message);
return(baseResponse);
}
}
//Deletes a Project and every connection to it
public void DeleteProject(int?ProjectID)
{
if (!ProjectID.HasValue)
{
throw new Exception();
}
//Deleting connection between owner and project to delete
ProjectOwner POwner = DB.ProjectOwners.Where(x => x.OwnerProject.ID == ProjectID).FirstOrDefault();
DB.ProjectOwners.Remove(POwner);
var FileProject = DB.FilesInProjects.Where(x => x.FileProject.ID == ProjectID).ToList();
//Looping through all connections between the project to delete and files
foreach (var item in FileProject)
{
File TheFile = DB.Files.Where(x => x.ID == item.ProjectFile.ID).FirstOrDefault();
DB.Files.Remove(TheFile); //Deleting the file
DB.FilesInProjects.Remove(item); //Deleting the connection
}
var Folders = DB.Folders.Where(x => x.ProjectStructure.ID == ProjectID);
//Looping through all folders in project and deletes them
foreach (var item in Folders)
{
DB.Folders.Remove(item);
}
var Shares = DB.ProjectShares.Where(x => x.ShareProject.ID == ProjectID);
//Looping through all connection between project and shared users and deletes them
foreach (var item in Shares)
{
DB.ProjectShares.Remove(item);
}
Project TheProject = DB.Projects.Where(x => x.ID == ProjectID).FirstOrDefault();
DB.Files.Remove(TheProject.ReadMe); //Deletes readme file of project
DB.Projects.Remove(TheProject); //Finally deletes project itself
DB.SaveChanges(); //saves changes to database
}
public ProjectOwner OwnerDTOToEntity(ProjectOwnerDTO projectOwner)
{
ProjectOwner owner = new ProjectOwner();
if (projectOwner.Id != 0)
{
owner.Id = projectOwner.Id;
}
if (projectOwner != null)
{
owner.Name = projectOwner.Name;
owner.PhoneNumber = projectOwner.PhoneNumber;
owner.Project_Id = projectOwner.Project_Id;
owner.AddressLine1 = projectOwner.AddressLine1;
owner.AddressLine2 = projectOwner.AddressLine2;
owner.Town = projectOwner.Town;
owner.County = projectOwner.County;
owner.PostCode = projectOwner.PostCode;
}
return(owner);
}
public IActionResult CreateProject(string projectJson)
{
Tuple <Project, IList <User> > newProjTup = ProjectFromJson(projectJson);
if (newProjTup == null)
{
return(BadRequest());
}
Project newProj = newProjTup.Item1;
using (var context = new TodoContext()) {
foreach (var file in newProj.Files)
{
context.FileRefs.Add(file);
}
foreach (var newOwner in newProjTup.Item2)
{
ProjectOwner.Join(context, newProj, newOwner);
}
context.ChangeTracker.TrackGraph(newProj, (node => node.Entry.State = node.Entry.IsKeySet ? EntityState.Unchanged : EntityState.Added));
context.SaveChanges();
return(CreatedAtRoute("GetProject", new { id = newProj.Pid }, GetDetailedModel(context, newProj)));
}
}
public void Initialize()
{
var mockDb = new MockDataContext();
#region User initialized.
var u1 = new ApplicationUser
{
Id = "1",
UserName = "******",
Email = "*****@*****.**",
PasswordHash = "Alberta1",
SecurityStamp = "Alberta",
PhoneNumber = null,
PhoneNumberConfirmed = false,
TwoFactorEnabled = false,
LockoutEndDateUtc = null,
LockoutEnabled = true,
AccessFailedCount = 0,
};
mockDb.Users.Add(u1);
#endregion
#region Projects initialized.
var pro1 = new Project
{
ID = 1,
_projectFileTypeId = 1,
_projectName = "pro1"
};
mockDb._projects.Add(pro1);
var pro2 = new Project
{
ID = 2,
_projectFileTypeId = 2,
_projectName = "pro2"
};
mockDb._projects.Add(pro2);
#endregion
#region Project owners initialized.
var p1 = new ProjectOwner
{
ID = 1,
_projectID = 1,
_userName = "******"
};
mockDb._projectOwners.Add(p1);
var p2 = new ProjectOwner
{
ID = 2,
_projectID = 2,
_userName = "******"
};
mockDb._projectOwners.Add(p2);
var p3 = new ProjectOwner
{
ID = 3,
_projectID = 3,
_userName = "******"
};
mockDb._projectOwners.Add(p3);
var p4 = new ProjectOwner
{
ID = 4,
_projectID = 4,
_userName = "******"
};
mockDb._projectOwners.Add(p4);
var p5 = new ProjectOwner
{
ID = 5,
_projectID = 3,
_userName = "******"
};
mockDb._projectOwners.Add(p5);
var p6 = new ProjectOwner
{
ID = 6,
_projectID = 1,
_userName = "******"
};
mockDb._projectOwners.Add(p6);
var p7 = new ProjectOwner
{
ID = 7,
_projectID = 2,
_userName = "******"
};
mockDb._projectOwners.Add(p7);
var p8 = new ProjectOwner
{
ID = 8,
_projectID = 9,
_userName = "******"
};
mockDb._projectOwners.Add(p8);
var p9 = new ProjectOwner
{
ID = 9,
_projectID = 12,
_userName = "******"
};
mockDb._projectOwners.Add(p9);
var p10 = new ProjectOwner
{
ID = 10,
_projectID = 23,
_userName = "******"
};
mockDb._projectOwners.Add(p10);
#endregion
#region Project members initialized.
var m1 = new ProjectMember
{
ID = 1,
_projectID = 23,
_userName = "******"
};
mockDb._projectMembers.Add(m1);
var m2 = new ProjectMember
{
ID = 2,
_projectID = 2,
_userName = "******"
};
mockDb._projectMembers.Add(m2);
var m3 = new ProjectMember
{
ID = 3,
_projectID = 55,
_userName = "******"
};
mockDb._projectMembers.Add(m3);
var m4 = new ProjectMember
{
ID = 4,
_projectID = 27,
_userName = "******"
};
mockDb._projectMembers.Add(m4);
var m5 = new ProjectMember
{
ID = 10,
_projectID = 23,
_userName = "******"
};
mockDb._projectMembers.Add(m5);
var m6 = new ProjectMember
{
ID = 6,
_projectID = 16,
_userName = "******"
};
mockDb._projectMembers.Add(m6);
var m7 = new ProjectMember
{
ID = 7,
_projectID = 99,
_userName = "******"
};
mockDb._projectMembers.Add(m7);
var m8 = new ProjectMember
{
ID = 8,
_projectID = 255,
_userName = "******"
};
mockDb._projectMembers.Add(m8);
var m9 = new ProjectMember
{
ID = 9,
_projectID = 4,
_userName = "******"
};
mockDb._projectMembers.Add(m9);
var m10 = new ProjectMember
{
ID = 10,
_projectID = 87,
_userName = "******"
};
mockDb._projectMembers.Add(m10);
var m11 = new ProjectMember
{
ID = 11,
_projectID = 87,
_userName = "******"
};
mockDb._projectMembers.Add(m11);
#endregion
_userService = new UserService(mockDb);
}
public void Initialize()
{
var MockDb = new MockDatabase();
var F1 = new File
{
ID = 1,
Name = "File1",
Location = "WOW"
};
MockDb.Files.Add(F1);
var U1 = new UserInfo
{
ID = 1,
Username = "******"
};
MockDb.UsersInfo.Add(U1);
var U2 = new UserInfo
{
ID = 2,
Username = "******"
};
MockDb.UsersInfo.Add(U2);
var P1 = new Project
{
ID = 1,
Name = "Project1",
ReadMe = F1,
Type = "C#",
Owner = U1
};
MockDb.Projects.Add(P1);
var PO1 = new ProjectOwner
{
ID = 1,
Owner = U1,
OwnerProject = P1
};
MockDb.ProjectOwners.Add(PO1);
var P2 = new Project
{
ID = 2,
Name = "Project2",
Owner = U1
};
MockDb.Projects.Add(P2);
var PO2 = new ProjectOwner
{
ID = 2,
Owner = U1,
OwnerProject = P2
};
MockDb.ProjectOwners.Add(PO2);
var P3 = new Project
{
ID = 3,
Name = "Project3",
Owner = U1
};
MockDb.Projects.Add(P3);
var PO3 = new ProjectOwner
{
ID = 3,
Owner = U1,
OwnerProject = P3
};
MockDb.ProjectOwners.Add(PO3);
var PVM = new ProjectsViewModel()
{
ID = 1,
};
Service = new ProjectService(MockDb);
}
private string GenerateSpreadsheetforGroupedWorksheet(long ScopeId, HttpContext context)
{
String result = String.Empty;
ScopeServices objScopeService = new ScopeServices();
objScopeService.SQLConnection = ConnectDb.SQLConnection;
ManagementService objManagementService = new ManagementService();
objManagementService.SQLConnection = ConnectDb.SQLConnection;
Scope objScope = objScopeService.GetScopeByScopeId(ScopeId);
Project objProject = objManagementService.GetProjectByProjectId(objScope.ProjectId);
DataSet dsQuery = new DataSet();
int intFootTotalStartRow;
int intFootTotalStartColum;
int intCompanyInfoStartRow;
int intCompanyInfoStartColum;
String strExcelFile;
String strNewExcelFileName;
DataSet dsProjectGroup = new DataSet();
String strClaimNo = "";
String strClaimant = "";
String strSiteLocation = "";
String strEQRSupervisor = "";
String strContractorEmail = "";
String strScopeDate = "";
String strContractor = "";
String strAddress = "";
String strAccreditationNo = "";
String strContractorPhone = "";
String strGSTNo = "";
String strTotalPrice = "";
DataSet dsProject = new DataSet();
ProjectOwner projectOwner = new ProjectOwner();
String strLogo = "";
dsProjectGroup = objScopeService.GetProjectGroupsByProjectOwnerId(objProject.ProjectOwnerId);
dsProject = objManagementService.GetProjectInfoByProjectId(objScope.ProjectId);
//get project group email
if (dsProjectGroup.Tables.Count > 0)
{
if (dsProjectGroup.Tables[0].Rows.Count > 0)
{
if (!Convert.IsDBNull(dsProjectGroup.Tables[0].Rows[0]["Email"]))
{
strContractorEmail = dsProjectGroup.Tables[0].Rows[0]["Email"].ToString();
}
}
}
//get claimant detail
if (!Convert.IsDBNull(dsProject.Tables[0].Rows[0]["EQCClaimNumber"]))
{
strClaimNo = dsProject.Tables[0].Rows[0]["EQCClaimNumber"].ToString();
}
if (!Convert.IsDBNull(dsProject.Tables[0].Rows[0]["ScopeDate"]))
{
strScopeDate = dsProject.Tables[0].Rows[0]["ScopeDate"].ToString();
}
if (!Convert.IsDBNull(dsProject.Tables[0].Rows[0]["ScopeDate"]))
{
strScopeDate = Convert.ToDateTime(dsProject.Tables[0].Rows[0]["ScopeDate"]).ToString("dd/MM/yyyy");
}
if (!Convert.IsDBNull(dsProject.Tables[0].Rows[0]["Address"]))
{
strSiteLocation = dsProject.Tables[0].Rows[0]["Address"].ToString();
}
if (!Convert.IsDBNull(dsProject.Tables[0].Rows[0]["ContactName"]))
{
strClaimant = dsProject.Tables[0].Rows[0]["ContactName"].ToString();
}
//get project owner detail
projectOwner = objManagementService.GetProjectOwnerByProjectOwnerId(objProject.ProjectOwnerId);
strEQRSupervisor = projectOwner.EQRSupervisor;
strContractor = projectOwner.Name;
strContractorPhone = projectOwner.Contact1;
strAddress = projectOwner.Address;
strGSTNo = projectOwner.GSTNumber;
strAccreditationNo = projectOwner.AccreditationNumber;
String ApprovedexcludeGstCost = objScope.Cost.ToString("c");
String ApprovedGSTCost = (objScope.Total - objScope.Cost).ToString("c");
String ApprovedInGSTCost = objScope.Total.ToString("c");
String GrandExGSTCost = (objScope.Cost1 + objScope.Cost).ToString("c");
String GrandInGSTCost = (objScope.Total1 + objScope.Total).ToString("c");
strTotalPrice = ApprovedInGSTCost;
//Company Logo
strLogo = String.Format("{0}/Images/{1}/{2}", "http://koreprojects.com", projectOwner.Identifier, projectOwner.Logo);
strNewExcelFileName = String.Empty;
String strExcelFileNameTemp = Strings.StrConv(strSiteLocation, VbStrConv.ProperCase);
int ascChar;
for (int index = 0; index < strExcelFileNameTemp.Length - 1; index++)
{
ascChar = Strings.Asc(strExcelFileNameTemp[index]);
if ((ascChar >= 65 && ascChar <= 90) || (ascChar >= 97 && ascChar <= 122) || (ascChar >= 48 && ascChar <= 57))
{
strNewExcelFileName = strNewExcelFileName + strExcelFileNameTemp[index];
}
else
{
strNewExcelFileName = strNewExcelFileName + "-";
}
}
do
{
strNewExcelFileName = Strings.Replace(strNewExcelFileName, "--", "-");
} while (strNewExcelFileName.Contains("--"));
if (strNewExcelFileName.Substring(0, 1) == "-")
{
strNewExcelFileName = strNewExcelFileName.Substring(1);
}
if (strNewExcelFileName.Substring(strNewExcelFileName.Length - 1) == "-")
{
strNewExcelFileName = strNewExcelFileName.Substring(0, strNewExcelFileName.Length - 1);
}
if (strNewExcelFileName.Length > 20)
{
strNewExcelFileName = strNewExcelFileName.Substring(0, 20);
}
strExcelFile = String.Format("../Downloads/{0}/{1}.xls", "ExcelExport", strNewExcelFileName);
if ((!System.IO.Directory.Exists(String.Format("../Downloads/{0}", "ExcelExport"))))
{
System.IO.Directory.CreateDirectory(String.Format("../Downloads/{0}", "ExcelExport"));
}
WorkSheet workSheet = new WorkSheet();
//initialzing the cellexport tool
cellExport = new Spire.DataExport.XLS.CellExport();
cellExport.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
//culture format setting
cellExport.DataFormats.CultureName = "en-NZ";
cellExport.DataFormats.Currency = "#,###,##0.00";
cellExport.DataFormats.DateTime = "dd/MM/yyyy H:mm";
cellExport.DataFormats.Float = "#,###,##0.00";
cellExport.DataFormats.Integer = "#,###,##0";
cellExport.DataFormats.Time = "H:mm";
//set up file name and location
cellExport.FileName = strExcelFile;
//outlook formating
cellExport.SheetOptions.AggregateFormat.Font.Name = "Arial";
cellExport.SheetOptions.CustomDataFormat.Font.Name = "Arial";
cellExport.SheetOptions.DefaultFont.Name = "Arial";
cellExport.SheetOptions.FooterFormat.Font.Name = "Arial";
cellExport.SheetOptions.HeaderFormat.Font.Name = "Arial";
cellExport.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
cellExport.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
cellExport.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
cellExport.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
cellExport.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
cellExport.SheetOptions.NoteFormat.Font.Bold = true;
cellExport.SheetOptions.NoteFormat.Font.Name = "Tahoma";
cellExport.SheetOptions.NoteFormat.Font.Size = 8.0F;
cellExport.SheetOptions.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.Gray40Percent;
cellExport.SheetOptions.TitlesFormat.Font.Bold = true;
cellExport.SheetOptions.TitlesFormat.Font.Name = "Arial";
//worksheet culture format
workSheet.FormatsExport.CultureName = "en-NZ";
workSheet.FormatsExport.Currency = "#,###,##0.00";
workSheet.FormatsExport.DateTime = "dd/MM/yyyy H:mm";
workSheet.FormatsExport.Float = "#,###,##0.00";
workSheet.FormatsExport.Integer = "#,###,##0";
workSheet.FormatsExport.Time = "H:mm";
//worksheet outlook format;
workSheet.Options.AggregateFormat.Font.Name = "Arial";
workSheet.Options.CustomDataFormat.Font.Name = "Arial";
workSheet.Options.DefaultFont.Name = "Arial";
workSheet.Options.FooterFormat.Font.Name = "Arial";
workSheet.Options.HeaderFormat.Font.Name = "Arial";
workSheet.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet.Options.NoteFormat.Font.Bold = true;
workSheet.Options.NoteFormat.Font.Name = "Tahoma";
workSheet.Options.NoteFormat.Font.Size = 8.0F;
workSheet.Options.TitlesFormat.Font.Bold = true;
workSheet.Options.TitlesFormat.Font.Name = "Arial";
workSheet.Options.CustomDataFormat.Borders.Bottom.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet.Options.CustomDataFormat.Borders.Left.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet.Options.CustomDataFormat.Borders.Right.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet.Options.CustomDataFormat.Borders.Top.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet.SheetName = "Worksheet";
workSheet.AutoFitColWidth = true;
StripStyle stripStyle1 = new Spire.DataExport.XLS.StripStyle();
Cell mcell = new Spire.DataExport.XLS.Cell();
mcell.Column = 1;
mcell.Row = 2;
if (dsProjectGroup.Tables.Count > 0)
{
if (dsProjectGroup.Tables[0].Rows.Count > 0)
{
mcell.Value = String.Format("{0} - Contractor's Quote", dsProjectGroup.Tables[0].Rows[0]["Name"]);
}
else
{
mcell.Value = String.Format("Contractor's Quote");
}
}
else
{
mcell.Value = String.Format("Contractor's Quote");
}
mcell.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.HeaderRows = 15;
workSheet.Cells.Add(mcell);
intCompanyInfoStartRow = 8;
intCompanyInfoStartColum = 1;
CellPicture pic1 = new Spire.DataExport.XLS.CellPicture();
pic1.FileName = strLogo; //need to find out where the logo is
pic1.Name = "Logo";
cellExport.Pictures.Add(pic1);
CellImage img1 = new Spire.DataExport.XLS.CellImage();
img1.Column = 3;
img1.PictureName = "Logo";
img1.Row = 1;
workSheet.Images.Add(img1);
Cell mcell1 = new Spire.DataExport.XLS.Cell();
mcell1.Column = intCompanyInfoStartColum;
mcell1.Row = intCompanyInfoStartRow;
mcell1.Value = "Claim No:";
mcell1.CellType = CellType.String;
workSheet.Cells.Add(mcell1);
Cell mcell2 = new Spire.DataExport.XLS.Cell();
mcell2.Column = intCompanyInfoStartColum;
mcell2.Row = intCompanyInfoStartRow + 1;
mcell2.Value = "Claimant:";
mcell2.CellType = CellType.String;
workSheet.Cells.Add(mcell2);
Cell mcell3 = new Spire.DataExport.XLS.Cell();
mcell3.Column = intCompanyInfoStartColum;
mcell3.Row = intCompanyInfoStartRow + 2;
mcell3.Value = "Site Location:";
mcell3.CellType = CellType.String;
workSheet.Cells.Add(mcell3);
Cell mcell4 = new Spire.DataExport.XLS.Cell();
mcell4.Column = intCompanyInfoStartColum;
mcell4.Row = intCompanyInfoStartRow + 3;
mcell4.Value = "EQR Supervisor:";
mcell4.CellType = CellType.String;
workSheet.Cells.Add(mcell4);
Cell mcell5 = new Spire.DataExport.XLS.Cell();
mcell5.Column = intCompanyInfoStartColum;
mcell5.Row = intCompanyInfoStartRow + 4;
mcell5.Value = "Contractor E-mail:";
mcell5.CellType = CellType.String;
workSheet.Cells.Add(mcell5);
Cell mcell6 = new Spire.DataExport.XLS.Cell();
mcell6.Column = intCompanyInfoStartColum;
mcell6.Row = intCompanyInfoStartRow + 5;
mcell6.Value = "Date:";
mcell6.CellType = CellType.String;
workSheet.Cells.Add(mcell6);
//'add contact detail head field contet
//'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Cell mcell1_2 = new Spire.DataExport.XLS.Cell();
mcell1_2.Column = intCompanyInfoStartColum + 1;
mcell1_2.Row = intCompanyInfoStartRow;
mcell1_2.Value = strClaimNo;
mcell1_2.CellType = CellType.String;
workSheet.Cells.Add(mcell1_2);
Cell mcell2_2 = new Spire.DataExport.XLS.Cell();
mcell2_2.Column = intCompanyInfoStartColum + 1;
mcell2_2.Row = intCompanyInfoStartRow + 1;
mcell2_2.Value = strClaimant;
mcell2_2.CellType = CellType.String;
workSheet.Cells.Add(mcell2_2);
Cell mcell3_2 = new Spire.DataExport.XLS.Cell();
mcell3_2.Column = intCompanyInfoStartColum + 1;
mcell3_2.Row = intCompanyInfoStartRow + 2;
mcell3_2.Value = strSiteLocation;
mcell3_2.CellType = CellType.String;
workSheet.Cells.Add(mcell3_2);
Cell mcell4_2 = new Spire.DataExport.XLS.Cell();
mcell4_2.Column = intCompanyInfoStartColum + 1;
mcell4_2.Row = intCompanyInfoStartRow + 3;
mcell4_2.Value = strEQRSupervisor;
mcell4_2.CellType = CellType.String;
workSheet.Cells.Add(mcell4_2);
Cell mcell5_2 = new Spire.DataExport.XLS.Cell();
mcell5_2.Column = intCompanyInfoStartColum + 1;
mcell5_2.Row = intCompanyInfoStartRow + 4;
mcell5_2.Value = strContractorEmail;
mcell5_2.CellType = CellType.String;
workSheet.Cells.Add(mcell5_2);
Cell mcell6_2 = new Spire.DataExport.XLS.Cell();
mcell6_2.Column = intCompanyInfoStartColum + 1;
mcell6_2.Row = intCompanyInfoStartRow + 5;
// 'mcell6_2.Value = IIf(strScopeDate.Trim() = String.Empty, Today.ToString("dd/MM/yyyy"), strScopeDate)
mcell6_2.Value = DateTime.Now.ToString("dd/MM/yyyy");
mcell6_2.CellType = CellType.String;
workSheet.Cells.Add(mcell6_2);
//'second part of heading
//''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Cell mcell1_3 = new Spire.DataExport.XLS.Cell();
mcell1_3.Column = intCompanyInfoStartColum + 2;
mcell1_3.Row = intCompanyInfoStartRow;
mcell1_3.Value = "Contractor:";
mcell1_3.CellType = CellType.String;
workSheet.Cells.Add(mcell1_3);
Cell mcell2_3 = new Spire.DataExport.XLS.Cell();
mcell2_3.Column = intCompanyInfoStartColum + 2;
mcell2_3.Row = intCompanyInfoStartRow + 1;
mcell2_3.Value = "Address:";
mcell2_3.CellType = CellType.String;
workSheet.Cells.Add(mcell2_3);
Cell mcell3_3 = new Spire.DataExport.XLS.Cell();
mcell3_3.Column = intCompanyInfoStartColum + 2;
mcell3_3.Row = intCompanyInfoStartRow + 2;
mcell3_3.Value = "Accreditation No:";
mcell3_3.CellType = CellType.String;
workSheet.Cells.Add(mcell3_3);
Cell mcell4_3 = new Spire.DataExport.XLS.Cell();
mcell4_3.Column = intCompanyInfoStartColum + 2;
mcell4_3.Row = intCompanyInfoStartRow + 3;
mcell4_3.Value = "Contractor Phone:";
mcell4_3.CellType = CellType.String;
workSheet.Cells.Add(mcell4_3);
Cell mcell5_3 = new Spire.DataExport.XLS.Cell();
mcell5_3.Column = intCompanyInfoStartColum + 2;
mcell5_3.Row = intCompanyInfoStartRow + 4;
mcell5_3.Value = "GST No:";
mcell5_3.CellType = CellType.String;
workSheet.Cells.Add(mcell5_3);
Cell mcell6_3 = new Spire.DataExport.XLS.Cell();
mcell6_3.Column = intCompanyInfoStartColum + 2;
mcell6_3.Row = intCompanyInfoStartRow + 5;
mcell6_3.Value = "Total Price (incl. GST):";
mcell6_3.CellType = CellType.String;
workSheet.Cells.Add(mcell6_3);
//'second part of heading
// '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Cell mcell1_4 = new Spire.DataExport.XLS.Cell();
mcell1_4.Column = intCompanyInfoStartColum + 3;
mcell1_4.Row = intCompanyInfoStartRow;
mcell1_4.Value = strContractor;
mcell1_4.CellType = CellType.String;
workSheet.Cells.Add(mcell1_4);
Cell mcell2_4 = new Spire.DataExport.XLS.Cell();
mcell2_4.Column = intCompanyInfoStartColum + 3;
mcell2_4.Row = intCompanyInfoStartRow + 1;
mcell2_4.Value = strAddress;
mcell2_4.CellType = CellType.String;
workSheet.Cells.Add(mcell2_4);
Cell mcell3_4 = new Spire.DataExport.XLS.Cell();
mcell3_4.Column = intCompanyInfoStartColum + 3;
mcell3_4.Row = intCompanyInfoStartRow + 2;
mcell3_4.Value = strAccreditationNo;
mcell3_4.CellType = CellType.String;
workSheet.Cells.Add(mcell3_4);
Cell mcell4_4 = new Spire.DataExport.XLS.Cell();
mcell4_4.Column = intCompanyInfoStartColum + 3;
mcell4_4.Row = intCompanyInfoStartRow + 3;
mcell4_4.Value = strContractorPhone;
mcell4_4.CellType = CellType.String;
workSheet.Cells.Add(mcell4_4);
Cell mcell5_4 = new Spire.DataExport.XLS.Cell();
mcell5_4.Column = intCompanyInfoStartColum + 3;
mcell5_4.Row = intCompanyInfoStartRow + 4;
mcell5_4.Value = strGSTNo;
mcell5_4.CellType = CellType.String;
workSheet.Cells.Add(mcell5_4);
Cell mcell6_4 = new Spire.DataExport.XLS.Cell();
mcell6_4.Column = intCompanyInfoStartColum + 3;
mcell6_4.Row = intCompanyInfoStartRow + 5;
mcell6_4.Value = strTotalPrice;
mcell6_4.CellType = CellType.String;
workSheet.Cells.Add(mcell6_4);
dsQuery = objScopeService.GetScopeItemsByScopeIdScopeItemStatus(ScopeId, 2);
dsQuery.Tables[0].DefaultView.Sort = "ScopeGroup";
//DataRowView rowView= new DataRowView();
int intRowIndex;
int intColumIndex;
intRowIndex = 15;
intColumIndex = 0;
String strPrevScopeGroup = "****";
String strScopeGroup = String.Empty;
String strPrevArea = "*****";
String strArea = String.Empty;
String strAreaMeasurement = String.Empty;
Boolean blnAreaMeasurementFilled = false;
Cell dynamiccell_1;
intRowIndex = intRowIndex + 1;
int Range1 = intRowIndex;
foreach (DataRowView rowView in dsQuery.Tables[0].DefaultView)
{
DataRow row = rowView.Row;
strScopeGroup = String.Format("{0}", row["ScopeGroup"]);
if (strScopeGroup != strPrevScopeGroup)
{
intRowIndex = intRowIndex + 1;
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 1;
dynamiccell_1.Row = intRowIndex;
dynamiccell_1.Value = String.Format("{0}", row["ScopeGroup"]);
dynamiccell_1.CellType = CellType.String;
workSheet.Cells.Add(dynamiccell_1);
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 2;
dynamiccell_1.Row = intRowIndex;
dynamiccell_1.Value = "Description of Works";
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(dynamiccell_1);
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 3;
dynamiccell_1.Row = intRowIndex;
dynamiccell_1.Value = "Dimension";
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(dynamiccell_1);
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 4;
dynamiccell_1.Row = intRowIndex;
dynamiccell_1.Value = "$ Rate";
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(dynamiccell_1);
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 5;
dynamiccell_1.Row = intRowIndex;
dynamiccell_1.Value = "Contractors Quote";
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(dynamiccell_1);
intRowIndex = intRowIndex + 1;
}
strPrevScopeGroup = strScopeGroup;
strArea = String.Format("{0}", row["Area"]);
strAreaMeasurement = String.Format("{0}", row["AreaMeasurement"]);
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 1;
dynamiccell_1.Row = intRowIndex;
if (strArea != strPrevArea)
{
dynamiccell_1.Value = strArea;
blnAreaMeasurementFilled = false;
}
else
if (blnAreaMeasurementFilled)
{
dynamiccell_1.Value = "-";
}
else
{
if (strAreaMeasurement.Trim() == String.Empty)
{
dynamiccell_1.Value = "-";
}
else
{
dynamiccell_1.Value = strAreaMeasurement;
}
blnAreaMeasurementFilled = true;
}
strPrevArea = strArea;
dynamiccell_1.CellType = CellType.String;
workSheet.Cells.Add(dynamiccell_1);
//'Note
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 2;
dynamiccell_1.Row = intRowIndex;
if (!Convert.IsDBNull(row["Description"]))
{
dynamiccell_1.Value = row["Description"];
}
else
{
dynamiccell_1.Value = "";
}
if (!Convert.IsDBNull(row["Item"]))
{
if (String.Format("{0}", row["Item"]).Trim() != String.Empty)
{
dynamiccell_1.Value = String.Format("{0}: {1}", row["Item"], dynamiccell_1.Value);
}
}
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(dynamiccell_1);
//'QTY
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 3;
dynamiccell_1.Row = intRowIndex;
if (Convert.IsDBNull(row["Quantity"]))
{
dynamiccell_1.Value = Convert.ToDouble(row["Quantity"]).ToString();
}
else
{
dynamiccell_1.Value = 0;
}
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
dynamiccell_1.NumericFormat = "#,###,##0.00";
workSheet.Cells.Add(dynamiccell_1);
//'Rate
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 4;
dynamiccell_1.Row = intRowIndex;
if (Convert.IsDBNull(row["Rate"]))
{
dynamiccell_1.Value = Convert.ToDouble(row["Rate"]).ToString();
}
else
{
dynamiccell_1.Value = 0;
}
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
dynamiccell_1.NumericFormat = "#,###,##0.00";
workSheet.Cells.Add(dynamiccell_1);
//'Cost
dynamiccell_1 = new Spire.DataExport.XLS.Cell();
dynamiccell_1.Column = 5;
dynamiccell_1.Row = intRowIndex;
if (Convert.IsDBNull(row["Cost"]))
{
dynamiccell_1.Value = Convert.ToDouble(row["Cost"]).ToString("c");
}
else
{
dynamiccell_1.Value = Convert.ToDouble(0).ToString("c");
}
dynamiccell_1.CellType = Spire.DataExport.XLS.CellType.String;
dynamiccell_1.NumericFormat = "#,###,##0.00";
workSheet.Cells.Add(dynamiccell_1);
intRowIndex = intRowIndex + 1;
}
int Range2 = intRowIndex - 1;
intFootTotalStartRow = intRowIndex;
intFootTotalStartColum = 4;
//'heading
Cell mcell1_5 = new Spire.DataExport.XLS.Cell();
mcell1_5.Column = intFootTotalStartColum;
mcell1_5.Row = intFootTotalStartRow + 2;
mcell1_5.Value = "Subtotal (excl. GST)";
mcell1_5.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(mcell1_5);
Cell mcell2_5 = new Spire.DataExport.XLS.Cell();
mcell2_5.Column = intFootTotalStartColum;
mcell2_5.Row = intFootTotalStartRow + 3;
mcell2_5.Value = "Add 15% GST";
mcell2_5.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(mcell2_5);
Cell mcell3_5 = new Spire.DataExport.XLS.Cell();
mcell3_5.Column = intFootTotalStartColum;
mcell3_5.Row = intFootTotalStartRow + 4;
mcell3_5.Value = "Total Incl. GST";
mcell3_5.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(mcell3_5);
Cell mcell1_7 = new Spire.DataExport.XLS.Cell();
mcell1_7.Column = intFootTotalStartColum + 1;
mcell1_7.Row = intFootTotalStartRow + 2;
mcell1_7.Value = ApprovedexcludeGstCost;
mcell1_7.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(mcell1_7);
Cell mcell2_7 = new Spire.DataExport.XLS.Cell();
mcell2_7.Column = intFootTotalStartColum + 2;
mcell2_7.Row = intFootTotalStartRow + 3;
mcell2_7.Value = ApprovedGSTCost;
mcell2_7.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(mcell2_7);
Cell mcell3_7 = new Spire.DataExport.XLS.Cell();
mcell3_7.Column = intFootTotalStartColum + 3;
mcell3_7.Row = intFootTotalStartRow + 4;
mcell3_7.Value = ApprovedInGSTCost;
mcell3_7.CellType = Spire.DataExport.XLS.CellType.String;
workSheet.Cells.Add(mcell3_7);
DataTable InitialDataTable = new DataTable();
//'connect to dataset
workSheet.DataSource = Spire.DataExport.Common.ExportSource.DataTable;
//'workSheet.DataTable = dsQuery.Tables(0)
workSheet.DataTable = InitialDataTable;
//'workSheet.SQLCommand = oleDbCommand
workSheet.StartDataCol = Convert.ToByte(1);
cellExport.Sheets.Add(workSheet);
try
{
cellExport.SaveToHttpResponse(String.Format("{0}.xls", strNewExcelFileName), context.Response);
result = strExcelFile;
}
catch (Exception)
{
}
return(result);
}
public void Initialize()
{
var mockDb = new MockDataContext();
#region Initialize projects.
var p1 = new Project
{
ID = 1,
_projectName = "Project_1",
_projectFileTypeId = 1,
};
mockDb._projects.Add(p1);
var p2 = new Project
{
ID = 2,
_projectName = "Project_2",
_projectFileTypeId = 2
};
mockDb._projects.Add(p2);
var p3 = new Project
{
ID = 3,
_projectName = "Project_3",
_projectFileTypeId = 3
};
mockDb._projects.Add(p3);
var p4 = new Project
{
ID = 4,
_projectName = "Project_4",
_projectFileTypeId = 4
};
mockDb._projects.Add(p4);
var p5 = new ProjectFile
{
ID = 1,
_projectID = 1,
_projectFileName = "lab1",
_projectFileType = "html",
_aceExtension = "html",
_projectFileData = "hello"
};
mockDb._projectFiles.Add(p5);
var p6 = new ProjectOwner
{
ID = 1,
_projectID = 1,
_userName = "******"
};
mockDb._projectOwners.Add(p6);
var p7 = new ProjectFileViewModel
{
_id = 1,
_projectFileData = "dada",
_projectID = 1,
_projectFileName = "lab98"
};
mockDb._projectFileViewModel.Add(p7);
var p8 = new ProjectViewModel
{
_id = 1,
_isProjectOwner = true,
_projectName = "String"
};
mockDb._projectViewModel.Add(p8);
var p9 = new ApplicationUserViewModel
{
_applicationUserName = "******"
//_applicationUserProjects ""
};
mockDb.UserViewModel.Add(p9);
#endregion
_service = new ProjectService(mockDb);
}
protected void btnSignup_Click(object sender, System.EventArgs e)
{
if (m_ManagementService.GetUserCountByEmail(txtUser.Text) == 0)
{
User signUser = new User();
VoucherCodeFunctions cVoucherCode = new VoucherCodeFunctions();
string strIdentifier = null;
signUser.Email = txtUser.Text;
signUser.Password = txtPassword.Text;
signUser.Type = 2;
long signUserID = m_ManagementService.CreateUser(signUser, 0);
UserProfile signUserProfile = new UserProfile();
signUserProfile.UserId = signUserID;
signUserProfile.Email = txtUser.Text;
long userProfileId = m_ManagementService.CreateUserProfile(signUserProfile);
signUserProfile.UserProfileId = userProfileId;
strIdentifier = string.Format("{0}{1}", userProfileId, cVoucherCode.GenerateVoucherCodeGuid(16));
signUserProfile.Identifier = strIdentifier;
m_ManagementService.UpdateUserProfileIdentifier(signUserProfile);
ProjectOwner signUserOwner = new ProjectOwner();
signUserOwner.ContactId = signUserID;
long intCompanyID = m_ManagementService.CreateProjectOwner(signUserOwner);
signUserOwner.ProjectOwnerId = intCompanyID;
strIdentifier = string.Format("{0}{1}", cVoucherCode.GenerateVoucherCodeGuid(16), intCompanyID);
signUserOwner.Identifier = strIdentifier;
m_ManagementService.UpdateProjectOwnerIdentifier(signUserOwner);
m_LoginUser = m_ManagementService.Login(txtUser.Text.Trim(), txtPassword.Text.Trim());
if ((m_LoginUser != null))
{
int numberOfProjects = 0;
string strPromoCode = ConfigurationManager.AppSettings["PromoCode_SignUp"].ToString();
bool PromoCodeValid = false;
PromoCodeValid = m_ManagementService.CheckPromoCodeValidByPromoCodeUserId(strPromoCode, m_LoginUser.UserId);
if (PromoCodeValid)
{
DataSet dsPlan = default(DataSet);
dsPlan = m_ManagementService.GetPlanByPromoCodeUserId(strPromoCode, m_LoginUser.UserId);
if (dsPlan.Tables.Count > 0)
{
if (dsPlan.Tables[0].Rows.Count > 0)
{
int PlanId = 0;
if (dsPlan.Tables[0].Rows[0]["PlanId"] != DBNull.Value)
{
PlanId = Convert.ToInt32(dsPlan.Tables[0].Rows[0]["PlanId"]);
}
if (dsPlan.Tables[0].Rows[0]["NumberOfProjects"] != DBNull.Value)
{
numberOfProjects = Convert.ToInt32(dsPlan.Tables[0].Rows[0]["NumberOfProjects"]);
}
decimal storageSize = 0;
if (dsPlan.Tables[0].Rows[0]["StorageSize"] != DBNull.Value)
{
storageSize = Convert.ToDecimal(dsPlan.Tables[0].Rows[0]["StorageSize"]);
}
int term = 0;
if (dsPlan.Tables[0].Rows[0]["Term"] != DBNull.Value)
{
term = Convert.ToInt32(dsPlan.Tables[0].Rows[0]["Term"]);
}
DateTime NextBillingDate = default(DateTime);
NextBillingDate = DateTime.Now.AddMonths(term);
m_ManagementService.UpdateUserAccountMonthly(m_LoginUser.UserId, PlanId, numberOfProjects, storageSize, NextBillingDate);
m_ManagementService.CreatePromotionRedeemed(strPromoCode, m_LoginUser.UserId);
m_ManagementService.CreateUserTransaction(m_LoginUser.UserId, string.Format("Promotion - Redeem {0}", strPromoCode), 0, 0, numberOfProjects, numberOfProjects);
}
}
}
Session["CurrentLogin"] = m_LoginUser;
System.Net.Mail.MailMessage MailMessage = new System.Net.Mail.MailMessage();
System.Net.Mail.SmtpClient emailClient = new System.Net.Mail.SmtpClient(ConfigurationManager.AppSettings["SMTPServer"].ToString());
//MailMessage.To.Add(New System.Net.Mail.MailAddress(ContactProfile.Email))
MailMessage.To.Add(new System.Net.Mail.MailAddress(m_LoginUser.Email));
MailMessage.From = new System.Net.Mail.MailAddress(ConfigurationManager.AppSettings["AdminEmail"].ToString());
MailMessage.Subject = string.Format("Welcome to {0}", Request.Url.Host.Replace("www.", string.Empty));
if (numberOfProjects < 1)
{
MailMessage.Body = string.Format("Hi there,<br><br>Welcome to join Kore Projects.<br><br>Your account has been activated.<br><br>The Kore Projects Team");
}
else
{
if (numberOfProjects == 1)
{
MailMessage.Body = string.Format("Hi there,<br><br>Welcome to Kore Projects.<br><br>Your account has been activated with {0} project.<br>To visit Kore Projects please use the link below:<br><br>https://{1}<br><br>The Kore Projects Team", numberOfProjects, Request.Url.Authority);
}
else
{
MailMessage.Body = string.Format("Hi there,<br><br>Welcome to Kore Projects.<br><br>Your account has been activated with {0} projects.<br>To visit Kore Projects please use the link below:<br><br>https://{1}<br><br>The Kore Projects Team", numberOfProjects, Request.Url.Authority);
}
}
MailMessage.IsBodyHtml = true;
try
{
emailClient.Send(MailMessage);
}
catch (Exception ex)
{
//Response.Redirect(String.Format("View.aspx?&msg=Invitation hasn't been sent - { 0}", ex.Message))
//throw;
}
ServiceGroup objServiceGroup = new ServiceGroup();
objServiceGroup.UserId = m_LoginUser.UserId;
objServiceGroup.Name = "Rate Sheet 1";
int intDisplayOrder = 0;
objServiceGroup.DisplayOrder = intDisplayOrder;
objServiceGroup.IsPrivate = 2;
m_ScopeService.CreateServiceGroup(objServiceGroup);
objServiceGroup = new ServiceGroup();
objServiceGroup.UserId = m_LoginUser.UserId;
objServiceGroup.Name = "Rate Sheet 2";
objServiceGroup.DisplayOrder = intDisplayOrder;
objServiceGroup.IsPrivate = 2;
m_ScopeService.CreateServiceGroup(objServiceGroup);
if (Session["AcceptInvitation"] == null)
{
//m_jsString = "parent.location.href='Projects/View.aspx';"
m_jsString = "parent.location.href='Contacts/ProjectOwnerDetail.aspx?user=new';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "ProjectsView", m_jsString, true);
}
else
{
Session["AcceptInvitation"] = null;
m_jsString = "parent.location.href='Contacts/ProjectOwnerDetail.aspx?user=new';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "ProjectOwnerDetail", m_jsString, true);
}
}
else
{
lblErrorMessage.Text = "The user email already exists. Please use a different email address.<br>Already a member? Click <a class='loginlink' onclick=\"parent.location.href='http://www.koreprojects.com/login.asp';\" href='#'>here</a> to login.";
lblErrorMessage.Focus();
}
}
else
{
lblErrorMessage.Text = "The user email already exists. Please use a different email address.<br>Already a member? Click <a class='loginlink' onclick=\"parent.location.href='http://www.koreprojects.com/login.asp';\" href='#'>here</a> to login.";
lblErrorMessage.Focus();
}
}
public string teacherSync_project(string person_id, int type_person)
{
ResponseProjectList r = new ResponseProjectList();
ProjectOwner p = new ProjectOwner();
if (type_person == 0)
{
r.code = 11;
r.msg = "Parameter Wrong";
}
else
{
string constr = WebConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
string sqlRequest = "SELECT * FROM Relation WHERE PersID = '" + person_id + "' AND Status_ID = '1' OR Status_ID = '2'";
SqlCommand qrRequest = new SqlCommand(sqlRequest, con);
SqlDataReader reader = qrRequest.ExecuteReader();
r.projectlist = new List<ProjectOwner>();
while (reader.Read())
{
p = new ProjectOwner();
p.project = getNameProject(reader["ProjID"].ToString());
r.projectlist.Add(p);
}
reader.Close();
con.Close();
}
return JsonConvert.SerializeObject(r);
}
