示例#1
0
        public object[] queryDataManageUserLoginByUserId(USER_LOGIN param)
        {
            log.Info("Start log INFO... queryDataManageUserLoginByUserId");
            MsgForm    msgError = new MsgForm();
            USER_LOGIN form     = new USER_LOGIN();

            try
            {
                using (var db = new PaknampoScaleDBEntities())
                {
                    form = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault();
                    db.Dispose();
                    msgError.statusFlag = MsgForm.STATUS_SUCCESS;
                }
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString(), ex);
                msgError.statusFlag         = MsgForm.STATUS_ERROR;
                msgError.messageDescription = ex.ToString();
            }
            finally
            {
                log.Info("End log INFO... queryDataManageUserLoginByUserId");
            }
            return(new object[] { msgError, form });
        }
        public ActionResult Login(USER_LOGIN model, string returnUrl)
        {
            int LoginCase = 0;

            if (!ModelState.IsValid)
            {
                return(View(model));
            }

            if (LoginBase(model, 1))
            {
                LoginCase = 1;
            }


            switch (LoginCase)
            {
            case 1:     // Complete Redirect
                Session["User"]  = model.WHCODE;
                TempData["User"] = model.WHCODE;
                SetCookie(model.WHCODE, "1");
                return(RedirectToLocal(returnUrl, "1"));

            case 2:     //Lock out
            //return RedirectToAction("updatedid", model);
            default:
                ModelState.AddModelError("", "Invalid login attempt.");
                return(View(model));
            }
        }
示例#3
0
        public object[] deleteDataManageUserLogin(USER_LOGIN param)
        {
            log.Info("Start log INFO... deleteDataManageUserLogin");
            MsgForm    msgError = new MsgForm();
            USER_LOGIN form     = new USER_LOGIN();

            try
            {
                using (var db = new PaknampoScaleDBEntities())
                {
                    form = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault();
                    if (Util.isNotEmpty(form))
                    {
                        db.USER_LOGIN.Remove(form);
                    }
                    db.SaveChanges();
                    msgError.statusFlag = MsgForm.STATUS_SUCCESS;
                }
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString(), ex);
                msgError.statusFlag         = MsgForm.STATUS_ERROR;
                msgError.messageDescription = ex.ToString();
            }
            finally
            {
                log.Info("End log INFO... deleteDataManageUserLogin");
            }
            return(new object[] { msgError });
        }
        public bool LoginBase(USER_LOGIN model, int Position)
        {
            bool OK = false;

            Data_OPDataContext   Context      = new Data_OPDataContext();
            Data_UserDataContext Context_user = new Data_UserDataContext();

            if (Position == 1)
            {
                var queryX = Context.MAS_WHs.Where(x => x.WHCODE == model.WHCODE && x.WHCODE == model.PASSWORD).Count();

                if (queryX > 0)
                {
                    OK = true;
                }
            }
            else
            {
                var queryX = Context_user.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).Count();

                if (queryX > 0)
                {
                    OK = true;
                }
            }

            return(OK);
        }
        private void lnklblogout_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            this.Close();
            USER_LOGIN ul = new USER_LOGIN();

            ul.Show();
        }
示例#6
0
        public void queryDataManageUserLoginByUserId()
        {
            MST007Controller mst007Ctrl = new MST007Controller();

            try
            {
                object[] result = mst007Ctrl.queryDataManageUserLoginByUserId(formUserLogin);

                MsgForm    msgForm = (MsgForm)result[0];
                USER_LOGIN data    = (USER_LOGIN)result[1];

                if (msgForm.statusFlag.Equals(1))
                {
                    if (Util.isNotEmpty(data))
                    {
                        txtUserId.Text        = data.USER_ID;
                        txtUserPassword.Text  = data.USER_PASSWORD;
                        txtUserFirstname.Text = data.USER_FIRSTNAME;
                        txtUserLastname.Text  = data.USER_LASTNAME;
                        //cboStatusFlag.SelectedValue = data.STATUS_FLAG;
                        formUserLogin = data;
                    }
                }
                else
                {
                    MessageBox.Show("Error : " + msgForm.messageDescription);
                }
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString(), ex);
                MessageBox.Show("Error : " + ex.ToString());
            }
        }
