public void InsertTimesheet(int TimesheetColumnID, string TimeSheetValue, int UserID, int ProjectID, string Date)
{
using (var db = new DSRCManagementSystemEntities1())
{
TimesheetModel lstTimeshhetData = new TimesheetModel();
lstTimeshhetData = db.ExecuteStoreQuery <TimesheetModel>("exec SP_InsertTimesheetData @TimesheetColumnID={0},@TimeSheetValue={1},@UserID={2},@ProjectID={3},@SubmittedDate={4}", TimesheetColumnID, TimeSheetValue, UserID, ProjectID, Date).FirstOrDefault();
}
}
public ActionResult AddNewSubGroup(Template objTemplate)
{
ViewBag.Lbl_depgroup = CommonLogic.getLabelName(3).ToString();
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
try
{
int?ID;
var pID = Session["projectID"];
if (pID == null)
{
ID = null;
}
else
{
ID = int.Parse(Session["projectID"].ToString());
}
int?GroupID;
if (objTemplate.groupName != null)
{
GroupID = int.Parse(objTemplate.groupName.ToString());
}
else
{
GroupID = null;
}
string columnname = objTemplate.columnName.Contains(" ") ? objTemplate.columnName.Replace(" ", "") : objTemplate.columnName;
if (!db.TimeSheetColumns.Any(o => o.ProjectID == ID && o.ColumnNames == columnname && o.IsActive != false))
{
var t = new TimeSheetColumn()
{
ColumnNames = columnname,
ColumnTypeID = objTemplate.columnTypeID,
ColumnDisplayName = objTemplate.columnName,
GroupID = GroupID,
ProjectID = ID,
IsActive = objTemplate.IsActive
};
db.TimeSheetColumns.AddObject(t);
db.SaveChanges();
db.Dispose();
db = new DSRCManagementSystemEntities1();
int ColumnId;
if (GroupID != null)
{
ColumnId = db.TimeSheetColumns.Where(o => o.ProjectID == ID && o.ColumnNames == columnname && o.GroupID == GroupID).Select(o => o.TimeSheetColumnID).FirstOrDefault();
}
else
{
ColumnId = db.TimeSheetColumns.Where(o => o.ProjectID == ID && o.ColumnNames == columnname && o.GroupID == null).Select(o => o.TimeSheetColumnID).FirstOrDefault();
}
db.ExecuteStoreQuery <Template>("exec SP_AddTimesheetDataColumn @ColumnName={0} ,@ColumnType= {1}", columnname, (objTemplate.columnTypeID == 1 ? "DATETIME" : "nvarchar(MAX)")).FirstOrDefault();
return(Json(ColumnId, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
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(View());
}
