示例#1
0
    protected void btnaddSave_Click(object sender, EventArgs e)
    {
        if (Session["user"] == null || Session["access"] != "ADMIN")
        {
            Response.Redirect("../index.aspx");
        }

        SqlTrainingHistory.InsertParameters["USER_ISN"].DefaultValue          = dropaddUser.SelectedValue;
        SqlTrainingHistory.InsertParameters["TRAINING_CODE_ISN"].DefaultValue = dropaddTraining.SelectedValue;
        SqlTrainingHistory.InsertParameters["TRAINING_DATE"].DefaultValue     = txtaddTrainingDate.Text.Trim();
        SqlTrainingHistory.InsertParameters["TRAINING_TYPE_ISN"].DefaultValue = dropaddTrainingType.SelectedValue;
        SqlTrainingHistory.InsertParameters["NOTE"].DefaultValue = txtAddNote.Text.ToUpper().Trim();
        string UserName    = (string)Session["commonname"];
        string CurrentDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString();

        SqlTrainingHistory.InsertParameters["TRAINING_STATUS_ISN"].DefaultValue = dropaddTrainingStatus.SelectedValue;
        SqlTrainingHistory.InsertParameters["ADDED_BY"].DefaultValue            = UserName.ToUpper().Trim();
        SqlTrainingHistory.InsertParameters["ADDED_DATE"].DefaultValue          = CurrentDate;
        SqlTrainingHistory.InsertParameters["UPDATED_BY"].DefaultValue          = UserName.ToUpper().Trim();
        SqlTrainingHistory.InsertParameters["UPDATED_DATE"].DefaultValue        = CurrentDate;
        try
        {
            SqlTrainingHistory.Insert();
            txtaddTrainingDate.Text    = string.Empty;
            txtAddNote.Text            = string.Empty;
            adderror.Text              = string.Empty;
            dropaddUser.SelectedIndex  = -1;
            dropTraining.SelectedIndex = -1;
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("alert('Training Added Successfully.');");
            sb.Append("$('#addModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AddHideModalScript", sb.ToString(), false);
            gvTrainingHistory.DataBind();
            upTrainingHistory.Update();
        }
        catch
        {
            adderror.Text      = "An error has occurred while adding a training.";
            adderror.ForeColor = System.Drawing.Color.Red;
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#addModal').modal('show');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AddHideModalScript", sb.ToString(), false);
        }
    }
示例#2
0
    protected void btnUpdateTraining_Click(object sender, EventArgs e)
    {
        if (Session["user"] == null || Session["access"] != "ADMIN")
        {
            Response.Redirect("../index.aspx");
        }

        string UserName    = (string)Session["commonname"];
        string CurrentDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString();

        SqlTrainingHistory.UpdateParameters["TRAINING_ISN"].DefaultValue        = trainingisn.Value;
        SqlTrainingHistory.UpdateParameters["USER_ISN"].DefaultValue            = dropUser.SelectedValue;
        SqlTrainingHistory.UpdateParameters["NOTE"].DefaultValue                = txtNote.Text;
        SqlTrainingHistory.UpdateParameters["TRAINING_TYPE_ISN"].DefaultValue   = dropTrainingType.SelectedValue;
        SqlTrainingHistory.UpdateParameters["TRAINING_CODE_ISN"].DefaultValue   = dropTraining.SelectedValue;
        SqlTrainingHistory.UpdateParameters["TRAINING_STATUS_ISN"].DefaultValue = dropTrainingStatus.SelectedValue;
        SqlTrainingHistory.UpdateParameters["TRAINING_DATE"].DefaultValue       = txtTrainingDate.Text.Trim();
        SqlTrainingHistory.UpdateParameters["UPDATED_BY"].DefaultValue          = UserName.ToUpper().Trim();
        SqlTrainingHistory.UpdateParameters["UPDATED_DATE"].DefaultValue        = CurrentDate;

        try
        {
            SqlTrainingHistory.Update();
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("alert('Training Profile Updated Successfully');");
            sb.Append("$('#editModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript", sb.ToString(), false);
            gvTrainingHistory.DataBind();
            upTrainingHistory.Update();
        }
        catch
        {
            editError.Text      = "Error: Record NOT updated.";
            editError.ForeColor = System.Drawing.Color.Red;
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#editModal').modal('show');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AddShowModalScript", sb.ToString(), false);
        }
    }
示例#3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["user"] == null || Session["access"] != "ADMIN")
        {
            Response.Redirect("../index.aspx");
        }


        if (!IsPostBack)
        {
            Session["mainselect"]            = "SELECT TRAININGHISTORY.TRAINING_ISN, TRAININGHISTORY.TRAINING_TYPE_ISN, TRAININGHISTORY.USER_ISN, TRAININGHISTORY.TRAINING_CODE_ISN, TRAININGHISTORY.TRAINING_DATE, TRAININGHISTORY.NOTE, TRAININGHISTORY.ADDED_BY, TRAININGHISTORY.ADDED_DATE, TRAININGHISTORY.UPDATED_BY, TRAININGHISTORY.UPDATED_DATE, USERPROFILE.LAST_NAME + ', ' + USERPROFILE.FIRST_NAME AS NAME, CODE.CODE_DESCRIPTION, CODE.CODE_ID, TRAININGSTATUS.CODE_DESCRIPTION AS TRAINING_STATUS, TRAININGSTATUS.CODE_ID AS STATUS, TRAININGHISTORY.TRAINING_STATUS_ISN, TRAININGTYPE.CODE_ID AS TRAININGTYPE, TRAININGTYPE.CODE_DESCRIPTION AS TRAININGTYPEDESCRIPTION FROM TRAININGHISTORY INNER JOIN USERPROFILE ON TRAININGHISTORY.USER_ISN = USERPROFILE.USER_ISN INNER JOIN CODE AS TRAININGTYPE ON TRAININGTYPE.CODE_ISN = TRAININGHISTORY.TRAINING_TYPE_ISN INNER JOIN CODE ON CODE.CODE_ISN = TRAININGHISTORY.TRAINING_CODE_ISN LEFT OUTER JOIN CODE AS TRAININGSTATUS ON TRAININGHISTORY.TRAINING_STATUS_ISN = TRAININGSTATUS.CODE_ISN ORDER BY USERPROFILE.LAST_NAME, TRAININGHISTORY.TRAINING_DATE DESC";
            SqlTrainingHistory.SelectCommand = (string)Session["mainselect"];
            SqlTrainingHistory.DataBind();
        }

        if (IsPostBack)
        {
            SqlTrainingHistory.SelectCommand = (string)Session["mainselect"];
            SqlTrainingHistory.DataBind();
        }
    }