protected void LoadControl(RadGrid rg, string ctrlIdentity)
        {
            objBLL = new MetisBLL();
            DataTable dt = objBLL.getWeeklyData();

            rgWeekly.DataSource = dt;
            rgWeekly.DataBind();
        }
示例#2
0
        protected override void OnPreRender(EventArgs e)
        {
            base.OnPreRender(e);
            MetisBLL bll = new MetisBLL();
            // calling the getResourceById procedure using ResourceId.
            DataTable dt = new DataTable();

            dt = bll.getResourceDetailById(ResourceId);
            ResourceView.DataSource = dt;
            ResourceView.DataBind();
        }
示例#3
0
        private void loadDdl()
        {
            objBLL = new MetisBLL();
            DataTable dt = new DataTable();

            dt = objBLL.getProjectType();
            ProjectType.DataSource     = dt;
            ProjectType.DataTextField  = dt.Columns[1].ToString();
            ProjectType.DataValueField = dt.Columns[0].ToString();
            ProjectType.DataBind();
        }
示例#4
0
        protected void rgUpComingProject_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            objBLL = new MetisBLL();
            DataTable dt = new DataTable();

            dt = objBLL.getAllUpComingProject();
            DataView dv = new DataView(dt);

            dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
            rgUpComingProject.DataSource = dv;
        }
        protected void LoadControl(DropDownList ddl, string ctrlIdentity)
        {
            objBLL = new MetisBLL();

            switch (ctrlIdentity)
            {
            case "Department":
                DataTable dt = objBLL.getDeparments();
                ddl.DataSource     = dt;
                ddl.DataTextField  = dt.Columns[1].ToString();
                ddl.DataValueField = dt.Columns[0].ToString();
                ddl.DataBind();
                break;
            }
        }
示例#6
0
 protected void rgActionItem_DeleteCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
 {
     try
     {
         string   p_message = "";
         MetisBLL objBll    = new MetisBLL();
         objBll.deleteActionItem(Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["pkID"].ToString()), out p_message);
         rgActionItem.Rebind();
     }
     catch (Exception ex)
     {
         rgUpComingProject.Controls.Add(new LiteralControl("Unable to delete record. Reason: " + ex.Message));
         e.Canceled = true;
     }
 }
示例#7
0
        protected void rgActionItem_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            objBLL = new MetisBLL();
            DataTable dt = new DataTable();

            if (chkbArchive.Checked)
            {
                dt = objBLL.getAllArchiveActionItem();
            }
            else
            {
                dt = objBLL.getAllActionItem();
            }
            DataView dv = new DataView(dt);

            dv.RowFilter            = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
            rgActionItem.DataSource = dv;
        }
示例#8
0
        public Subject CreateSubject()
        {
            //Creating Subject result for TPI ctegory using category's sybjectId
            SubjectResult subResult   = kService.CreateSubject(kSession, "1-1021");
            Subject       tempSubject = subResult.Subject;

            List <Field> subjectFieldList = new List <Field>();

            //List<ValueField> subjectFieldList = new List<ValueField>();


            //Creating Value fields

            ////getting next project id
            objBLL = new MetisBLL();
            DataTable dt = new DataTable();

            dt = objBLL.getNextProjectID();
            string prj_id = dt.Rows[0]["ProjectID"].ToString();



            subjectFieldList.Add(CreateValField("Project Name", ProjectName.Text));
            subjectFieldList.Add(CreateValField("Project_ID", prj_id));

            // subjectFieldList.Add(CreateValField("ContactName", ""));

            ////Creating Reference fields
            //// get the subject id from the drop down
            //  subjectFieldList.Add(CreateRefField(ProjectType.SelectedValue.ToString(), "Project Type")); // Item Status (Active)
            //subjectFieldList.Add(CreateRefField("", "Customer")); //Daymon Represented Flag
            //subjectFieldList.Add(CreateRefField("", "PracticeDetail")); //Organic


            ////Creating AutoGeneratedFields
            //subjectFieldList.Add(CreateAutoGeneratedValField("TradingPartnerMDMId")); //Kalido Generated ID

            //Assigning fields to subject
            tempSubject.Fields = subjectFieldList.ToArray();


            return(tempSubject);
        }