示例#7
0
        public object[] checkLogin(USER_LOGIN param)
        {
            log.Info("Start log INFO... checkLogin");
            MsgForm    msgError = new MsgForm();
            USER_LOGIN result   = new USER_LOGIN();

            try
            {
                using (var db = new PaknampoScaleDBEntities())
                {
                    result = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID && row.USER_PASSWORD == param.USER_PASSWORD select row).FirstOrDefault();
                    msgError.statusFlag = MsgForm.STATUS_SUCCESS;
                }
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString(), ex);
                msgError.statusFlag         = MsgForm.STATUS_ERROR;
                msgError.messageDescription = ex.ToString();
            }
            finally
            {
                log.Info("End log INFO... checkLogin");
            }
            return(new object[] { msgError, result });
        }
        private void btncancel_Click(object sender, EventArgs e)
        {
            this.Close();
            USER_LOGIN ul = new USER_LOGIN();

            ul.Show();
        }
        private void btndeactivate_Click(object sender, EventArgs e)
        {
            string s = "delete from customer_info where email='" + uname + "'";

            dataaccess_layer.ProcessQuery(s);
            USER_LOGIN ul = new USER_LOGIN();

            ul.Show();
        }
示例#10
0
        //private void txtUsername_KeyDown(object sender, KeyEventArgs e)
        //{
        //    if (e.KeyCode == Keys.Enter)
        //    {
        //        txtPassword.Focus();
        //    }
        //}

        //private void txtPassword_KeyDown(object sender, KeyEventArgs e)
        //{
        //    if (e.KeyCode == Keys.Enter)
        //    {
        //        txtUsername.Focus();
        //    }
        //}

        public void checkLogin()
        {
            Cursor.Current = Cursors.WaitCursor;
            LoginController loginCtrl = new LoginController();
            USER_LOGIN      form      = new USER_LOGIN();

            try
            {
                if (Util.isEmpty(txtUsername.Text))
                {
                    MessageBox.Show(CommonUtil.REQUIRE_MESSAGE_USER_LOGIN);
                    return;
                }
                if (Util.isEmpty(txtPassword.Text))
                {
                    MessageBox.Show(CommonUtil.REQUIRE_MESSAGE_PASSWORD_LOGIN);
                    return;
                }

                form.USER_ID       = txtUsername.Text;
                form.USER_PASSWORD = txtPassword.Text;

                if (Util.isEmpty(form))
                {
                    MessageBox.Show(CommonUtil.REQUIRE_MESSAGE);
                    return;
                }

                object[] result = loginCtrl.checkLogin(form);

                MsgForm msgForm = (MsgForm)result[0];
                PaknampoScale.src.model.entities.USER_LOGIN data = (src.model.entities.USER_LOGIN)result[1];

                if (msgForm.statusFlag.Equals(1))
                {
                    if (Util.isEmpty(data))
                    {
                        MessageBox.Show(CommonUtil.DATA_NOTFOUND_AGAIN_LOGIN);
                    }
                    else
                    {
                        MenuMain menuMain = new MenuMain();
                        this.Hide();
                        menuMain.Show();
                    }
                }
                else
                {
                    MessageBox.Show("Error : " + msgForm.messageDescription);
                }
            }
            catch (Exception ex)
            {
                Log.Error(ex.ToString(), ex);
            }
        }
        public ActionResult updatedid(USER_LOGIN model)
        {
            Dp_List ul = new Dp_List();
            Data_UserDataContext db = new Data_UserDataContext();

            ul.STCODE  = model.STCODE;
            ul.JT_LIST = new SelectList(db.MAS_DEPs, "DP_ID", "DEPARTMENT");

            return(View(ul));
        }
示例#12
0
        public ActionResult Manage_Partial(int page = 1, string sh = "")
        {
            Detail cc = new Detail();

            cc.STCODE = userOnline;
            cc.sh     = sh;
            //cc.Ticket_ID = Id;

            //var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_OP/api/TicketOP/Ticketlist");
            var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_LE/api/TicketLE/Manage_Partial");

            var request = new RestRequest(Method.POST);

            request.RequestFormat = DataFormat.Json;
            request.AddJsonBody(cc);
            var response = restClient.Execute(request);
            var json     = response.Content;

            JsonDeserializer     deserial = new JsonDeserializer();
            List <ListUserLogin> items    = JsonConvert.DeserializeObject <List <ListUserLogin> >(json);
            var Ans = items.FirstOrDefault();

            // ------------------------------------------------------------------------------------
            Data_UserDataContext DropD = new Data_UserDataContext();
            var dep = (from xx in DropD.MAS_USER_As
                       orderby xx.US_ID
                       select xx).GroupBy(x => x.ANAME).Select(grp => grp.First());

            ViewBag.Dep = new SelectList(dep, "US_ID", "ANAME");

            List <USER_LOGIN> list = new List <USER_LOGIN>();

            if (Ans.Userloginid != null)
            {
                foreach (var dx in Ans.Userloginid)
                {
                    USER_LOGIN ux = new USER_LOGIN();

                    ux.ID       = dx.ID;
                    ux.STCODE   = dx.STCODE;
                    ux.FULLNAME = dx.FULLNAME;
                    ux.DEP      = dx.DEP;
                    ux.A_NAME   = dx.A_NAME;

                    list.Add(ux);
                    //PhoneModels.RowPhone.Add(ipn);
                }
            }
            ViewBag.sh = sh;

            return(PartialView(list.ToPagedList(page, 20)));
        }
