public static void DeleteDuplicateTimeEntry(int BranchID)
{
try
{
using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
{
var BranchParamID = new SqlParameter("@BranchID", SqlDbType.Int);
BranchParamID.Value = BranchID;
dbHrms.ExecuteStoreCommand("uspDeleteDuplicateTimeEntry @BranchID", BranchParamID);
}
}
catch (Exception e)
{
}
}
public ActionResult SaveTimeSheet(List <string> ColumnName, List <string> ColumnValue)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
try
{
int ProjectId = Convert.ToInt32(Session["projectID"]);
int UserId = Convert.ToInt32(Session["UserID"]);
string Query = "insert into TimesheetData (UserID,ProjectID,DateOFSheet,";
foreach (var val in ColumnName)
{
Query += val + ",";
}
Query = Query.Substring(0, Query.Length - 1);
Query += ") values(" + UserId + "," + ProjectId + ",'" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "','";
foreach (var val in ColumnValue)
{
if (val.Equals(""))
{
Query = Query.Substring(0, Query.Length - 1);
Query += "null,'";
}
else
{
Query += val + "','";
}
}
Query = Query.Substring(0, Query.Length - 2);
Query += ")";
db.ExecuteStoreCommand(Query);
var obj = db.TimesheetDatas.CreateObject();
obj.UserID = UserId;
obj.ProjectID = ProjectId;
}
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(RedirectToAction("Success", "Popup"));
}
public ActionResult CompanyArchitectureData(string jsondata)
{
try
{
var json_serializer = new JavaScriptSerializer();
List <Organizechart> listdata = json_serializer.Deserialize <List <Organizechart> >(jsondata);
//DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
//List<Organizechart> model = new List<Organizechart>();
//model.Add(new Organizechart { id = 1, name = " DSRC ", parent = 0 });
//int count = 2;
//foreach (var item in db.Departments.ToList())
//{
// model.Add(new Organizechart { id = count++, name = item.DepartmentName, parent = 1 });
//}
// return Json(model, JsonRequestBehavior.AllowGet);
using (DSRCManagementSystemEntities1 dbhrms = new DSRCManagementSystemEntities1())
{
dbhrms.ExecuteStoreCommand("truncate table CompanyArchitecture");
foreach (var item in listdata)
{
var obj = dbhrms.Master_CompanyArchitecture.CreateObject();
obj.NodeId = item.id;
obj.Name = item.name;
obj.Parent = item.parent;
dbhrms.Master_CompanyArchitecture.AddObject(obj);
dbhrms.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));
}
