Exemple #1
0
        public InsertOrUpdateBranchResponse InsertOrUpdateBranch(InsertOrUpdateBranchRequest request, int channelId, int?upperBranchId)
        {
            _context.Configuration.AutoDetectChangesEnabled = false;

            var response = new InsertOrUpdateBranchResponse();

            Logger.Info(_logMsg.Clear().SetPrefixMsg("Insert or Update Branch").Add("BranchCode", request.BranchCode)
                        .Add("BranchName", request.BranchName).Add("ChannelId", channelId).Add("UpperBranchId", upperBranchId).ToInputLogString());

            try
            {
                #region "Comment out"
                //                var result = new InsertOrUpdateBranchResponse();

                ////                var dbBranch = _context.TB_R_BRANCH.Where(x => x.BRANCH_CODE.Trim().ToUpper() == request.BranchCode.Trim().ToUpper()).FirstOrDefault();
                //                TB_R_BRANCH dbBranch;
                ////                if (dbBranch == null)
                //                if (!request.Command)
                //                {
                //                    //add mode
                //                    dbBranch = new TB_R_BRANCH();
                //                    result.IsNewBranch = true;

                //                    //check duplicate code
                //                    var count = _context.TB_R_BRANCH.Count(p => p.BRANCH_CODE == request.BranchCode);
                //                    if (count > 0)
                //                    {
                //                        result.IsSuccess = false;
                //                        result.ErrorCode = "6";
                //                        result.ErrorMessage = string.Format("CSM : รหัสสาขา {0} มีในระบบแล้ว", request.BranchCode);
                //                        return result;
                //                    }

                //                    //check duplicate name
                //                    count = _context.TB_R_BRANCH.Count(p => p.BRANCH_NAME == request.BranchName);
                //                    if (count > 0)
                //                    {
                //                        result.IsSuccess = false;
                //                        result.ErrorCode = "6";
                //                        result.ErrorMessage = string.Format("CSM : {0} มีในระบบ", request.BranchName);
                //                        return result;
                //                    }
                //                }
                //                else
                //                {
                //                    //edit mode
                //                    result.IsNewBranch = false;
                //                    dbBranch = _context.TB_R_BRANCH.FirstOrDefault(x => x.BRANCH_CODE.Trim().ToUpper() == request.BranchCode.Trim().ToUpper());

                //                    #region == Validate Branch Data ==

                //                    if (dbBranch == null)
                //                    {
                //                        //create new branch at slm
                //                        dbBranch = new TB_R_BRANCH();
                //                        result.IsNewBranch = true;
                //                    }
                //                    else
                //                    {
                //                        // IF (Change Branch) Or (Change Status 1 to 0)
                //                        if (dbBranch.STATUS == 1 && request.Status == 0)
                //                        {
                //                            var count = _context.TB_M_POOL_BRANCH.Count(x => x.BRANCH_ID == dbBranch.BRANCH_ID && x.STATUS == 1);

                //                            if (count > 0)
                //                            {
                //                                result.IsSuccess = false;
                //                                result.ErrorCode = "6";
                //                                result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูลเป็นปิดสาขาได้ เนื่องจาก มีการผูกสาขากับ Communication Pool";
                //                                return result;
                //                            }
                //                        }

                //                        //duplicate code and name
                //                        var countDuplicate = _context.TB_R_BRANCH.Count(p => p.BRANCH_NAME == request.BranchName && p.BRANCH_CODE != request.BranchCode);
                //                        if (countDuplicate > 0)
                //                        {
                //                            result.IsSuccess = false;
                //                            result.ErrorCode = "6";
                //                            result.ErrorMessage = string.Format("{0} มีในระบบแล้ว", request.BranchName);
                //                            return result;
                //                        }

                //                        //check recursive upper branch
                //                        if (!CheckRecursiveBranch(dbBranch.BRANCH_CODE, upperBranchId))
                //                        {
                //                            result.IsSuccess = false;
                //                            result.ErrorCode = "6";
                //                            result.ErrorMessage = "CSM : การบันทึกข้อมูลไม่สำเร็จเนื่องจากพบ Recursive Upper Branch";
                //                            return result;
                //                        }
                //                    }
                //                    #endregion
                //                }

                //                dbBranch.CHANNEL_ID = channelId;
                //                dbBranch.BRANCH_CODE = ValueOrDefault(request.BranchCode);
                //                dbBranch.BRANCH_NAME = ValueOrDefault(request.BranchName);
                //                dbBranch.STATUS = Convert.ToInt16(request.Status);
                //                dbBranch.UPPER_BRANCH_ID = upperBranchId;
                //                dbBranch.START_TIME_HOUR = Convert.ToInt16(request.StartTimeHour);
                //                dbBranch.START_TIME_MINUTE = Convert.ToInt16(request.StartTimeMinute);
                //                dbBranch.END_TIME_HOUR = Convert.ToInt16(request.EndTimeHour);
                //                dbBranch.END_TIME_MINUTE = Convert.ToInt16(request.EndTimeMinute);

                //                dbBranch.BRANCH_HOME_NO = ValueOrDefault(request.HomeNo);
                //                dbBranch.BRANCH_MOO = ValueOrDefault(request.Moo);
                //                dbBranch.BRANCH_BUILDING = ValueOrDefault(request.Building);
                //                dbBranch.BRANCH_FLOOR = ValueOrDefault(request.Floor);
                //                dbBranch.BRANCH_SOI = ValueOrDefault(request.Soi);
                //                dbBranch.BRANCH_STREET = ValueOrDefault(request.Street);
                //                dbBranch.BRANCH_PROVINCE = ValueOrDefault(request.Province);
                //                dbBranch.BRANCH_AMPHUR = ValueOrDefault(request.Amphur);
                //                dbBranch.BRANCH_TAMBOL = ValueOrDefault(request.Tambol);
                //                dbBranch.BRANCH_ZIPCODE = ValueOrDefault(request.Zipcode);

                //                var now = DateTime.Now;

                //                if (result.IsNewBranch)
                //                {
                //                    dbBranch.CREATE_USER = ValueOrDefault(request.ActionUsername);
                //                    dbBranch.UPDATE_USER = ValueOrDefault(request.ActionUsername);
                //                    dbBranch.CREATE_DATE = now;
                //                    dbBranch.UPDATE_DATE = now;

                //                    _context.TB_R_BRANCH.Add(dbBranch);
                //                }
                //                else
                //                {
                //                    dbBranch.UPDATE_USER = ValueOrDefault(request.ActionUsername);
                //                    dbBranch.UPDATE_DATE = DateTime.Now;
                //                    SetEntryStateModified(dbBranch);
                //                }

                //                this.Save();

                //                result.IsSuccess = true;
                //                return result;
                #endregion

                string logMsg;
                var    today       = DateTime.Now;
                string branchCode  = request.BranchCode.NullSafeTrim();
                var    dbBranch    = _context.TB_R_BRANCH.FirstOrDefault(x => x.BRANCH_CODE == branchCode);
                bool   isNewBranch = (dbBranch == null);

                if (isNewBranch)
                {
                    dbBranch = new TB_R_BRANCH();
                }
                else
                {
                    // เช็คเงื่อนไขการปิดสาขา
                    if (dbBranch.STATUS == 1 && request.Status == 0)
                    {
                        if (_context.TB_M_POOL_BRANCH.Any(x => x.BRANCH_ID == dbBranch.BRANCH_ID && x.STATUS == Constants.ApplicationStatus.Active))
                        {
                            response.IsSuccess    = false;
                            response.ErrorCode    = "6";
                            response.ErrorMessage = "ไม่สามารถอัพเดตข้อมูลเป็นปิดสาขาได้ เนื่องจาก มีการผูกสาขากับ Communication Pool";
                            return(response);
                        }
                    }

                    // Check recursive upper branch
                    if (!CheckRecursiveBranch(dbBranch.BRANCH_CODE, upperBranchId))
                    {
                        response.IsSuccess    = false;
                        response.ErrorCode    = "6";
                        response.ErrorMessage = "CSM : การบันทึกข้อมูลไม่สำเร็จเนื่องจากพบ Recursive Upper Branch";
                        return(response);
                    }
                }

                dbBranch.CHANNEL_ID        = channelId;
                dbBranch.BRANCH_CODE       = branchCode;
                dbBranch.BRANCH_NAME       = request.BranchName.NullSafeTrim();
                dbBranch.STATUS            = request.Status;
                dbBranch.UPPER_BRANCH_ID   = upperBranchId;
                dbBranch.START_TIME_HOUR   = (short)request.StartTimeHour;
                dbBranch.START_TIME_MINUTE = (short)request.StartTimeMinute;
                dbBranch.END_TIME_HOUR     = (short)request.EndTimeHour;
                dbBranch.END_TIME_MINUTE   = (short)request.EndTimeMinute;

                dbBranch.BRANCH_HOME_NO  = request.HomeNo.NullSafeTrim();
                dbBranch.BRANCH_MOO      = request.Moo.NullSafeTrim();
                dbBranch.BRANCH_BUILDING = request.Building.NullSafeTrim();
                dbBranch.BRANCH_FLOOR    = request.Floor.NullSafeTrim();
                dbBranch.BRANCH_SOI      = request.Soi.NullSafeTrim();
                dbBranch.BRANCH_STREET   = request.Street.NullSafeTrim();
                dbBranch.BRANCH_PROVINCE = request.Province.NullSafeTrim();
                dbBranch.BRANCH_AMPHUR   = request.Amphur.NullSafeTrim();
                dbBranch.BRANCH_TAMBOL   = request.Tambol.NullSafeTrim();
                dbBranch.BRANCH_ZIPCODE  = request.Zipcode.NullSafeTrim();
                dbBranch.UPDATE_USER     = request.ActionUsername.NullSafeTrim();
                dbBranch.UPDATE_DATE     = today;

                if (isNewBranch)
                {
                    logMsg = "Insert Branch";
                    dbBranch.CREATE_USER = request.ActionUsername.NullSafeTrim();
                    dbBranch.CREATE_DATE = today;
                    _context.TB_R_BRANCH.Add(dbBranch);
                }
                else
                {
                    logMsg = "Update Branch";
                    SetEntryStateModified(dbBranch);
                }

                response.IsSuccess = (Save() > 0);

                if (response.IsSuccess)
                {
                    Logger.Info(_logMsg.Clear().SetPrefixMsg(logMsg).ToSuccessLogString());
                }
                else
                {
                    Logger.Info(_logMsg.Clear().SetPrefixMsg(logMsg).Add("Error Message", "Failed to save data").ToFailLogString());
                }

                return(response);
            }
            catch (Exception ex)
            {
                Logger.Error("Exception occur:\n", ex);
                Logger.Info(_logMsg.Clear().SetPrefixMsg("Insert or Update Branch").Add("Error Message", ex.Message).ToFailLogString());

                response = new InsertOrUpdateBranchResponse
                {
                    IsSuccess    = false,
                    ErrorCode    = "1",
                    ErrorMessage = ex.Message,
                };

                return(response);
            }
            finally
            {
                _context.Configuration.AutoDetectChangesEnabled = false;
            }
        }