示例#9
0
        protected void btnEmail_Click(object sender, ImageClickEventArgs e)
        {
            objBLL = new MetisBLL();
            DataTable dtActionItem            = new DataTable();
            DataTable dtDistinctResourceEmail = new DataTable();

            if (chkbArchive.Checked)
            {
                dtActionItem = objBLL.getAllArchiveActionItem();
            }
            else
            {
                dtActionItem = objBLL.getAllActionItem();
            }
            dtDistinctResourceEmail = objBLL.getAllActionItemsResourceEmail(); // get distinct email
            DataView   dv  = new DataView(dtActionItem);
            DataView   dv2 = new DataView(dtDistinctResourceEmail);
            GridColumn gridResourceColumn   = rgActionItem.MasterTableView.GetColumnSafe("Resource_name");
            GridColumn gridActionItemColumn = rgActionItem.MasterTableView.GetColumnSafe("ActionItem");

            dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'" +
                           " AND Resource_name like '%" + (gridResourceColumn.CurrentFilterValue.ToString().Replace("'", "''") == String.Empty ? "" : gridResourceColumn.CurrentFilterValue.ToString().Replace("'", "''")) + "%'" +
                           " AND Action_Item like '%" + (gridActionItemColumn.CurrentFilterValue.ToString().Replace("'", "''") == String.Empty ? "" : gridActionItemColumn.CurrentFilterValue.ToString().Replace("'", "''")) + "%'";
            dv2.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";

            //Storing ResourceName and Email in Dictionary
            mapDataTableToDictionary(dv2);
            /// loop through DV (DataView) and transform datarows to html Table
            foreach (DataRowView drv in dv)
            {
                transformRowsToHTMLTable(drv);
            }
            string cc      = ConfigurationSettings.AppSettings["ActionItemsCC"];
            string from    = ConfigurationSettings.AppSettings["ActionItemsFrom"];
            string replyto = ConfigurationSettings.AppSettings["ActionItemsReplyto"];

            for (int i = 0; i < emailBodyList.Count; i++)
            {
                SendMail("smtp.gmail.com", from, emailBodyList.ElementAt(i).Key + "@streebo.com", cc, replyto, "<b>To do List</b><br/>" + emailBodyList.ElementAt(i).Value + "</table>", "Your Action Items", true);
            }
        }
示例#10
0
        public void SendMail(string smtpAddress, string from, string to, string cc, string replyTo, string body, string subject, bool isHtml)
        {
            MailMessage email = new MailMessage();

            email.From = new MailAddress("*****@*****.**", "Streebo Metis");
            if (replyTo != String.Empty)
            {
                email.ReplyTo = new MailAddress(replyTo);
            }

            Dictionary <string, string> lstResourceWithEmail = new Dictionary <string, string>();

            objBLL = new MetisBLL();
            DataTable dtable = objBLL.getAllResourcesWithEmail();

            email.To.Add(to);

            if (cc != String.Empty)
            {
                email.CC.Add(cc);
            }

            email.Body       = body;
            email.Subject    = subject;
            email.IsBodyHtml = isHtml;
            //email.Attachments.Add(new Attachment(attachmentStream, fileName));

            SmtpClient smtp = new SmtpClient("localhost", 587);

            smtp.Host        = "smtp.gmail.com"; //Or Your SMTP Server Address
            smtp.Credentials = new System.Net.NetworkCredential
                                   ("*****@*****.**", "Inbox@1234");
            //Or your Smtp Email ID and Password
            smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
            smtp.EnableSsl      = true;
            smtp.Send(email);
        }
