예제 #1
0
        public Task <target_groupC> GetSingle(int id)
        {
            target_groupC _obj = null;

            using (var _db = fnn.GetDbContext())
            {
                // _db.MapClassToTableName<target_groupC>(_table_name);
                _obj = _db.TARGET_GROUPS.Where(e => e.target_gp_id == id & e.delete_id == 0).FirstOrDefault();
                if (_obj == null)
                {
                    AddErrorMessage("Search Error", "Error", "Unable to Find Record");
                    _obj = null;
                }
                return(Task.FromResult(_obj));
            }
        }
예제 #2
0
        public Task <target_groupC> AddNew(dto_target_group_newC _dto)
        {
            target_groupC _obj = null;

            if (_dto == null)
            {
                AddErrorMessage("Insert Error", "Save Error", "Target Area Object Is Null");
                _obj = null;
                return(Task.FromResult(_obj));
            }
            if (string.IsNullOrEmpty(_dto.target_gp_name))
            {
                AddErrorMessage("Insert Error", "Save Error", "Target Area Name Is Null");
                _obj = null;
                return(Task.FromResult(_obj));
            }
            if (fnn.LOGGED_USER.DoesNotHaveRight(em.right_menu_types.can_create_target_group))
            {
                _obj = null;
                AddErrorMessage("Limited Rights Error", "Limited Rights Error", "You Are Not Authorized To Perform This Operation");
                return(Task.FromResult(_obj));
            }
            #region _image_section

            string _imageUrl = null;

            if (!string.IsNullOrEmpty(_dto.target_gp_image_base_64))
            {
                string _imageFilePath  = string.Empty;
                string _file_extension = string.Empty;
                if (string.IsNullOrEmpty(_dto.image_file_extension))
                {
                    AddErrorMessage("Insert Error", "Save Error", "Image File Extension Cannot Be Empty");
                    _obj = null;
                    return(Task.FromResult(_obj));
                }
                try
                {
                    if (_dto.image_file_extension.IndexOf('.') == -1)
                    {
                        _file_extension = string.Format(".{0}", _dto.image_file_extension);
                    }
                    else
                    {
                        _file_extension = _dto.image_file_extension;
                    }
                    if (!fnn.IsValidImageFileExtension(_file_extension))
                    {
                        AddErrorMessage("Insert Error", "Save Error", "Image File Extension Is Invalid");
                        _obj = null;
                        return(Task.FromResult(_obj));
                    }
                    var _image_bytes = System.Convert.FromBase64String(_dto.target_gp_image_base_64);
                    if (_image_bytes == null || _image_bytes.Length == 0)
                    {
                        throw new Exception("Error Getting Image From Base64 String");
                    }
                    var    rootPath   = HostingEnvironment.MapPath("~/ImageAssets/");
                    string _file_name = string.Format("tg-{0:yyyy-MM-dd_hh-mm-ss-tt}{1}", DateTime.Now, _file_extension);
                    _imageFilePath = Path.Combine(rootPath, Path.GetFileName(_file_name));
                    File.WriteAllBytes(_imageFilePath, _image_bytes);
                    _imageUrl = fnn.CreateImageAssetUrl(_file_name);
                }
                catch (Exception ex)
                {
                    AddErrorMessage("Thrown Execption", "Thrown Exception", ex.Message);
                    _obj = null;
                    return(Task.FromResult(_obj));
                }
            }
            #endregion
            using (var _db = fnn.GetDbContext())
            {
                _obj = new target_groupC();
                _obj.target_gp_name      = _dto.target_gp_name.Trim().ToProperCase();
                _obj.fs_timestamp        = fnn.GetServerDate().ToUnixTimestamp();
                _obj.server_edate        = fnn.GetServerDate();
                _obj.created_by_user_id  = fnn.LOGGED_USER.user_id;
                _obj.target_gp_image_url = _imageUrl;
                _obj.alias = _dto.alias;
                _db.TARGET_GROUPS.Add(_obj);
                var _retVal = _db.SaveChangesWithDuplicateKeyDetected();
                if (_retVal == null || _retVal.Value == true)
                {
                    AddErrorMessage("Duplicate Key Error", "Duplicate Key Error", "You Have Entered A Duplicate Target Group Name");
                    _obj = null;
                }
            }
            if (_obj != null)
            {
                using (var _dbb = fnn.GetDbContext())
                {
                    foreach (var k in Enum.GetValues(typeof(em.resource_typeS)))
                    {
                        var _robj = new voice_resource_categoryC();
                        _robj.created_by_user_id   = fnn.LOGGED_USER.user_id;
                        _robj.fs_timestamp         = fnn.GetServerDate().ToUnixTimestamp();
                        _robj.resource_cat_id      = _obj.target_gp_id;
                        _robj.resource_cat_img_url = _imageUrl;
                        _robj.resource_cat_name    = _obj.target_gp_name.ToProperCase();
                        _robj.resource_type_id     = k.ToInt16();
                        _robj.resource_cat_type_id = em.resource_cat_typeS.target_gp.ToInt32();
                        _robj.fs_timestamp         = fnn.GetServerDate().ToUnixTimestamp();
                        _robj.server_edate         = fnn.GetServerDate();
                        _dbb.VOICE_RESOURCE_CATEGORIES.Add(_robj);
                        _dbb.SaveChanges();
                    }
                }
            }
            return(Task.FromResult(_obj));
        }
