Esempio n. 1
0
        protected void lbDelete_Click(object sender, EventArgs e)
        {
            dsSPDDataContext data   = new dsSPDDataContext();
            LinkButton       link   = (LinkButton)sender;
            GridViewRow      gv     = (GridViewRow)(link.NamingContainer);
            string           nrp    = gv.Cells[0].Text;
            string           idRole = gv.Cells[2].Text;

            try
            {
                var query = (from r in data.msUsers
                             where r.nrp == nrp && r.roleId.ToString() == idRole
                             select r).FirstOrDefault();
                msUser user = new msUser();
                data.msUsers.DeleteOnSubmit((msUser)query);
                data.SubmitChanges();
                fillGridView(cmbxUser.Value.ToString());
            }
            catch (Exception ex)
            {
                Response.Write("Penghapusan data gagal " + ex.Message);
            }
            finally
            {
                data.Dispose();
            }
        }
Esempio n. 2
0
 protected void txtLogin_TextChanged(object sender, EventArgs e)
 {
     using (var ctx = new dsSPDDataContext())
     {
         if (String.IsNullOrEmpty(txtLogin.Text))
         {
             txtLogin.Text = SetLabelWelcome();
         }
         strLoginID         = txtLogin.Text;
         Session["IDLogin"] = strLoginID;
         classSpd oSPD = new classSpd();
         karyawan            = oSPD.getKaryawan(strLoginID);
         Session["nrpLogin"] = karyawan.nrp;
         dsSPDDataContext data       = new dsSPDDataContext();
         msUser           sekretaris = (from u in data.msUsers
                                        where u.nrp == karyawan.nrp && u.roleId == Konstan.SEKRETARIS
                                        select u).FirstOrDefault();
         if (sekretaris != null)
         {
             Session["sekretaris"] = true;
         }
         else
         {
             Session["sekretaris"] = false;
         }
     }
 }
Esempio n. 3
0
        public msUser fillK()
        {
            msUser cost = new msUser();

            cost.nrp    = txtCostDesc.Text;
            cost.roleId = Convert.ToInt32(cmbCompanyName.SelectedItem.Value);
            cost.status = 1;

            return(cost);
        }
Esempio n. 4
0
        protected void lbDelete_Click(object sender, EventArgs e)
        {
            dsSPDDataContext data   = new dsSPDDataContext();
            LinkButton       link   = (LinkButton)sender;
            GridViewRow      gv     = (GridViewRow)(link.NamingContainer);
            Label            costId = (Label)gv.FindControl("id");
            msUser           cost   = data.msUsers.Where(f => f.id.ToString() == costId.Text).Single();

            data.msUsers.DeleteOnSubmit(cost);
            data.SubmitChanges();
            data.Dispose();
            fillGV();
        }
Esempio n. 5
0
        protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
        {
            bool          authLog = AuthenticateUser(Login1.UserName.Trim(), Login1.Password.Trim());
            List <string> roles   = new List <string>();

            //dsSPDDataContext data = new dsSPDDataContext();
            if (authLog == true)
            {
                Session.Add("UserLog", Login1.UserName.Trim());
                roles.Add("Karyawan");
                msUser user = new msUser();
                //P.O.Box
                Response.Redirect("frmHome.aspx");
            }
        }
Esempio n. 6
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            dsSPDDataContext data = new dsSPDDataContext();
            msUser           user = new msUser();

            user.nrp    = cmbxUser.Value.ToString();
            user.roleId = Convert.ToInt32(cmbxUserRole.Value);
            try
            {
                data.msUsers.InsertOnSubmit(user);
                data.SubmitChanges();
                fillGridView(cmbxUser.Value.ToString());
            }
            catch (Exception ex)
            {
                Response.Write("Gagal dalam memasukkan data " + ex.Message);
            }
            finally
            {
                data.Dispose();
            }
        }
Esempio n. 7
0
        protected void btnSimpan_Click(object sender, EventArgs e)
        {
            dsSPDDataContext dss  = new dsSPDDataContext();
            string           mode = "add";

            mode = hfmode.Value.ToString();
            msUser cst = (from k in dss.msUsers where k.id.ToString().Trim() == hfCostId.Value.Trim() select k).FirstOrDefault();

            if (cst == null)
            {
                msUser cost = new msUser();
                cost = fillK();
                dss.msUsers.InsertOnSubmit(cost);
                dss.SubmitChanges();
                dss.Dispose();
                clear_form();
                notif.Text = "Data berhasil disimpan";
                fillGV();
            }
            else
            {
                //clear_form();

                //if (mode == "add")
                //{
                //    notif.Text = "Simpan gagal : NRP Karyawan Sudah Terdaftar";
                //}
                //else
                //{
                fillEdit(ref cst);
                dss.SubmitChanges();
                dss.Dispose();
                clear_form();
                notif.Text = "Data berhasil disimpan";
                fillGV();
                //}
            }
        }
Esempio n. 8
0
 public void fillEdit(ref msUser cost)
 {
     cost.nrp    = txtCostDesc.Text;
     cost.roleId = Convert.ToInt32(cmbCompanyName.SelectedItem.Value);
     cost.id     = Convert.ToInt32(hfCostId.Value);
 }
Esempio n. 9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                using (var ctx = new dsSPDDataContext())
                {
                    if (!Page.IsPostBack)
                    {
                        //strLoginID = SetLabelWelcome();//production

                        //strLoginID = "benny00002704";
                        //strLoginID = "titin008704";
                        //strLoginID = "siska90000308";
                        //strLoginID = "HP";
                        strLoginID         = ConfigurationManager.AppSettings["DevstrLoginID"].ToString();//development
                        Session["IDLogin"] = strLoginID;
                        classSpd oSPD = new classSpd();
                        karyawan            = oSPD.getKaryawan(strLoginID);
                        Session["nrpLogin"] = karyawan.nrp;

                        if (string.IsNullOrEmpty(karyawan.nrp))
                        {
                            errorLogin += "User (karyawan) tidak ditemukan, session login kosong, silahkan close browser anda, lalu login ulang.";
                        }

                        msUser sekretaris = (from u in ctx.msUsers
                                             where u.nrp == karyawan.nrp && u.roleId == Konstan.SEKRETARIS
                                             select u).FirstOrDefault();
                        if (sekretaris != null)
                        {
                            Session["sekretaris"] = true;
                        }
                        else
                        {
                            Session["sekretaris"] = false;
                        }
                    }
                }

                ////debug
                //txtLogin.Visible = true;
                //if (Page.IsPostBack) txtLogin_TextChanged(null, null);
            }
            catch (Exception)
            {
                // sorry broo saya cuman ngakal2in crash loginnya soalnya minta login ke server laen -_-"
                bool recIt = ApplicationPoolRecycle.RecycleCurrentApplicationPool();
                HttpRuntime.UnloadAppDomain();
                Response.Redirect("~/FormError.aspx?e=Applikasi sedang merefresh, silahkan close browser anda, lalu login ulang.");
            }
            finally
            {
                ////debug only
                //if (Page.IsPostBack)
                //{
                //    Response.Redirect("~/newFormHome.aspx");
                //}

                //production
                if (!string.IsNullOrEmpty(errorLogin))
                {
                    Response.Redirect("~/FormError.aspx?e=" + errorLogin);
                }
                else
                {
                    Response.Redirect("~/newFormHome.aspx");
                }
            }
        }