示例#11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Boolean b_CanInsert = false;

            objBLL = new MetisBLL();
            System.Data.DataTable dt = objBLL.getAccessRights(Convert.ToString(Session["user"]));
            foreach (System.Data.DataRow row in dt.Rows)
            {
                if (row["EntityName"].ToString() == "ResSum")
                {
                    b_CanInsert = Convert.ToBoolean(row["Can_Insert"]);
                }
            }
            //If Admin thn bypass security
            if (b_CanInsert == false)
            {
                objBLL = new MetisBLL();
                if (Convert.ToBoolean(objBLL.IsAdmin(Convert.ToString(Session["user"]))))
                {
                    b_CanInsert = true;
                }
            }
            if (b_CanInsert)
            {
                string id = Request.QueryString["id"].ToString();
                if (string.IsNullOrEmpty(id) || id.ToLower() == "null")
                {
                    Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "abc", "<script type='text/javascript'>window.close();</script>");
                }
                else
                {
                    //Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "abc", "<script type='text/javascript'>window.close();</script>");
                    objBLL = new MetisBLL();
                    DataTable dat = objBLL.getBulkName(Convert.ToInt16(id));
                    comboProjectName.DataSource     = dat;
                    comboProjectName.DataTextField  = dat.Columns[1].ToString();
                    comboProjectName.DataValueField = dat.Columns[0].ToString();
                    comboProjectName.DataBind();

                    dWeekEnding.SelectedDate = DateTime.Today;


                    objBLL = new MetisBLL();
                    dat    = objBLL.getBulkResource(Convert.ToInt16(id));
                    comboResourceName.DataSource     = dat;
                    comboResourceName.DataValueField = dat.Columns[0].ToString();
                    comboResourceName.DataBind();
                    dWeekEnding.Enabled = false;
                    Label7.Visible      = false;
                }

                //objBLL = new MetisBLL();
                //DataTable dat = objBLL.getBulkName(Convert.ToInt16(id));
                //comboProjectName.DataSource = dat;
                //comboProjectName.DataTextField = dat.Columns[1].ToString();
                //comboProjectName.DataValueField = dat.Columns[0].ToString();
                //comboProjectName.DataBind();

                //dWeekEnding.SelectedDate = DateTime.Today;


                //objBLL = new MetisBLL();
                //dat = objBLL.getBulkResource(Convert.ToInt16(id));
                //comboResourceName.DataSource = dat;
                //comboResourceName.DataValueField = dat.Columns[0].ToString();
                //comboResourceName.DataBind();
            }

            else
            {
                Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "abc", "<script type='text/javascript'>window.close();</script>");
            }


            //string script = "clientClose('');";

            //ScriptManager.RegisterStartupScript(Page, typeof(Page),
            //   "closeScript", script, true);
        }
示例#12
0
        //protected void Page_Load(object sender, EventArgs e)
        //{
        //    if (!IsPostBack)
        //    {

        //        objBLL = new MetisBLL();
        //        DataTable dt = objBLL.getDeparments();
        //        ddlDepartment.DataSource = dt;
        //        ddlDepartment.DataTextField = dt.Columns[1].ToString();
        //        ddlDepartment.DataValueField = dt.Columns[0].ToString();
        //        ddlDepartment.DataBind();
        //        ddlDepartment.SelectedValue = "dpt_02";

        //        dt = new DataTable();
        //        dt = objBLL.getAllActionItem();
        //        DataView dv = new DataView(dt);
        //        dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
        //        rgActionItem.DataSource = dv;
        //        rgActionItem.DataBind();

        //        dt = new DataTable();
        //        dt = objBLL.getAllUpComingProject();
        //        dv = new DataView(dt);
        //        dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
        //        rgUpComingProject.DataSource = dv;



        //    }
        //}

        protected void Page_Load(object sender, EventArgs e)
        {
            //int x = Convert.ToInt32(Session["isLogin"]);

            //if (x == 0)
            //    RFSs.Visible = false;
            //else
            //    RFSs.Visible = true;

            if (!IsPostBack)
            {
                #region Check Login

                if (Convert.ToString(Session["user"]) == "")
                {
                    Response.Redirect("Login.aspx");
                }
                #endregion
                #region Check Rights
                b_CanView = false;

                objBLL = new MetisBLL();
                System.Data.DataTable dt = objBLL.getAccessRights(Convert.ToString(Session["user"]));
                foreach (System.Data.DataRow row in dt.Rows)
                {
                    if (row["EntityName"].ToString() == "UpcomingProj")
                    {
                        b_CanView = Convert.ToBoolean(row["Can_View"]);
                    }
                }
                //  If Admin thn bypass security
                if (b_CanView == false)
                {
                    objBLL = new MetisBLL();
                    if (Convert.ToBoolean(objBLL.IsAdmin(Convert.ToString(Session["user"]))))
                    {
                        b_CanView = true;
                    }
                }
                #endregion
                if (b_CanView)
                {
                    objBLL = new MetisBLL();
                    dt     = depManager.getDeparments();
                    ddlDepartment.DataSource     = dt;
                    ddlDepartment.DataTextField  = dt.Columns[1].ToString();
                    ddlDepartment.DataValueField = dt.Columns[0].ToString();
                    ddlDepartment.DataBind();
                    ddlDepartment.SelectedValue = "dpt_01";     // IM - SSL By Default
                    if (Session["ddlDepartment"] != null)
                    {
                        ddlDepartment.SelectedValue = Session["ddlDepartment"].ToString();
                    }
                    Session["ddlDepartment"] = ddlDepartment.SelectedValue;


                    dt = new DataTable();
                    dt = objBLL.getAllActionItem();
                    DataView dv = new DataView(dt);
                    dv.RowFilter            = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
                    rgActionItem.DataSource = dv;
                    rgActionItem.DataBind();

                    dt           = new DataTable();
                    dt           = objBLL.getAllUpComingProject();
                    dv           = new DataView(dt);
                    dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
                    rgUpComingProject.DataSource = dv;
                }
                else
                {
                    main.Visible = false;
                    lblErr.Text  = "403 Forbidden";
                }
            }
        }
