示例#1
0
        public IHttpActionResult PuttblTeam(int id, tblTeam tblTeam)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tblTeam.Id)
            {
                return(BadRequest());
            }

            db.Entry(tblTeam).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!tblTeamExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
示例#2
0
 public void SaveTeamDetails(TeamModel TeamModel)
 {
     if (TeamModel.Id == 0)
     {
         var team = new tblTeam()
         {
             COMPANYID   = TeamModel.CompanyId,
             TEAMCREATED = DateTime.Now,
             TEAMDESC    = TeamModel.Teamdesc,
             TEAMNAME    = TeamModel.TeamName,
             TEAMSTATUS  = "A"
         };
         entity.tblTeams.Add(team);
     }
     else
     {
         var y = entity.tblTeams.FirstOrDefault(t => t.ID == TeamModel.Id);
         y.COMPANYID   = TeamModel.CompanyId;
         y.TEAMCREATED = DateTime.Now;
         y.TEAMDESC    = TeamModel.Teamdesc;
         y.TEAMNAME    = TeamModel.TeamName;
         y.TEAMSTATUS  = "A";
     }
     entity.SaveChanges();
 }
示例#3
0
        public IHttpActionResult GettblTeam(int id)
        {
            tblTeam tblTeam = db.tblTeams.Find(id);

            if (tblTeam == null)
            {
                return(NotFound());
            }

            return(Ok(tblTeam));
        }
示例#4
0
        public IHttpActionResult PosttblTeam(tblTeam tblTeam)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tblTeams.Add(tblTeam);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = tblTeam.Id }, tblTeam));
        }
示例#5
0
        public IHttpActionResult DeletetblTeam(int id)
        {
            tblTeam tblTeam = db.tblTeams.Find(id);

            if (tblTeam == null)
            {
                return(NotFound());
            }

            db.tblTeams.Remove(tblTeam);
            db.SaveChanges();

            return(Ok(tblTeam));
        }