示例#13
0
 public void resetDataManageUserLogin()
 {
     txtUserId.Text              = "";
     txtUserPassword.Text        = "";
     txtUserFirstname.Text       = "";
     txtUserLastname.Text        = "";
     cboStatusFlag.SelectedValue = 1;
     formUserLogin     = new USER_LOGIN();
     flagAddEdit       = "A";
     txtUserId.Enabled = true;
     txtUserId.Focus();
     queryDataLoginStatus();
 }
示例#14
0
        // GET: User
        public ActionResult Index()
        {
            USER_LOGIN userLogin = Session["USER_LOGIN"] as USER_LOGIN;

            if (userLogin != null)
            {
                return(Redirect("/home/"));
            }
            else
            {
                return(View());
            }
        }
示例#15
0
        public bool LoginBase(USER_LOGIN model)
        {
            bool OK = false;

            Data_UserDataContext Context = new Data_UserDataContext();

            var queryX = Context.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).Count();

            if (queryX > 0)
            {
                OK = true;
            }

            return(OK);
        }
        private bool checkedepartment(USER_LOGIN model)
        {
            Data_UserDataContext Context = new Data_UserDataContext();

            var queryX = Context.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).FirstOrDefault();

            if (queryX.D_ID == 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
示例#17
0
        public ActionResult Manage_Partial(int page = 1, string sh = "")
        {
            UserViewModels Model = new UserViewModels();

            data_userDataContext DropD = new data_userDataContext();
            var dep = (from xx in DropD.MAS_USER_As
                       orderby xx.US_ID
                       select xx).GroupBy(x => x.ANAME).Select(grp => grp.First());

            ViewBag.Dep = new SelectList(dep, "US_ID", "ANAME");

            sh = sh.Trim();

            List <USER_LOGIN> list = new List <USER_LOGIN>();

            using (data_userDataContext Context = new data_userDataContext())
            {
                IQueryable <VW_USER_FOR_LE> DataUser;
                DataUser = Context.VW_USER_FOR_LEs;

                if (sh.Length > 0)
                {
                    DataUser = DataUser.Where(x => x.STCODE.Contains(sh) || x.NAME.Contains(sh) || x.DPCODE.Contains(sh));
                }

                foreach (var dx in DataUser)
                {
                    USER_LOGIN ux = new USER_LOGIN();

                    ux.ID       = dx.US_ID;
                    ux.STCODE   = dx.STCODE;
                    ux.FULLNAME = dx.NAME;
                    ux.DEP      = dx.DPCODE;
                    ux.A_NAME   = dx.ANAME;

                    list.Add(ux);
                    //PhoneModels.RowPhone.Add(ipn);
                }
                //Model.RowUser = list;
            }

            ViewBag.sh = sh;

            return(PartialView(list.ToPagedList(page, 20)));
        }
示例#18
0
        public ActionResult Login(string username, string password)
        {
            Session.Clear();
            string             PasUserLogin = WiseOffice.clsSecuritys.Encrypt(password, "", true);
            EntitiesConnection dbContext    = new EntitiesConnection();
            USER_LOGIN         userLogin    = dbContext.USER_LOGIN.FirstOrDefault(a => a.COD_USER_LOGIN == username && a.PAS_USER_LOGIN == PasUserLogin);

            if (userLogin != null)
            {
                Session["USER_LOGIN"] = userLogin;
                return(Redirect("/home/"));
            }
            else
            {
                TempData["ErrorMsg"] = "Tài khoản hoặc mật khẩu không đúng !";
                return(Redirect("/user/"));
            }
        }
示例#19
0
        public void deleteDataManageUserLogin()
        {
            MST007Controller mst007Ctrl = new MST007Controller();
            USER_LOGIN       form       = new USER_LOGIN();

            try
            {
                form.USER_ID = txtUserId.Text;

                if (Util.isEmpty(form.USER_ID))
                {
                    MessageBox.Show(CommonUtil.SELECT_DATA_DELETE);
                    return;
                }

                if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    object[] result = mst007Ctrl.deleteDataManageUserLogin(form);

                    MsgForm msgForm = (MsgForm)result[0];

                    if (msgForm.statusFlag.Equals(1))
                    {
                        resetDataManageUserLogin();
                        searchDataManageUserLogin();
                        MessageBox.Show(CommonUtil.DELETE_DATA_SUCCESS);
                    }
                    else
                    {
                        MessageBox.Show("Error : " + msgForm.messageDescription);
                    }
                }
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString(), ex);
                MessageBox.Show("Error : " + ex.ToString());
            }
        }
