public IActionResult RCADAttorneyAdd(RCADAttorneyModel AttorneyDetails) { int status = 0; attorneyService.InsertAttorney(LFKey, AttorneyDetails, out status); return(Json(new { success = true })); }
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; } }
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; } }
public IActionResult RCADAttorneyEdit(RCADAttorneyModel AttorneyData) { attorneyService.UpdateAttorneyProfile(AttorneyData, USKey, AttorneyData.ATpKey); return(Json(new { success = true })); }