示例#6
0
    protected void txtAddModuleName_TextChanged(object sender, EventArgs e)
    {
        ProjectObject.AddModule(txtAddModuleName.Text, Convert.ToInt32(hdnProjectID.Value), Convert.ToInt32(Session["EmpID"]));
        var       DC         = new DataClassesDataContext();
        tblModule ModuleData = (from obj in DC.tblModules
                                orderby obj.ModuleID descending
                                select obj).First();
        tblTeam TeamData = new tblTeam();

        TeamData.ProjectID   = Convert.ToInt32(Session["ProjectID"]);
        TeamData.Description = txtAddModuleName.Text;
        TeamData.CreatedOn   = DateTime.Now;
        TeamData.CreatedBy   = Convert.ToInt32(Session["EmpID"]);
        TeamData.ModuleID    = ModuleData.ModuleID;
        DC.tblTeams.InsertOnSubmit(TeamData);
        DC.SubmitChanges();
        Response.Redirect("ProjectMaster.aspx");
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            var       DC         = new DataClassesDataContext();
            tblModule ModuleData = DC.tblModules.Single(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text));
            tblTeam   TeamData   = DC.tblTeams.Single(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text));
            int       cnt        = DC.tblTeamModules.Count(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text));
            if (cnt > 0)
            {
                tblTeamModule TeamModuleNewData = DC.tblTeamModules.Single(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text));
                if (ddTeamLeader.SelectedValue != "")
                {
                    tblNotification NotificationCancel = new tblNotification();
                    NotificationCancel.Title       = "Team Leader Cancelling";
                    NotificationCancel.Description = "You are cancel Team Leader for" + " " + ModuleData.Title + " " + "work in" + " " + lblProName.Text;
                    NotificationCancel.CreatedOn   = DateTime.Now;
                    NotificationCancel.CreatedBy   = Convert.ToInt32(Session["EmpID"]);
                    DC.tblNotifications.InsertOnSubmit(NotificationCancel);
                    DC.SubmitChanges();
                    tblNotification NID = (from obID in DC.tblNotifications
                                           orderby obID.NotificationID descending
                                           select obID).First();
                    tblNotificationDetail DetailCancel = new tblNotificationDetail();
                    DetailCancel.NotificationID = NID.NotificationID;
                    DetailCancel.PersonID       = TeamModuleNewData.EmpID;
                    DetailCancel.IsAdmin        = false;
                    DetailCancel.IsRead         = false;
                    DetailCancel.IsNotify       = false;
                    DC.tblNotificationDetails.InsertOnSubmit(DetailCancel);
                    TeamModuleNewData.EmpID = Convert.ToInt32(ddTeamLeader.SelectedValue);
                    //Notification Cancellation
                }
                //Notification
                tblNotification Notification = new tblNotification();
                Notification.Title       = "Assign Team Leader";
                Notification.Description = "You are selected Team Leader for" + " " + ModuleData.Title + " " + "work in" + " " + lblProName.Text;
                Notification.CreatedOn   = DateTime.Now;
                Notification.CreatedBy   = Convert.ToInt32(Session["EmpID"]);
                DC.tblNotifications.InsertOnSubmit(Notification);
                DC.SubmitChanges();
                tblNotification NID2 = (from obID in DC.tblNotifications
                                        orderby obID.NotificationID descending
                                        select obID).First();
                tblNotificationDetail Detail = new tblNotificationDetail();
                Detail.NotificationID = NID2.NotificationID;
                Detail.PersonID       = TeamModuleNewData.EmpID;
                Detail.IsAdmin        = false;
                Detail.IsRead         = false;
                Detail.IsNotify       = false;
                DC.tblNotificationDetails.InsertOnSubmit(Detail);
            }
            else
            {
                if (ddTeamLeader.SelectedValue != "")
                {
                    tblTeamModule TeamModuleNewData = new tblTeamModule();
                    TeamModuleNewData.EmpID     = Convert.ToInt32(ddTeamLeader.SelectedValue);
                    TeamModuleNewData.TeamID    = TeamData.TeamID;
                    TeamModuleNewData.CreatedOn = DateTime.Now;
                    TeamModuleNewData.CreatedBy = Convert.ToInt32(Session["EmpID"]);
                    TeamModuleNewData.ModuleID  = Convert.ToInt32(ltrModuleID.Text);
                    DC.tblTeamModules.InsertOnSubmit(TeamModuleNewData);
                    DC.SubmitChanges();
                    //Notification
                    tblNotification Notification = new tblNotification();
                    Notification.Title       = "Assign Team Leader";
                    Notification.Description = "You are selected Team Leader for" + " " + ModuleData.Title + " " + "work in" + " " + lblProName.Text;
                    Notification.CreatedOn   = DateTime.Now;
                    Notification.CreatedBy   = Convert.ToInt32(Session["EmpID"]);
                    DC.tblNotifications.InsertOnSubmit(Notification);
                    DC.SubmitChanges();
                    tblNotification NID = (from obID in DC.tblNotifications
                                           orderby obID.NotificationID descending
                                           select obID).First();
                    tblNotificationDetail Detail = new tblNotificationDetail();
                    Detail.NotificationID = NID.NotificationID;
                    Detail.PersonID       = TeamModuleNewData.EmpID;
                    Detail.IsAdmin        = false;
                    Detail.IsRead         = false;
                    Detail.IsNotify       = false;
                    DC.tblNotificationDetails.InsertOnSubmit(Detail);
                }
            }
            ModuleData.Title       = txtModuleName.Text;
            ModuleData.Description = txtCkEditor.Text;
            tblProject ProjectData = DC.tblProjects.Single(ob => ob.ProjectID == ModuleData.ProjectID);
            if (txtDDate.Text != "")
            {
                if (Convert.ToDateTime(txtDDate.Text) < ProjectData.DeadlineDate && Convert.ToDateTime(txtDDate.Text) > ModuleData.AssignDate)
                {
                    if (txtDDate.Text == "")
                    {
                        if (lblDDate.Text != "Select Deadline Date")
                        {
                            ModuleData.DeadlineDate = Convert.ToDateTime(lblDDate.Text);
                        }
                    }
                    else
                    {
                        ModuleData.DeadlineDate = Convert.ToDateTime(txtDDate.Text);
                    }
                }
                else
                {
                    Session["errorDDate"] = true;
                }
            }
            if (ddPriority.SelectedValue != "")
            {
                ModuleData.Priority = Convert.ToInt32(ddPriority.SelectedValue);
            }
            if (ddRisk.SelectedValue != "")
            {
                ModuleData.Risk = Convert.ToInt32(ddRisk.SelectedValue);
            }
            if (ddState.SelectedIndex == 3)
            {
                int TaskPanding = DC.tblTasks.Count(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text) && ob.State != 4);
                if (TaskPanding > 0)
                {
                    Session["errorClose"] = true;
                }
                else
                {
                    ModuleData.State = Convert.ToInt32(ddState.SelectedValue);
                }
            }
            else
            {
                ModuleData.State = Convert.ToInt32(ddState.SelectedValue);
            }

            if ((DC.tblTeamModules.Count(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text))) > 0)
            {
                tblTeamModule MemberData      = DC.tblTeamModules.Single(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text));
                int           cntEmpAppraisal = DC.tblEmpAppraisals.Count(ob => ob.EmpID == MemberData.EmpID);

                if (MemberData.EmpID != null)
                {
                    if (cntEmpAppraisal > 0)
                    {
                        tblEmpAppraisal EmpAppraisalData = DC.tblEmpAppraisals.Single(ob => ob.EmpID == MemberData.EmpID);
                        EmpAppraisalData.Quality       = EmpAppraisalData.Quality + Convert.ToDecimal(rngQuality.Text);
                        EmpAppraisalData.Avialibility  = EmpAppraisalData.Avialibility + Convert.ToDecimal(rngAvialibility.Text);
                        EmpAppraisalData.Communication = EmpAppraisalData.Communication + Convert.ToDecimal(rngCommunication.Text);
                        EmpAppraisalData.Cooperation   = EmpAppraisalData.Cooperation + Convert.ToDecimal(rngCooperation.Text);
                    }
                    else
                    {
                        int cntAppraisal = DC.tblTeamModules.Count(ob => ob.ModuleID == Convert.ToInt32(ltrModuleID.Text));
                        //Response.Redirect(cntAppraisal.ToString());
                        if (cntAppraisal > 0)
                        {
                            tblEmpAppraisal EmpAppraisalData = new tblEmpAppraisal();
                            EmpAppraisalData.EmpID         = MemberData.EmpID;
                            EmpAppraisalData.Quality       = Convert.ToDecimal(rngQuality.Text);
                            EmpAppraisalData.Avialibility  = Convert.ToDecimal(rngAvialibility.Text);
                            EmpAppraisalData.Communication = Convert.ToDecimal(rngCommunication.Text);
                            EmpAppraisalData.Cooperation   = Convert.ToDecimal(rngCooperation.Text);
                            EmpAppraisalData.Skills        = Convert.ToDecimal(0.0);
                            EmpAppraisalData.Deadlines     = Convert.ToDecimal(0.0);
                            EmpAppraisalData.CreatedOn     = DateTime.Now;
                            EmpAppraisalData.CreatedBy     = Convert.ToInt32(Session["EmpID"]);
                            DC.tblEmpAppraisals.InsertOnSubmit(EmpAppraisalData);
                        }
                    }
                }
            }

            DC.SubmitChanges();
            Response.Redirect("ModuleDetail.aspx");
        }
        catch (Exception ex)
        {
            int    session    = Convert.ToInt32(Session["EmpID"].ToString());
            string PageName   = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
            string MACAddress = GetMacAddress();
            AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress);
            ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
        }
    }