示例#20
0
        /// <summary>用户指令处理</summary>
        public ASObject Switch(int moduleNumber, int commandNumber, TGGSession session, ASObject data)
        {
#if DEBUG
            var sw = Stopwatch.StartNew();
#endif
            if (commandNumber == (int)UserCommand.USER_SALARY)
            {
                if (!CommonHelper.IsOpen(session.Player.Role.Kind.role_level, (int)OpenModelType.俸禄))
                {
                    return(CommonHelper.ErrorResult(ResultType.BASE_PLAYER_LEVEL_ERROR));
                }
            }
            var aso = new ASObject();
            //指令匹配
            switch (commandNumber)
            {
            case (int)UserCommand.USER_CREATE: { aso = USER_CREATE.GetInstance().CommandStart(session, data); break; }

            case (int)UserCommand.USER_LOGIN: { aso = USER_LOGIN.GetInstance().CommandStart(session, data); break; }

            case (int)UserCommand.CONSUME: { aso = CONSUME.GetInstance().CommandStart(session, data); break; }

            case (int)UserCommand.HEARTBEAT: { aso = HEARTBEAT.GetInstance().CommandStart(session, data); break; }

            case (int)UserCommand.REWARDS: { REWARDS.GetInstance().CommandStart(session, data); break; }

            case (int)UserCommand.USER_SALARY: { aso = USER_SALARY.GetInstance().CommandStart(session, data); break; }

            case (int)UserCommand.USER_MODULE_ACTIVETION: { aso = USER_MODULE_ACTIVETION.GetInstance().CommandStart(session, data); break; }

            case (int)UserCommand.ACTIVITY_OPEN: { aso = ACTIVITY_OPEN.GetInstance().CommandStart(session, data); break; }
            }
#if DEBUG
            sw.Stop();
            XTrace.WriteLine("指令 {1} 运行总耗时:{0} 毫秒", sw.ElapsedMilliseconds.ToString(), GetType().Namespace);
#endif
            return(aso);
        }