示例#13
0
        protected void rgActionItem_ItemCommand(object sender, GridCommandEventArgs e)
        {
            if (e.CommandName.Equals("PerformInsert"))
            {
                GridDataItem item                   = (GridDataItem)e.Item;
                TextBox      txtActionItem          = (e.Item as GridEditableItem)["ActionItem"].FindControl("txtActionItem") as TextBox;
                DropDownList ddlResourceName        = (e.Item as GridEditableItem)["Resource_name"].FindControl("comboResourceName") as DropDownList;
                Telerik.Web.UI.RadDatePicker Target = (e.Item as GridEditableItem)["Target"].FindControl("Target") as Telerik.Web.UI.RadDatePicker;
                TextBox txtStatus                   = (e.Item as GridEditableItem)["Status"].FindControl("txtStatus") as TextBox;

                string   ActionItem = txtActionItem.Text;
                string   ResourceID = ddlResourceName.SelectedValue;
                DateTime DTarget    = (DateTime)Target.SelectedDate;
                string   Status     = txtStatus.Text;
                string   p_message1 = String.Empty;

                objBLL = new MetisBLL();
                objBLL.insertActionItem(ActionItem, ResourceID, DTarget, Status, ddlDepartment.SelectedValue, out p_message1);

                rgActionItem.Rebind();
            }

            if (e.CommandName.Equals("Edit"))
            {
                GridDataItem item = (GridDataItem)e.Item;

                string ActionItem = ((DataBoundLiteralControl)item.Controls[3].Controls[0]).Text.Trim();
                string Resource   = ((DataBoundLiteralControl)item.Controls[4].Controls[0]).Text.Trim();
                string Target     = ((DataBoundLiteralControl)item.Controls[5].Controls[0]).Text.Trim();
                string Status     = ((DataBoundLiteralControl)item.Controls[6].Controls[0]).Text.Trim();


                Session["ActionItem"]    = ActionItem;
                Session["Resource_name"] = Resource;
                Session["Target"]        = Target;
                Session["Status"]        = Status;
            }


            if (e.CommandName.Equals("Update"))
            {
                GridDataItem item                   = (GridDataItem)e.Item;
                TextBox      txtActionItem          = (e.Item as GridEditableItem)["ActionItem"].FindControl("txtActionItem") as TextBox;
                DropDownList ddlResourceName        = (e.Item as GridEditableItem)["Resource_name"].FindControl("comboResourceName") as DropDownList;
                Telerik.Web.UI.RadDatePicker Target = (e.Item as GridEditableItem)["Target"].FindControl("Target") as Telerik.Web.UI.RadDatePicker;
                TextBox txtStatus                   = (e.Item as GridEditableItem)["Status"].FindControl("txtStatus") as TextBox;

                string   ActionItem = txtActionItem.Text;
                string   ResourceID = ddlResourceName.SelectedValue;
                DateTime DTarget    = (DateTime)Target.SelectedDate;
                string   Status     = txtStatus.Text;
                string   p_message1 = String.Empty;

                objBLL = new MetisBLL();
                objBLL.updateActionItem(Convert.ToInt32(item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["pkID"].ToString()), ActionItem, ResourceID, DTarget, Status, ddlDepartment.SelectedValue, out p_message1);

                rgActionItem.Rebind();
            }


            if (e.CommandName.Equals("Cancel"))
            {
                rgActionItem.DataBind();
            }
            if (e.CommandName.Equals("Archive"))
            {
                GridDataItem item       = (GridDataItem)e.Item;
                string       p_message1 = String.Empty;
                objBLL = new MetisBLL();
                objBLL.archiveActionItem(int.Parse(item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["pkID"].ToString()), out p_message1);
                rgActionItem.Rebind();
            }
            if (e.CommandName.Equals("unArchive"))
            {
                GridDataItem item       = (GridDataItem)e.Item;
                string       p_message1 = String.Empty;
                objBLL = new MetisBLL();
                objBLL.unArchiveActionItem(int.Parse(item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["pkID"].ToString()), out p_message1);
                rgActionItem.Rebind();
            }
        }
