public HtmlParser(TimesheetType timesheetType)
{
if (timesheetType == TimesheetType.Draft)
{
_timesheetParserStrategy = new DraftTimesheetParserStrategy();
}
else
{
_timesheetParserStrategy = new ApprovedTimesheetParserStrategy();
}
}
//public ActionResult FinalizeDefaultTemplate(int ProjectID)
//{
// return Json(true, JsonRequestBehavior.AllowGet);
//}
public ActionResult FinalizeDefaultTemplate()
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
try
{
var ProjectId = Convert.ToInt32(Session["projectID"].ToString());
var typobj = db.TimesheetTypes.Where(o => o.ProjectID == ProjectId).Select(o => o).FirstOrDefault();
if (typobj == null)
{
var dataobj = new TimesheetType();
dataobj.ProjectID = ProjectId;
dataobj.IsGrouped = false;
db.TimesheetTypes.AddObject(dataobj);
}
else
{
typobj.IsGrouped = false;
}
db.SaveChanges();
List <Column> defaultcolumnlist = db.DefaultTemplates.Select(o =>
new Column
{
ColumnName = o.ColumnName,
ColumnTypeId = o.ColumnTypeID
}).ToList();
string columnname;
foreach (var item in defaultcolumnlist)
{
columnname = item.ColumnName.Contains(" ") ? item.ColumnName.Replace(" ", "") : item.ColumnName;
var timesheetcolumnobj = db.TimeSheetColumns.CreateObject();
timesheetcolumnobj.ProjectID = ProjectId;
timesheetcolumnobj.ColumnNames = columnname;
timesheetcolumnobj.ColumnDisplayName = item.ColumnName;
timesheetcolumnobj.ColumnTypeID = item.ColumnTypeId;
timesheetcolumnobj.IsActive = true;
db.TimeSheetColumns.AddObject(timesheetcolumnobj);
db.SaveChanges();
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult ChangeTimeSheetType(bool val)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
try
{
int?ID;
var pID = Session["projectID"];
if (pID == null)
{
ID = null;
}
else
{
ID = int.Parse(Session["projectID"].ToString());
}
if (val)
{
if (db.TimesheetTypes.Where(o => o.ProjectID == ID).Select(o => o).ToList().Count == 0)
{
var typobj = db.TimesheetTypes.CreateObject();
typobj.IsGrouped = true;
typobj.ProjectID = ID;
db.TimesheetTypes.AddObject(typobj);
}
else
{
var typobj = db.TimesheetTypes.Where(o => o.ProjectID == ID).Select(o => o).FirstOrDefault();
if (typobj == null)
{
var dataobj = new TimesheetType();
dataobj.ProjectID = ID;
dataobj.IsGrouped = true;
db.TimesheetTypes.AddObject(dataobj);
}
else
{
typobj.IsGrouped = true;
}
db.SaveChanges();
}
}
else
{
var typobj = db.TimesheetTypes.Where(o => o.ProjectID == ID).Select(o => o).FirstOrDefault();
if (typobj == null)
{
var dataobj = new TimesheetType();
dataobj.ProjectID = ID;
dataobj.IsGrouped = false;
db.TimesheetTypes.AddObject(dataobj);
}
else
{
typobj.IsGrouped = false;
}
db.SaveChanges();
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