示例#21
0
        public void insertOrUpdateDataManageUserLogin()
        {
            MST007Controller mst007Ctrl            = new MST007Controller();
            USER_LOGIN       form                  = new USER_LOGIN();
            LOGIN_STATUS     formUpdateStatusLogin = new LOGIN_STATUS();

            try
            {
                if (Util.isEmpty(txtUserId.Text) ||
                    Util.isEmpty(txtUserPassword.Text) ||
                    Util.isEmpty(cboStatusFlag.SelectedValue))
                {
                    MessageBox.Show(CommonUtil.REQUIRE_MESSAGE);
                    return;
                }

                form.USER_ID        = txtUserId.Text;
                form.USER_PASSWORD  = txtUserPassword.Text;
                form.USER_FIRSTNAME = txtUserFirstname.Text;
                form.USER_LASTNAME  = txtUserLastname.Text;
                //form.STATUS_FLAG = Int32.Parse(cboStatusFlag.SelectedValue.ToString());
                form.STATUS_FLAG = Int32.Parse("1");
                formUpdateStatusLogin.LOGIN_STATUS_VALUE = Int32.Parse(cboStatusFlag.SelectedValue.ToString());

                if (Util.isEmpty(form) && Util.isEmpty(formUpdateStatusLogin.LOGIN_STATUS_VALUE))
                {
                    return;
                }

                object[] result = mst007Ctrl.insertOrUpdateDataManageUserLogin(form, formUpdateStatusLogin, flagAddEdit);

                MsgForm    msgForm = (MsgForm)result[0];
                USER_LOGIN data    = (USER_LOGIN)result[1];

                if (flagAddEdit.Equals("A"))
                {
                    if (Util.isNotEmpty(data))
                    {
                        if (msgForm.statusFlag.Equals(1))
                        {
                            MessageBox.Show(CommonUtil.DUPLICATE_DATA);
                        }
                        else
                        {
                            MessageBox.Show("Error : " + msgForm.messageDescription);
                        }
                    }
                    else
                    {
                        if (msgForm.statusFlag.Equals(1))
                        {
                            resetDataManageUserLogin();
                            searchDataManageUserLogin();
                            MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS);
                        }
                        else
                        {
                            MessageBox.Show("Error : " + msgForm.messageDescription);
                        }
                    }
                }
                else if (flagAddEdit.Equals("E"))
                {
                    if (msgForm.statusFlag.Equals(1))
                    {
                        resetDataManageUserLogin();
                        searchDataManageUserLogin();
                        MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS);
                    }
                    else
                    {
                        MessageBox.Show("Error : " + msgForm.messageDescription);
                    }
                }
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString(), ex);
                MessageBox.Show("Error : " + ex.ToString());
            }
        }
        private void btnsubmit_Click(object sender, EventArgs e)
        {
            try
            {
                int valid1 = 0;
                if (cbgen.Text == "Select Gender" || cbssn.Text == "Select ID proof type")
                {
                    valid = 1;
                }
                if (lblcaptcha.Text != tbcaptcha.Text)
                {
                    MessageBox.Show("Incorrect Captcha");
                    Random        random      = new Random();
                    string        combination = "0123456789ABCDEFGHIJKJLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
                    StringBuilder captcha     = new StringBuilder();
                    for (int i = 0; i < 6; i++)
                    {
                        captcha.Append(combination[random.Next(combination.Length)]);
                    }
                    lblcaptcha.Text = captcha.ToString();
                }
                foreach (Control tb in this.Controls)
                {
                    if (tb is TextBox)
                    {
                        valid1 = bussiness_accesslayer.null_validation(tb.Text);
                        if (valid1 == 1 || valid == 1)
                        {
                            MessageBox.Show("Empty Fields Not Allowed", "Error");
                            break;
                        }
                        if (valid == 2 || valid3 == 2 || valid4 == 2)
                        {
                            MessageBox.Show("Validations Not Satisfied", "Error");
                            break;
                        }
                        else
                        {
                            valid4 = 0;
                        }
                    }
                }


                if (valid == 0 && valid1 == 0 && valid3 == 0 && valid4 == 0 && lblcaptcha.Text == tbcaptcha.Text)
                {
                    string        encrpyt = bussiness_accesslayer.Encrypt(tbpass.Text);
                    SqlDataReader sdr     = null;
                    string        conn    = "Data Source=DESKTOP-OPN87JD\\SQLEXPRESS;Initial Catalog=ExpDB;Integrated Security=True";
                    SqlConnection sc      = null;
                    sc = new SqlConnection(conn);
                    try
                    {
                        sc.Open();
                        SqlCommand cmd = new SqlCommand("Cust_Reg", sc);
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@Cname", tbname.Text);
                        cmd.Parameters.AddWithValue("@DOB", dob.Value.Date.ToShortDateString());
                        cmd.Parameters.AddWithValue("@Address", tbadd.Text);
                        cmd.Parameters.AddWithValue("@Phone", tbphone.Text);
                        cmd.Parameters.AddWithValue("@Email", tbemail.Text);
                        cmd.Parameters.AddWithValue("@Password", encrpyt);
                        cmd.Parameters.AddWithValue("@SSNType", cbssn.Text);
                        cmd.Parameters.AddWithValue("@SSNNumber", tbssn.Text);
                        cmd.Parameters.AddWithValue("@Gender", cbgen.Text);
                        cmd.Parameters.AddWithValue("@Security1", cmbsecurity1.Text);
                        cmd.Parameters.AddWithValue("@Security2", cmbsecurity2.Text);
                        cmd.Parameters.AddWithValue("@Security3", cmbsecurity3.Text);
                        cmd.Parameters.AddWithValue("@Answer1", tbanswer1.Text);
                        cmd.Parameters.AddWithValue("@Answer2", tbanswer2.Text);
                        cmd.Parameters.AddWithValue("@Answer3", tbanswer3.Text);
                        sdr = cmd.ExecuteReader();
                    }
                    catch (Exception ex)
                    {
                        bussiness_accesslayer.LogErrorFile(ex.Message + DateTime.Now.ToLongDateString() + DateTime.Now.ToLongTimeString());
                        MessageBox.Show("Internal Error Occured", "Sorry");
                        this.BeginInvoke(new MethodInvoker(Close));
                    }
                    MessageBox.Show("Registration is Successful", "Congrats");
                    MessageBox.Show("Your Email will be user ID", "Remember");
                    btnclear_Click(btnclear, null);
                    this.Close();
                    USER_LOGIN ul = new USER_LOGIN();
                    ul.Show();
                }
                valid = 0;
            }

            catch (Exception ex)
            {
                bussiness_accesslayer.LogErrorFile(ex.Message + DateTime.Now.ToLongDateString() + DateTime.Now.ToLongTimeString());
                MessageBox.Show("Internal Error Occured", "Sorry");
                this.BeginInvoke(new MethodInvoker(Close));
            }
        }