示例#14
0
        protected void rgActionItem_ItemDataBound(object sender, GridItemEventArgs e)
        {
            try
            {
                if (e.Item is GridDataItem && e.Item.IsInEditMode)
                {
                    GridDataItem item            = (GridDataItem)e.Item;
                    TextBox      txtActionItem   = (e.Item as GridEditableItem)["ActionItem"].FindControl("txtActionItem") as TextBox;
                    DropDownList ddlResourceName = (e.Item as GridEditableItem)["Resource_name"].FindControl("comboResourceName") as DropDownList;
                    objBLL = new MetisBLL();
                    ddlResourceName.DataSource     = objBLL.getAllResources(Session["user"].ToString());
                    ddlResourceName.DataTextField  = objBLL.getAllResources(Session["user"].ToString()).Columns[1].ToString();
                    ddlResourceName.DataValueField = objBLL.getAllResources(Session["user"].ToString()).Columns[0].ToString();
                    ddlResourceName.DataBind();
                    ddlResourceName.Width = Unit.Pixel(240); // Set the width
                    ddlResourceName.Focus();
                    Telerik.Web.UI.RadDatePicker Target = (e.Item as GridEditableItem)["Target"].FindControl("Target") as Telerik.Web.UI.RadDatePicker;
                    TextBox txtStatus = (e.Item as GridEditableItem)["Status"].FindControl("txtStatus") as TextBox;
                    if (e.Item is GridEditFormInsertItem || e.Item is GridDataInsertItem)
                    {
                    }
                    else
                    {
                        txtActionItem.Text = Session["ActionItem"].ToString();
                        ddlResourceName.Items.FindByText(Session["Resource_name"].ToString()).Selected = true;
                        Target.SelectedDate = Convert.ToDateTime(Session["Target"].ToString());
                        txtStatus.Text      = Session["Status"].ToString();
                    }
                }
                else
                {
                    //GridDataItem item = e.Item as GridDataItem;
                    //if (item != null)
                    //{
                    //    GridButtonColumn gBtnCol = item.OwnerTableView.GetColumn("ArchiveColumn") as GridButtonColumn;

                    //    ImageButton ImgBtn = item["ArchiveColumn"].Controls[0] as ImageButton;
                    //    if (chkbArchive.Checked)
                    //    {
                    //        ImgBtn.ImageUrl = "images/show.png";
                    //        ImgBtn.CommandName = "unArchive";
                    //        gBtnCol.ConfirmText = "Are you sure you want to UnArchive?";
                    //        gBtnCol.ConfirmTitle = "UnArchive";
                    //        ImgBtn.ToolTip = "UnArchive";
                    //    }
                    //    else
                    //    {
                    //        ImgBtn.ImageUrl = "images/hide.png";
                    //        ImgBtn.CommandName = "Archive";
                    //        gBtnCol.ConfirmText = "Are you sure you want to Archive?";
                    //        gBtnCol.ConfirmTitle = "Archive";
                    //        ImgBtn.ToolTip = "Archive";
                    //    }

                    //}
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, typeof(string), "validation", "alert('" + ex.Message + "')", true);
            }
        }