예제 #3
0
        public Task <bool> Update(dto_target_group_updateC _dto)
        {
            bool _updated = false;

            if (string.IsNullOrEmpty(_dto.target_gp_name))
            {
                AddErrorMessage("Update Error", "Save Error", "Target Area Name Is Null!");
                return(Task.FromResult(_updated));
            }
            if (fnn.LOGGED_USER.DoesNotHaveRight(em.right_menu_types.can_edit_target_group_info))
            {
                _updated = false;
                AddErrorMessage("Limited Rights Error", "Limited Rights Error", "You Are Not Authorized To Perform This Operation");
                return(Task.FromResult(_updated));
            }
            #region _image_section

            string        _imageUrl = null;
            target_groupC _obj      = null;
            if (!string.IsNullOrEmpty(_dto.target_gp_image_base_64))
            {
                string _imageFilePath  = string.Empty;
                string _file_extension = string.Empty;
                if (string.IsNullOrEmpty(_dto.image_file_extension))
                {
                    AddErrorMessage("Insert Error", "Save Error", "Grantee Image File Extension Cannot Be Empty");
                    return(Task.FromResult(_updated));
                }
                try
                {
                    if (_dto.image_file_extension.IndexOf('.') == -1)
                    {
                        _file_extension = string.Format(".{0}", _dto.image_file_extension);
                    }
                    else
                    {
                        _file_extension = _dto.image_file_extension;
                    }
                    if (!fnn.IsValidImageFileExtension(_file_extension))
                    {
                        AddErrorMessage("Insert Error", "Save Error", "Grantee Image File Extension Is Invalid");
                        return(Task.FromResult(_updated));
                    }
                    var _image_bytes = System.Convert.FromBase64String(_dto.target_gp_image_base_64);
                    if (_image_bytes == null || _image_bytes.Length == 0)
                    {
                        throw new Exception("Error Getting Grantee Image From Base64 String");
                    }
                    var    rootPath   = HostingEnvironment.MapPath("~/ImageAssets/");
                    string _file_name = string.Format("tg-{0:yyyy-MM-dd_hh-mm-ss-tt}{1}", DateTime.Now, _file_extension);
                    _imageFilePath = Path.Combine(rootPath, Path.GetFileName(_file_name));
                    File.WriteAllBytes(_imageFilePath, _image_bytes);
                    _imageUrl = fnn.CreateImageAssetUrl(_file_name);
                }
                catch (Exception ex)
                {
                    AddErrorMessage("Thrown Execption", "Thrown Exception", ex.Message);
                    return(Task.FromResult(_updated));
                }
            }
            #endregion
            using (var _trans = new ZUpdateContext())
            {
                var _existing = _trans.Context.TARGET_GROUPS.Where(e => e.target_gp_id == _dto.target_gp_id & e.delete_id == 0).FirstOrDefault();
                if (_existing == null)
                {
                    _updated = false;
                    AddErrorMessage("Update Error", "Save Error", "Unable To Find Facilitator Object");
                    return(Task.FromResult(_updated));
                }
                _obj = _existing;
                if (_existing.target_gp_name.ToLower() != _dto.target_gp_name.ToLower())
                {
                    var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC
                    {
                        col_to_update = "target_gp_name",
                        new_col_value = _dto.target_gp_name.Trim().ToProperCase(),
                        table_name    = _table_name,
                        pk_col_name   = "target_gp_id",
                        pk_id         = _dto.target_gp_id
                    }, _trans.Context);
                    if (_ret == null || _ret.Value == false)
                    {
                        AddErrorMessage("Error", "Update Error", "Target Area Name Already Exists");
                        _updated = false;
                        return(Task.FromResult(_updated));
                    }
                    else
                    {
                        _updated = true;
                        _trans.Context.SaveChanges();
                    }
                }
                _updated = true;
                if (_updated)
                {
                    List <DbParameter> _para = new List <DbParameter>();
                    _para.Clear();
                    _para.Add(fnn.GetDbParameters("@id", _existing.target_gp_id));
                    _para.Add(fnn.GetDbParameters("@v2", fnn.GetServerDate().ToUnixTimestamp()));
                    _para.Add(fnn.GetDbParameters("@v3", string.IsNullOrEmpty(_dto.alias) ? string.Empty : _dto.alias));
                    _para.Add(fnn.GetDbParameters("@v4", string.IsNullOrEmpty(_imageUrl) ? string.Empty : _imageUrl));
                    //
                    var _sql = string.Format(string.Format("update {0} set fs_timestamp=@v2,alias=@v3,target_gp_image_url=@v4 where target_gp_id = @id and delete_id = 0", _table_name));
                    _trans.Context.Database.ExecuteSqlCommand(_sql, _para.ToArray());
                    _trans.Context.SaveChanges();

                    int _cat_type_id = em.resource_cat_typeS.target_gp.ToInt32();
                    var _r_list      = (from k in _trans.Context.VOICE_RESOURCE_CATEGORIES
                                        where k.resource_cat_type_id == _cat_type_id & k.resource_cat_id == _obj.target_gp_id
                                        & k.delete_id == 0
                                        select k).ToList();
                    foreach (var _v in _r_list)
                    {
                        _para.Clear();
                        _para.Add(fnn.GetDbParameters("@v1", _existing.target_gp_id));
                        _para.Add(fnn.GetDbParameters("@v2", fnn.GetServerDate().ToUnixTimestamp()));
                        _para.Add(fnn.GetDbParameters("@v3", string.IsNullOrEmpty(_imageUrl) ? string.Empty : _imageUrl));
                        _para.Add(fnn.GetDbParameters("@v4", _dto.target_gp_name.Trim().ToProperCase()));
                        _sql = string.Format(string.Format("update {0} set fs_timestamp=@v2,resource_cat_img_url=@v3" +
                                                           ",resource_cat_name=@v4 where un_id = @v1 and delete_id = 0", DbHelper.GetTableSchemaName("voice_resource_cat_tb")));
                        _trans.Context.Database.ExecuteSqlCommand(_sql, _para.ToArray());
                        _trans.Context.SaveChanges();
                    }

                    _trans.Commit();
                }
            }
            return(Task.FromResult(_updated));
        }