示例#23
0
        public object[] insertOrUpdateDataManageUserLogin(USER_LOGIN param, LOGIN_STATUS paramStatus, string flagAddEdit)
        {
            log.Info("Start log INFO... insertOrUpdateDataManageUserLogin");
            MsgForm      msgError              = new MsgForm();
            USER_LOGIN   formInsert            = new USER_LOGIN();
            USER_LOGIN   formUpdate            = new USER_LOGIN();
            LOGIN_STATUS formUpdateStatusLogin = new LOGIN_STATUS();

            try
            {
                using (var db = new PaknampoScaleDBEntities())
                {
                    formUpdate            = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault();
                    formUpdateStatusLogin = (from row in db.LOGIN_STATUS where row.LOGIN_STATUS_ID == 1 select row).FirstOrDefault();
                    if (flagAddEdit.Equals("A"))
                    {
                        if (Util.isEmpty(formUpdate))
                        {
                            formInsert.USER_ID        = param.USER_ID;
                            formInsert.USER_PASSWORD  = param.USER_PASSWORD;
                            formInsert.USER_FIRSTNAME = param.USER_FIRSTNAME;
                            formInsert.USER_LASTNAME  = param.USER_LASTNAME;
                            formInsert.STATUS_FLAG    = param.STATUS_FLAG;
                            db.USER_LOGIN.Add(formInsert);
                            log.Info("Insert Data form USER_LOGIN"
                                     + " USER_ID : " + formInsert.USER_ID
                                     + " USER_PASSWORD : "******" USER_FIRSTNAME : " + formInsert.USER_FIRSTNAME
                                     + " USER_LASTNAME : " + formInsert.USER_LASTNAME
                                     + " STATUS_FLAG : " + formInsert.STATUS_FLAG
                                     );
                        }
                    }
                    else if (flagAddEdit.Equals("E"))
                    {
                        if (Util.isNotEmpty(formUpdate))
                        {
                            formUpdate.USER_PASSWORD  = param.USER_PASSWORD;
                            formUpdate.USER_FIRSTNAME = param.USER_FIRSTNAME;
                            formUpdate.USER_LASTNAME  = param.USER_LASTNAME;
                            formUpdate.STATUS_FLAG    = param.STATUS_FLAG;
                            log.Info("Update Data form USER_LOGIN"
                                     + " USER_ID : " + formUpdate.USER_ID
                                     + " USER_PASSWORD : "******" USER_FIRSTNAME : " + formUpdate.USER_FIRSTNAME
                                     + " USER_LASTNAME : " + formUpdate.USER_LASTNAME
                                     + " STATUS_FLAG : " + formUpdate.STATUS_FLAG
                                     );
                        }
                    }
                    formUpdateStatusLogin.LOGIN_STATUS_VALUE = paramStatus.LOGIN_STATUS_VALUE;
                    log.Info("Update Data form LOGIN_STATUS"
                             + " LOGIN_STATUS_ID : " + paramStatus.LOGIN_STATUS_ID
                             + " LOGIN_STATUS_VALUE : " + paramStatus.LOGIN_STATUS_VALUE
                             );
                    db.SaveChanges();
                    msgError.statusFlag = MsgForm.STATUS_SUCCESS;
                }
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString(), ex);
                msgError.statusFlag         = MsgForm.STATUS_ERROR;
                msgError.messageDescription = ex.ToString();
            }
            finally
            {
                log.Info("End log INFO... insertOrUpdateDataManageUserLogin");
            }
            return(new object[] { msgError, formUpdate });
        }