Exemple #2
0
        public InsertOrUpdateBranchResponse InsertOrUpdateBranch(InsertOrUpdateBranchRequest request, int channelId, int?upperBranchId)
        {
            _context.Configuration.AutoDetectChangesEnabled = false;

            try
            {
                var result = new InsertOrUpdateBranchResponse();

                var dbBranch = _context.TB_R_BRANCH.Where(x => x.BRANCH_CODE.Trim().ToUpper() == request.BranchCode.Trim().ToUpper()).FirstOrDefault();

                if (dbBranch == null)
                {
                    dbBranch           = new TB_R_BRANCH();
                    result.IsNewBranch = true;
                }
                else
                {
                    result.IsNewBranch = false;

                    // IF (Change Branch) Or (Change Status 1 to 0)
                    if (dbBranch.STATUS == 1 && request.Status == 0)
                    {
                        #region == Validate Relation Between Branch to Pool ==

                        var count = _context.TB_M_POOL_BRANCH.Count(x => x.BRANCH_ID == dbBranch.BRANCH_ID && x.STATUS == 1);

                        if (count > 0)
                        {
                            result.IsSuccess    = false;
                            result.ErrorCode    = "6";
                            result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูลเป็นปิดสาขาได้ เนื่องจาก มีการผูกสาขากับ Communication Pool";
                            return(result);
                        }

                        #endregion
                    }
                }

                dbBranch.CHANNEL_ID        = channelId;
                dbBranch.BRANCH_CODE       = ValueOrDefault(request.BranchCode);
                dbBranch.BRANCH_NAME       = ValueOrDefault(request.BranchName);
                dbBranch.STATUS            = Convert.ToInt16(request.Status);
                dbBranch.UPPER_BRANCH_ID   = upperBranchId;
                dbBranch.START_TIME_HOUR   = Convert.ToInt16(request.StartTimeHour);
                dbBranch.START_TIME_MINUTE = Convert.ToInt16(request.StartTimeMinute);
                dbBranch.END_TIME_HOUR     = Convert.ToInt16(request.EndTimeHour);
                dbBranch.END_TIME_MINUTE   = Convert.ToInt16(request.EndTimeMinute);

                dbBranch.BRANCH_HOME_NO  = ValueOrDefault(request.HomeNo);
                dbBranch.BRANCH_MOO      = ValueOrDefault(request.Moo);
                dbBranch.BRANCH_BUILDING = ValueOrDefault(request.Building);
                dbBranch.BRANCH_FLOOR    = ValueOrDefault(request.Floor);
                dbBranch.BRANCH_SOI      = ValueOrDefault(request.Soi);
                dbBranch.BRANCH_STREET   = ValueOrDefault(request.Street);
                dbBranch.BRANCH_PROVINCE = ValueOrDefault(request.Province);
                dbBranch.BRANCH_AMPHUR   = ValueOrDefault(request.Amphur);
                dbBranch.BRANCH_TAMBOL   = ValueOrDefault(request.Tambol);
                dbBranch.BRANCH_ZIPCODE  = ValueOrDefault(request.Zipcode);

                var now = DateTime.Now;

                if (result.IsNewBranch)
                {
                    dbBranch.CREATE_USER = ValueOrDefault(request.ActionUsername);
                    dbBranch.UPDATE_USER = ValueOrDefault(request.ActionUsername);
                    dbBranch.CREATE_DATE = now;
                    dbBranch.UPDATE_DATE = now;

                    _context.TB_R_BRANCH.Add(dbBranch);
                }
                else
                {
                    dbBranch.UPDATE_USER = ValueOrDefault(request.ActionUsername);
                    dbBranch.UPDATE_DATE = DateTime.Now;
                    SetEntryStateModified(dbBranch);
                }

                this.Save();

                result.IsSuccess = true;
                return(result);
            }
            catch (Exception ex)
            {
                Logger.Error("Exception occur:\n", ex);

                return(new InsertOrUpdateBranchResponse()
                {
                    IsSuccess = false,
                    ErrorCode = "1",
                    ErrorMessage = ex.Message,
                });
            }
            finally
            {
                _context.Configuration.AutoDetectChangesEnabled = false;
            }
        }