예제 #1
0
        public bool SaveDofaPeerData(string action, out string msg, out int empNo, out string empName)
        {
            msg = string.Empty; empNo = 0; empName = string.Empty;
            bool success = false;

            if (DofaPeerData == null || DofaPeerData.Count == 0)
            {
                return(success);
            }

            if (DofaPeerData.Any(n => n.empNo <= 0))
            {
                msg = "Employee Required";
                return(success);
            }

            DataCollectionModelDataContext db = new DataCollectionModelDataContext();
            string empNotExist = string.Empty;

            foreach (var item in DofaPeerData)
            {
                var emp = db.dofaInfos.Where(a => a.empNo == item.empNo).FirstOrDefault();
                if (emp != null)
                {
                    item.empNo         = item.empNo;
                    item.MenuID        = DataAccess.Enum.Menu.DOFAPEER.ToString();
                    item.DeptID        = SessionManager.DeptID;
                    item.DataUser      = SessionManager.UserName;
                    item.DataUpdatedOn = DateTime.Now;
                    item.DataCaptYM    = SessionManager.DataCaptYR;
                    item.DataStatus    = (short)FormCommonMethods.GetStatusByAction(action);
                    item.DataValid     = Convert.ToChar("Y");
                    item.DataLocked    = Convert.ToChar("N");
                    item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
                    item.PeerRemarks   = SessionManager.UserName + " on " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
                    empNo   = emp.empNo;
                    empName = emp.empName;
                }
                else
                {
                    if (string.IsNullOrEmpty(empNotExist))
                    {
                        empNotExist = Convert.ToString(emp.empNo);
                    }
                    else
                    {
                        empNotExist = empNotExist + " ," + emp.empNo;
                    }
                }
            }

            if (!string.IsNullOrEmpty(empNotExist))
            {
                msg = empNotExist + "Employee Not Exist.";
                return(success);
            }

            try
            {
                FormsRepository formsRepository = new FormsRepository();
                DataTable       dt = ToDataTable(DofaPeerData);
                success = formsRepository.UpdateBulkDofaPeerFormData(dt, SessionManager.DataCaptYR, SessionManager.DeptID);
            }
            catch (Exception ex)
            {
            }
            return(success);
        }