コード例 #1
0
        public IActionResult RCADAttorneyAdd(RCADAttorneyModel AttorneyDetails)
        {
            int status = 0;

            attorneyService.InsertAttorney(LFKey, AttorneyDetails, out status);
            return(Json(new { success = true }));
        }
コード例 #2
0
        public void InsertAttorney(int ATpKey, RCADAttorneyModel aData, out int status)
        {
            try
            {
                status = -1;

                //Null check for the data
                if (aData == null)
                {
                    return;
                }

                var aParam = new Dapper.DynamicParameters();

                aParam.Add("@ATFirstName", aData.ATFirstName, DbType.String);
                aParam.Add("@ATLastName", aData.ATLastName, DbType.String);
                aParam.Add("@ATFedBar", aData.ATFedBar, DbType.String);
                aParam.Add("@ATStateBar", aData.ATStateBar, DbType.String);
                aParam.Add("@ATInitials ", aData.ATInitials, DbType.String);
                aParam.Add("@ATCompany", aData.ATCompany, DbType.String);
                aParam.Add("@ATAddress1", aData.ATAddress1, DbType.String);
                aParam.Add("@ATAddress2", aData.ATAddress2, DbType.String);
                aParam.Add("@ATCity", aData.ATCity, DbType.String);
                aParam.Add("@ATState", aData.ATState, DbType.String);
                aParam.Add("@ATPostalCode", aData.ATPostalCode, DbType.String);
                aParam.Add("@ATCountry", aData.ATCountry, DbType.String);
                aParam.Add("@ATNote", aData.ATNote, DbType.String);
                aParam.Add("@ATPhone1", aData.ATPhone1, DbType.String);
                aParam.Add("@ATExt1", aData.ATExt1, DbType.String);
                aParam.Add("@ATFax1", aData.ATFax1, DbType.String);
                aParam.Add("@ATMobile1", aData.ATMobile1, DbType.String);
                aParam.Add("@ATEmail1", aData.ATEmail1, DbType.String);
                aParam.Add("@ATPhone2", aData.ATPhone2, DbType.String);
                aParam.Add("@ATFax2", aData.ATFax2, DbType.String);
                aParam.Add("@ATExt2", aData.ATExt2, DbType.String);
                aParam.Add("@ATMobile2", aData.ATMobile2, DbType.String);
                aParam.Add("@ATEmail2", aData.ATEmail2, DbType.String);
                aParam.Add("@ATCreatedBy", ATpKey, DbType.Int16);
                aParam.Add("@CompanyExists", dbType: DbType.Int16, direction: ParameterDirection.Output);

                dataHelper.ExecProcedure(SQLConstants.USP_AddAttorney, out status, aParam);
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #3
0
        public void UpdateAttorneyProfile(RCADAttorneyModel aData, int modifiedBy, int ATpKey)
        {
            try
            {
                int status = 0;
                if (aData == null)
                {
                    return;
                }

                var aParam = new Dapper.DynamicParameters();

                aParam.Add("@ATFirstName", aData.ATFirstName, DbType.String);
                aParam.Add("@ATLastName", aData.ATLastName, DbType.String);
                aParam.Add("@ATFedBar", aData.ATFedBar, DbType.String);
                aParam.Add("@ATStateBar", aData.ATStateBar, DbType.String);
                aParam.Add("@ATInitials ", aData.ATInitials, DbType.String);
                aParam.Add("@ATCompany", aData.ATCompany, DbType.String);
                aParam.Add("@ATAddress1", aData.ATAddress1, DbType.String);
                aParam.Add("@ATAddress2", aData.ATAddress2, DbType.String);
                aParam.Add("@ATCity", aData.ATCity, DbType.String);
                aParam.Add("@ATState", aData.ATState, DbType.String);
                aParam.Add("@ATPostalCode", aData.ATPostalCode, DbType.String);
                aParam.Add("@ATCountry", aData.ATCountry, DbType.String);
                aParam.Add("@ATNote", aData.ATNote, DbType.String);
                aParam.Add("@ATPhone1", aData.ATPhone1, DbType.String);
                aParam.Add("@ATExt1", aData.ATExt1, DbType.String);
                aParam.Add("@ATFax1", aData.ATFax1, DbType.String);
                aParam.Add("@ATContact1", aData.ATContact1, DbType.String);
                aParam.Add("@ATMobile1", aData.ATMobile1, DbType.String);
                aParam.Add("@ATEmail1", aData.ATEmail1, DbType.String);
                aParam.Add("@ATPhone2", aData.ATPhone2, DbType.String);
                aParam.Add("@ATContact2", aData.ATContact2, DbType.String);
                aParam.Add("@ATFax2", aData.ATFax2, DbType.String);
                aParam.Add("@ATExt2", aData.ATExt2, DbType.String);
                aParam.Add("@ATMobile2", aData.ATMobile2, DbType.String);
                aParam.Add("@ATEmail2", aData.ATEmail2, DbType.String);
                aParam.Add("@ATModifiedBy", modifiedBy, DbType.Int16);
                aParam.Add("@ATpKey", ATpKey, DbType.Int16);

                dataHelper.ExecProcedure(SQLConstants.USP_UpdateAttorney, out status, aParam);
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #4
0
 public IActionResult RCADAttorneyEdit(RCADAttorneyModel AttorneyData)
 {
     attorneyService.UpdateAttorneyProfile(AttorneyData, USKey, AttorneyData.ATpKey);
     return(Json(new { success = true }));
 }