示例#15
0
        protected void rgUpComingProject_ItemCommand(object sender, GridCommandEventArgs e)
        {
            if (e.CommandName.Equals("PerformInsert"))
            {
                GridDataItem item       = (GridDataItem)e.Item;
                TextBox      txtProject = (e.Item as GridEditableItem)["Project"].FindControl("txtProject") as TextBox;
                Telerik.Web.UI.RadDatePicker DesiredStart = (e.Item as GridEditableItem)["DesiredStart"].FindControl("DesiredStart") as Telerik.Web.UI.RadDatePicker;
                Telerik.Web.UI.RadDatePicker PlannedStart = (e.Item as GridEditableItem)["PlannedStart"].FindControl("PlannedStart") as Telerik.Web.UI.RadDatePicker;
                TextBox txtResource = (e.Item as GridEditableItem)["Resources"].FindControl("txtResource") as TextBox;
                TextBox txtComment  = (e.Item as GridEditableItem)["Comments"].FindControl("txtComment") as TextBox;

                string   project       = txtProject.Text;
                DateTime dDesiredStart = (DateTime)DesiredStart.SelectedDate;
                DateTime dPlannedStart = (DateTime)PlannedStart.SelectedDate;
                string   resource      = txtResource.Text;
                string   comment       = txtComment.Text;
                string   p_message1    = String.Empty;

                objBLL = new MetisBLL();
                objBLL.insertUpComingProject(project, dDesiredStart, dPlannedStart, resource, comment, ddlDepartment.SelectedValue, out p_message1);


                rgUpComingProject.Rebind();
            }

            if (e.CommandName.Equals("Edit"))
            {
                GridDataItem item = (GridDataItem)e.Item;

                string project      = ((DataBoundLiteralControl)item.Controls[3].Controls[0]).Text.Trim();
                string desiredStart = ((DataBoundLiteralControl)item.Controls[4].Controls[0]).Text.Trim();
                string plannedStart = ((DataBoundLiteralControl)item.Controls[5].Controls[0]).Text.Trim();
                string resource     = ((DataBoundLiteralControl)item.Controls[6].Controls[0]).Text.Trim();
                string comment      = ((DataBoundLiteralControl)item.Controls[7].Controls[0]).Text.Trim();

                Session["Project"]      = project;
                Session["DesiredStart"] = desiredStart;
                Session["PlannedStart"] = plannedStart;
                Session["Resource"]     = resource;
                Session["Comment"]      = comment;
            }


            if (e.CommandName.Equals("Update"))
            {
                GridDataItem item = (GridDataItem)e.Item;

                TextBox txtProject = (e.Item as GridEditableItem)["Project"].FindControl("txtProject") as TextBox;
                Telerik.Web.UI.RadDatePicker DesiredStart = (e.Item as GridEditableItem)["DesiredStart"].FindControl("DesiredStart") as Telerik.Web.UI.RadDatePicker;
                Telerik.Web.UI.RadDatePicker PlannedStart = (e.Item as GridEditableItem)["PlannedStart"].FindControl("PlannedStart") as Telerik.Web.UI.RadDatePicker;
                TextBox txtResource = (e.Item as GridEditableItem)["Resources"].FindControl("txtResource") as TextBox;
                TextBox txtComment  = (e.Item as GridEditableItem)["Comments"].FindControl("txtComment") as TextBox;

                string   project       = txtProject.Text;
                DateTime dDesiredStart = (DateTime)DesiredStart.SelectedDate;
                DateTime dPlannedStart = (DateTime)PlannedStart.SelectedDate;
                string   resource      = txtResource.Text;
                string   comment       = txtComment.Text;
                string   p_message1    = String.Empty;

                objBLL = new MetisBLL();
                objBLL.updateUpComingProject(Convert.ToInt32(item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["pkID"].ToString()), project, Convert.ToDateTime(dDesiredStart), Convert.ToDateTime(dPlannedStart), resource, comment, ddlDepartment.SelectedValue, out p_message1);


                rgUpComingProject.Rebind();
            }


            if (e.CommandName.Equals("Cancel"))
            {
                rgUpComingProject.Rebind();
            }
        }