public List<ProjectVM> GetTime()
{
ProjectService PS = new ProjectService();
var result = PS.GetAllProjects();
if (result == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
return result;
}
public List<string> SyncData()
{
List<string> listReturnValues = new List<string>();
try
{
List<ProjectVM> projectList = new List<ProjectVM>();
ProjectService getProjects = new ProjectService();
projectList = getProjects.GetAllProjects();
foreach (ProjectVM proVM in projectList)
{
SqlQueries.Project_Main_Tbl mainTableIsertionObject = new SqlQueries.Project_Main_Tbl();
listReturnValues.Add(mainTableIsertionObject.InsertOrUpdate(proVM));
}
#region // delete project not in redmine
DataTable dt = dc.GetDataTable("Select [Project_Id] from [dbo].[Project_Main] ");
List<Int64> projectIdRedmine = new List<Int64>();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < projectList.Count; i++)
{
projectIdRedmine.Add(projectList[i].id);
}
foreach (DataRow dr in dt.Rows)
{
//delete project which are not present
if (!projectIdRedmine.Contains(Convert.ToInt64(dr["Project_Id"])))
{
string deleteProjectRowQuery = "Delete from Project_Main where Project_Id = '" + dr["Project_Id"].ToString() + "'";
listReturnValues.Add("Rows Delted for ProjectId " + dr["Project_Id"].ToString() + ": " + dc.InsertUpdateDelete(deleteProjectRowQuery).ToString());
}
}
}
}
#endregion
listReturnValues.Add("Sync Sucess");
return listReturnValues;
}
catch (Exception ex)
{
Logger.Error("JsonToSQL.SyncData" + ex.ToString());
listReturnValues.Add("Sync Failed:" + ex.ToString());
return listReturnValues;
}
}
public List<string> SyncProjects()
{
List<string> listReturnValues = new List<string>();
try
{
List<ProjectVM> projectList = new List<ProjectVM>();
ProjectService getProjects = new ProjectService();
projectList = getProjects.GetAllProjects();
foreach (ProjectVM proVM in projectList)
{
SqlQueries.Project_Main_Tbl mainTableIsertionObject = new SqlQueries.Project_Main_Tbl();
string mainTableResult = mainTableIsertionObject.InsertOrUpdate(proVM);
//if (mainTableResult == "Success")
//{
// SqlQueries.Membership_Tbl membershipTblObj;
// foreach (Membership mem in proVM.members)
// {
// foreach (Role role in mem.roles)
// {
// membershipTblObj = new SqlQueries.Membership_Tbl();
// string membershipResult = membershipTblObj.InsertOrUpdateMembership(mem.id.ToString(), mem.user.id.ToString(), role.name, proVM.id.ToString());
// }
// }
//}
listReturnValues.Add("ProjectId = " + proVM.id.ToString() + " MainTable : " + mainTableResult);
}
#region // delete project not in redmine
DataTable dt = dc.GetDataTable("Select [Project_Id] from [dbo].[Project_Main] ");
List<Int64> projectIdRedmine = new List<Int64>();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < projectList.Count; i++)
{
projectIdRedmine.Add(projectList[i].id);
}
foreach (DataRow dr in dt.Rows)
{
//delete project which are not present
if (!projectIdRedmine.Contains(Convert.ToInt64(dr["Project_Id"])))
{
string deleteProjectRowQuery = "Delete from [Memberships] where Project_Id= '" + dr["Project_Id"].ToString() + "' Delete from Project_Main where Project_Id = '" + dr["Project_Id"].ToString() + "' ";
listReturnValues.Add("Rows Delted for ProjectId " + dr["Project_Id"].ToString() + ": " + dc.InsertUpdateDelete(deleteProjectRowQuery).ToString());
}
}
}
}
#endregion
listReturnValues.Add("Sync Sucess");
return listReturnValues;
}
catch (Exception ex)
{
Logger.Error("JsonToSQL.SyncData" + ex.ToString());
listReturnValues.Add("Sync Failed:" + ex.ToString());
return listReturnValues;
}
}