예제 #4
0
        public Task <bool> Delete(int id)
        {
            bool _record_deleted = false;

            if (fnn.LOGGED_USER.DoesNotHaveRight(em.right_menu_types.can_delete_target_group))
            {
                AddErrorMessage("Limited Rights Error", "Limited Rights Error", "You Are Not Authorized To Perform This Operation");
                return(Task.FromResult(_record_deleted));
            }
            target_groupC _obj = null;

            using (var _db = fnn.GetDbContext())
            {
                _obj = _db.TARGET_GROUPS.Where(e => e.target_gp_id == id & e.delete_id == 0).SingleOrDefault();
                if (_obj == null)
                {
                    _record_deleted = false;
                    AddErrorMessage("Delete Error", "Delete Error", "Could Not Find Target Area Object");
                }
                else
                {
                    var _has_dependency = DbHelper.HasDbDependencies(_db.Database, new string[] { "target_group_tb" }, DbHelper.GetDbSchema(), new string[] { "target_gp_id" }, id);
                    if (_has_dependency == null || _has_dependency == true)
                    {
                        AddErrorMessage("Delete Error", "Delete Error", "Unable To Delete Record Because It Has System Dependencies.");
                        _record_deleted = false;
                    }
                    else
                    {
                        var _result = DbHelper.DeleteRecordWithDeleteId(new DbHelperDeleteRecordC()
                        {
                            pk_col_name = "target_gp_id",
                            pk_id       = _obj.target_gp_id,
                            table_name  = _table_name
                        }, _db);
                        if (_result == null || _result == false)
                        {
                            AddErrorMessage("Delete Error", "Delete Error", "Error Encountered While Trying To Delete Record");
                            _record_deleted = false;
                        }
                        else
                        {
                            _record_deleted = true;
                            _db.SaveChanges();
                        }
                    }
                }
            }
            if (_record_deleted)
            {
                Task.Factory.StartNew(() =>
                {
                    using (var _dbb = fnn.GetDbContext())
                    {
                        int _cat_type_id = em.resource_cat_typeS.target_gp.ToInt32();
                        var _r_list      = (from k in _dbb.VOICE_RESOURCE_CATEGORIES
                                            where k.resource_cat_type_id == _cat_type_id & k.resource_cat_id == _obj.target_gp_id
                                            & k.delete_id == 0
                                            select k).ToList();
                        foreach (var _v in _r_list)
                        {
                            var _result = DbHelper.DeleteRecordWithDeleteId(new DbHelperDeleteRecordC()
                            {
                                pk_col_name = _v.un_id.ToString(),
                                pk_id       = _v.un_id,
                                table_name  = DbHelper.GetTableSchemaName("voice_resource_cat_tb")
                            }, _dbb);
                            _dbb.SaveChanges();
                        }
                    }
                });
            }
            return(Task.FromResult(_record_deleted));
        }