public BaseApiResponse DeleteOrderLocation(int PartNo = 0, int OrderNo = 0, int UserAccessID = 0)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("PartNo", (object)PartNo ?? (object)DBNull.Value),
new SqlParameter("FileTypeId", (object)FileType.Request ?? (object)DBNull.Value)
, new SqlParameter("OrderNo", (object)OrderNo ?? (object)DBNull.Value)
, new SqlParameter("UserAccessID", (object)UserAccessID ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("DeleteOrderLocation", param).FirstOrDefault();
if (result == 1)
{
response.Success = true;
}
else
{
response.Success = false;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertOrUpdateOrderWizardStep2(OrderWizardStep2 model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param =
{
new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("BillToOrderingFirm", (object)model.BillToOrderingFirm ?? (object)DBNull.Value)
, new SqlParameter("BillingFirmId", (object)model.BillingFirmId ?? (object)DBNull.Value)
, new SqlParameter("BillingAttorneyId", (object)model.BillingAttorneyId ?? (object)DBNull.Value)
, new SqlParameter("BillingClaimNo", (object)model.BillingClaimNo ?? (object)DBNull.Value)
, new SqlParameter("BillingInsured", (object)model.BillingInsured ?? (object)DBNull.Value)
, new SqlParameter("CreatedBy", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("UserAccessId ", (object)model.UserAccessId ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <long>("InsertOrUpdateOrderWizardStep2", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
response.lng_InsertedId = result;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public GuestResponse(BaseApiResponse <GuestDto> response)
{
Message = response.Message;
Status = response.Status;
Result = response.Result;
Item = response.Item;
}
public async Task Invoke(HttpContext context)
{
try
{
await m_next.Invoke(context);
}
catch (Exception ex)
{
m_logger.LogError(ex, ex.Message);
context.Response.StatusCode = 500;
}
if (!context.Response.HasStarted)
{
context.Response.ContentType = "application/json";
var response = new BaseApiResponse(context.Response.StatusCode);
var json = JsonConvert.SerializeObject(response, new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
});
await context.Response.WriteAsync(json);
}
}
public BaseApiResponse UpdateOrderWizardStep1(OrderWizardStep1 model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param =
{
new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("AttorneyFor", (object)model.AttorneyFor ?? (object)DBNull.Value)
, new SqlParameter("OrderingAttorney", (object)model.OrderingAttorney ?? (object)DBNull.Value)
, new SqlParameter("Represents", (object)model.Represents ?? (object)DBNull.Value)
, new SqlParameter("IsFromClient", (object)model.IsFromClient ?? (object)DBNull.Value)
, new SqlParameter("UpdatedBy", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("UserAccessId", (object)model.UserAccessId ?? (object)DBNull.Value)
, new SqlParameter("OrderingFirmID", (object)model.OrderingFirmID ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <long>("UpdateOrderWizardStep1", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
response.lng_InsertedId = result;
InsertUpdateNotification(model.NotificationEmail, model.OrderingAttorney, response.lng_InsertedId);
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse DeleteState(int stateid)
{
var response = new BaseApiResponse();
try
{
var stateIDParam = new SqlParameter
{
ParameterName = "StateID",
DbType = DbType.Int32,
Value = stateid
};
var result = 0;
result = _repository.ExecuteSQL <int>("usp_mst_StateMaster_delete", stateIDParam).FirstOrDefault();
response.Success = result > 0;
response.InsertedId = result;
}
catch (Exception ex)
{
_logger.Error(ex);
response.Message.Add(ex.Message);
}
return(response);
}
public async Task <IActionResult> Post([FromBody] RegisterRouletteModel model)
{
var result = new BaseApiResponse();
try
{
ValidateModel(model, result);
if (result.Code == (int)HttpStatusCode.BadRequest)
{
return(BadRequest(result));
}
var appResult = await _rouletteAppService.CreateRoulette(new Roulette
{
});
if (appResult.Success)
{
return(Ok(appResult.Data));
}
return(BadRequest(appResult));
}
catch (Exception ex)
{
return(StatusCode(500,
new BaseApiResponse
{
Code = 500, Message = ex.InnerException != null ? ex.InnerException.Message : ex.Message
}));
}
}
public async Task <RegisterResponse> RegisterAsync(RegisterModel registerModel)
{
try
{
var userExists = await _userManager.FindByNameAsync(registerModel.Username);
if (userExists != null)
{
return(new RegisterResponse(BaseApiResponse <UserDto> .CreateErrorResponse($"User already exists!")));
}
var user = new User(registerModel);
var result = await _userManager.CreateAsync(user, registerModel.Password);
if (!result.Succeeded)
{
return(new RegisterResponse(BaseApiResponse <UserDto> .CreateErrorResponse($"User creation failed: {result.Errors.GetErrorsAsString()}")));
}
var userDto = _mapper.Map <UserDto>(user);
return(new RegisterResponse(
BaseApiResponse <UserDto> .CreateSuccessResponse("User created successfully!", userDto)));
}
catch (Exception ex)
{
return(new RegisterResponse(BaseApiResponse <UserDto> .CreateErrorResponse(
$"An error occured during user registration: {ex.Message}")));
}
}
public RegisterResponse(BaseApiResponse <UserDto> response)
{
Message = response.Message;
Status = response.Status;
Result = response.Result;
Item = response.Item;
}
public BaseApiResponse InsertAttorney(AttorneyMasterEntity model, string LoginEmpId, int UserID)
{
var response = new BaseApiResponse();
try
{
string XmlAssistantContact = "";
if (model.AttorneyAssistantContactList != null && model.AttorneyAssistantContactList.Count > 0)
{
XmlAssistantContact = ConvertToXml <AttorneyAssistantContact> .GetXMLString(model.AttorneyAssistantContactList);
}
string xmlData = ConvertToXml <AttorneyMasterEntity> .GetXMLString(new List <AttorneyMasterEntity>() { model });
SqlParameter[] param =
{
new SqlParameter("LoginEmpId", LoginEmpId ?? (object)DBNull.Value),
new SqlParameter("UserID", (object)UserID ?? (object)DBNull.Value),
new SqlParameter("xmlDataString", (object)xmlData ?? (object)DBNull.Value),
new SqlParameter("xmlAssistantContact", (object)XmlAssistantContact ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("InsertAttorney", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public OutfitResponse(BaseApiResponse <TModelDto> response)
{
Message = response.Message;
Status = response.Status;
Result = response.Result;
Item = response.Item;
}
public BaseApiResponse InsertMiscCharges(MiscellaneousChargesEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("MemberID", (object)model.MemberID ?? (object)DBNull.Value)
, new SqlParameter("MiscDesc", (object)model.MiscDesc ?? (object)DBNull.Value)
, new SqlParameter("RegularFee", (object)model.RegularFee ?? (object)DBNull.Value)
, new SqlParameter("DiscountFee", (object)model.DiscountFee ?? (object)DBNull.Value)
, new SqlParameter("CreatedBy", (object)model.CreatedBy ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("InsertMiscCharges", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
}
else
{
response.Success = false;
response.Message.Add("Member and Misc Description already assigned.");
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse UpdateBillToAttorney(int OrderID, string AttyID)
{
var response = new BaseApiResponse();
response.Success = true;
try
{
SqlParameter[] param =
{
new SqlParameter("OrderNo", (object)OrderID ?? (object)DBNull.Value)
, new SqlParameter("AttyID", (object)AttyID ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("UpdateBillToAttorney", param).FirstOrDefault();
if (result == null)
{
result = 0;
response.Success = false;
}
response.Success = true;
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse UpdateBasicOrderIformation(BasicOrderInformation objOrder)
{
var response = new BaseApiResponse();
response.Success = true;
try
{
SqlParameter[] param =
{
new SqlParameter("OrderNo", (object)objOrder.OrderNo ?? (object)DBNull.Value)
, new SqlParameter("PatientName", (object)objOrder.PatientName ?? (object)DBNull.Value)
, new SqlParameter("SSN", (object)objOrder.SSN ?? (object)DBNull.Value)
, new SqlParameter("DateOfBirth", (object)objOrder.DateOfBirth ?? (object)DBNull.Value)
, new SqlParameter("DateOfDeath", (object)objOrder.DateOfDeath ?? (object)DBNull.Value)
, new SqlParameter("DateOfLoss", (object)objOrder.DateOfLoss ?? (object)DBNull.Value)
, new SqlParameter("CompanyNo", (object)objOrder.CompanyNo ?? (object)DBNull.Value)
, new SqlParameter("BillingClaimNo", (object)objOrder.BillingClaimNo ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("UpdateOrderBasicInformation", param).FirstOrDefault();
if (result == null)
{
result = 0;
response.Success = false;
}
response.Success = true;
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse VerifyProposalFees(ProposalFeesEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] saveparam = { new SqlParameter("OrderNo", (object)model.OrderNo ?? (object)DBNull.Value),
new SqlParameter("PartNo", (object)model.PartNo ?? (object)DBNull.Value),
new SqlParameter("Pages", (object)model.Pages ?? (object)DBNull.Value),
new SqlParameter("Amount", (object)Convert.ToDecimal(model.Amount) ?? (object)DBNull.Value),
new SqlParameter("Descr", (object)model.Descr ?? (object)DBNull.Value),
new SqlParameter("EntBy", (object)model.EntBy ?? (object)DBNull.Value),
new SqlParameter("ISRemindEmaiDate", (object)false ?? (object)DBNull.Value), };
var proposalId = _repository.ExecuteSQL <int>("SaveProposalFee", saveparam).FirstOrDefault();
if (proposalId > 0)
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse UpdateEmployee(EmployeeEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("userId", (object)model.UserId ?? (object)DBNull.Value)
, new SqlParameter("email", (object)model.Email ?? (object)DBNull.Value)
, new SqlParameter("firstName", (object)model.FirstName ?? (object)DBNull.Value)
, new SqlParameter("lastName", (object)model.LastName ?? (object)DBNull.Value)
, new SqlParameter("departmentId", (object)model.DepartmentId ?? (object)DBNull.Value)
, new SqlParameter("isLockedOut", (object)model.IsLockedOut ?? (object)DBNull.Value)
//, new SqlParameter("isAdmin", (object)model.IsAdmin ?? (object)DBNull.Value)
//, new SqlParameter("isDocumentAdmin", (object)model.IsDocumentAdmin ?? (object)DBNull.Value)
, new SqlParameter("isApproved", (object)model.IsApproved ?? (object)DBNull.Value)
, new SqlParameter("SelectedRoles", (object)model.SelectedRoles ?? (object)DBNull.Value)
, new SqlParameter("createdBy", (object)model.CreatedBy ?? (object)DBNull.Value)
, new SqlParameter("CompanyNo", (object)model.CompanyNo ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <string>("UpdateEmployee", param).FirstOrDefault();
if (result != string.Empty)
{
response.str_ResponseData = result;
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse DeleteContact(int?ContactId, int?UserId)
{
var response = new BaseApiResponse();
try
{
var ContactIdParam = new SqlParameter
{
ParameterName = "ContactId",
DbType = DbType.Int32,
Value = (object)ContactId ?? DBNull.Value
};
var UserIdParam = new SqlParameter
{
ParameterName = "UserId",
DbType = DbType.Int32,
Value = (object)UserId ?? DBNull.Value
};
var result = _repository.ExecuteSQL <int>("DeleteContact", ContactIdParam, UserIdParam).FirstOrDefault();
response.Success = (result > 0);
}
catch (Exception ex)
{
_logger.Error(ex);
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertEmployee(EmployeeEntity model)
{
var response = new BaseApiResponse();
string RandomPassword = Axiom.Common.CommonHelper.CreateRandomPassword(8);
try
{
SqlParameter[] param = { new SqlParameter("email", (object)model.Email ?? (object)DBNull.Value)
, new SqlParameter("firstName", (object)model.FirstName ?? (object)DBNull.Value)
, new SqlParameter("lastName", (object)model.LastName ?? (object)DBNull.Value)
, new SqlParameter("password", (object)Security.Encrypt(RandomPassword) ?? (object)DBNull.Value)
, new SqlParameter("departmentId", (object)model.DepartmentId ?? (object)DBNull.Value)
, new SqlParameter("isLockedOut", (object)model.IsLockedOut ?? (object)DBNull.Value)
//, new SqlParameter("isAdmin", (object)model.IsAdmin ?? (object)DBNull.Value)
//, new SqlParameter("isDocumentAdmin", (object)model.IsDocumentAdmin ?? (object)DBNull.Value)
, new SqlParameter("isApproved", (object)model.IsApproved ?? (object)DBNull.Value)
, new SqlParameter("SelectedRoles", (object)model.SelectedRoles ?? (object)DBNull.Value)
, new SqlParameter("createdBy", (object)model.CreatedBy ?? (object)DBNull.Value)
, new SqlParameter("CompanyNo", (object)model.CompanyNo ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <string>("InsertEmployee", param).FirstOrDefault();
if (result != string.Empty && result != "-1")
{
CompanyDetailForEmailEntity objCompany = CommonFunction.CompanyDetailForEmail(model.CompanyNo);
System.Text.StringBuilder body = new StringBuilder();
string htmlfilePath = AppDomain.CurrentDomain.BaseDirectory + "/MailTemplate/WelcomeNewUserInternal.html";
using (System.IO.StreamReader reader = new StreamReader((htmlfilePath)))
{
body.Append(reader.ReadToEnd());
}
body = body.Replace("{FirstName}", model.FirstName);
body = body.Replace("{LastName}", model.LastName);
body = body.Replace("{Email}", model.Email);
body = body.Replace("{Password}", RandomPassword);
body = body.Replace("{Link}", objCompany.SiteURL);
body = body.Replace("{LogoURL}", objCompany.Logopath);
body = body.Replace("{ThankYou}", objCompany.ThankYouMessage);
body = body.Replace("{CompanyName}", objCompany.CompName);
body = body.Replace("{Link}", objCompany.SiteURL);
string subject = "Welcome To " + objCompany.CompName;
EmailHelper.Email.Send(
CompanyNo: objCompany.CompNo
, mailTo: model.Email
, body: body.ToString()
, subject: subject
, ccMail: ""
, bccMail: "[email protected],[email protected]");
}
response.str_ResponseData = result;
response.Success = true;
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public async Task <IActionResult> DeleteRoulette([FromQuery] Guid id)
{
var result = new BaseApiResponse();
try
{
var appResult = await _rouletteAppService.DeleteRoulette(id);
if (appResult.Success)
{
return(Ok(appResult));
}
return(BadRequest(appResult));
//return Ok(result);
}
catch (Exception ex)
{
return(StatusCode(500,
new BaseApiResponse
{
Code = 500, Message = ex.InnerException != null ? ex.InnerException.Message : ex.Message
}));
}
}
public BaseApiResponse DeleteDraftOrder(int OrderId)
{
var response = new BaseApiResponse();
try
{
string serverPath = ConfigurationManager.AppSettings["UploadRoot"].ToString();
string subFolder = Convert.ToString(OrderId);
serverPath += subFolder;
if (Directory.Exists(serverPath))
{
Directory.Delete(serverPath, true);
}
SqlParameter[] param = { new SqlParameter("OrderId", (object)OrderId ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("DeleteDraftOrder", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse UpdateCourt(CourtEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("CourtID", (object)model.CourtID ?? (object)DBNull.Value)
, new SqlParameter("CourtType", (object)model.CourtType ?? (object)DBNull.Value)
, new SqlParameter("StateID", (object)model.StateID ?? (object)DBNull.Value)
, new SqlParameter("DistrictID", (object)model.DistrictID ?? (object)DBNull.Value)
, new SqlParameter("CountyID", (object)model.CountyID ?? (object)DBNull.Value)
, new SqlParameter("CourtName", (object)model.CourtName ?? (object)DBNull.Value)
, new SqlParameter("IsActive", (object)model.IsActive ?? (object)DBNull.Value)
, new SqlParameter("UpdatedBy", (object)model.UpdatedBy ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("UpdateCourt", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse DeleteCountry(int countryId)
{
var response = new BaseApiResponse();
try
{
var countryIdParam = new SqlParameter
{
ParameterName = "CountryID",
DbType = DbType.Int32,
Value = countryId
};
var result = _repository.ExecuteSQL <int>("usp_CountryMaster_delete", countryIdParam).FirstOrDefault();
response.Success = result > 0;
response.InsertedId = result;
}
catch (Exception ex)
{
_logger.Error(ex);
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertUpdateNotification(List <NotificationEmailEntity> NotificationEmail, string OrderingAttorney, long?orderId)
{
var response = new BaseApiResponse();
string xmlData = ConvertToXml <NotificationEmailEntity> .GetXMLString(NotificationEmail);
try
{
SqlParameter[] param = { new SqlParameter("xmlData", (object)xmlData ?? (object)DBNull.Value)
, new SqlParameter("OrderingAttorney", (object)OrderingAttorney ?? (object)DBNull.Value)
, new SqlParameter("OrderId", (object)orderId ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <long>("[InsertUpdateNotification]", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
response.lng_InsertedId = result;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse SaveDocument(int UserId, ProcessDocument ProcessDocumentObj)
{
var response = new BaseApiResponse();
try
{
object[] paramList =
{
new SqlParameter("DocumentId", (object)ProcessDocumentObj.DocumentId ?? (object)DBNull.Value)
, new SqlParameter("ProcessId", (object)ProcessDocumentObj.ProcessId ?? (object)DBNull.Value)
, new SqlParameter("SubProcessId", (object)ProcessDocumentObj.SubProcessId ?? (object)DBNull.Value)
, new SqlParameter("RegionId", (object)ProcessDocumentObj.RegionId ?? (object)DBNull.Value)
, new SqlParameter("DocumentCode", (object)ProcessDocumentObj.DocumentCode ?? (object)DBNull.Value)
, new SqlParameter("DocumentTitle", (object)ProcessDocumentObj.DocumentTitle ?? (object)DBNull.Value)
, new SqlParameter("DocumentPath", (object)ProcessDocumentObj.DocumentPath ?? (object)DBNull.Value)
, new SqlParameter("ReleaseDate", (object)ProcessDocumentObj.ReleaseDate ?? (object)DBNull.Value)
, new SqlParameter("IsActive", (object)ProcessDocumentObj.IsActive ?? (object)DBNull.Value)
, new SqlParameter("DisplayOrder", (object)ProcessDocumentObj.DisplayOrder ?? (object)DBNull.Value)
, new SqlParameter("UserId", (object)UserId ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("AddOrUpdateDocument", paramList).FirstOrDefault();
response.Success = (result > 0);
}
catch (Exception ex)
{
_logger.Error(ex);
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertOrderNotes(OrderNoteEntity modal)
{
var response = new BaseApiResponse();
try
{
Guid UserId = new Guid(modal.UserId);
SqlParameter[] param = { new SqlParameter("OrderId", (object)modal.OrderId ?? (object)DBNull.Value)
, new SqlParameter("PartNo", (object)modal.PartNo ?? (object)DBNull.Value)
, new SqlParameter("NotesClient", (object)modal.NotesClient ?? (object)DBNull.Value)
, new SqlParameter("NotesInternal", (object)modal.NotesInternal ?? (object)DBNull.Value)
, new SqlParameter("UserId", (object)UserId ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("InsertOrderNotes", param).FirstOrDefault();
if (result == 1)
{
response.Success = true;
response.InsertedId = result;
}
else
{
response.Success = false;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertFirm(FirmEntity model, string EmpID, string UserID)
{
var response = new BaseApiResponse();
try
{
string xmlData = ConvertToXml <FirmEntity> .GetXMLString(new List <FirmEntity>() { model });
SqlParameter[] param =
{
new SqlParameter("LoginEmpId", (object)EmpID ?? (object)DBNull.Value)
, new SqlParameter("UserID", (object)UserID ?? (object)DBNull.Value)
, new SqlParameter("xmlDataString", (object)xmlData ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("InsertFirm", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse SaveMiscCharges(MiscChargesEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("MiscChrgId", (object)model.MiscChrgId ?? (object)DBNull.Value)
, new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("PartNoStr", (object)model.PartNoStr ?? (object)DBNull.Value)
, new SqlParameter("BillToAttorneyName", (object)model.BillToAttorneyName ?? (object)DBNull.Value)
, new SqlParameter("Descr", (object)model.Descr ?? (object)DBNull.Value)
, new SqlParameter("Units", (object)model.Units ?? (object)DBNull.Value)
, new SqlParameter("RegFee", (object)model.RegFee ?? (object)DBNull.Value)
, new SqlParameter("Amount", (object)model.Amount ?? (object)DBNull.Value)
, new SqlParameter("EmpId", (object)model.EmpId ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("SaveMiscCharges", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
response.InsertedId = result;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertMemberOfID(string FirmID, string CompanyID, string MemberID)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param =
{
new SqlParameter("FirmID", (object)FirmID ?? (object)DBNull.Value),
new SqlParameter("CompanyID", (object)CompanyID ?? (object)DBNull.Value),
new SqlParameter("MemberID", (object)MemberID ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <string>("InsertMemberOfID", param).FirstOrDefault();
if (result != string.Empty)
{
response.str_ResponseData = result;
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse CheckUniqueCounty(CountyEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param =
{
new SqlParameter("countyId", (object)model.CountyId ?? (object)DBNull.Value)
, new SqlParameter("countyName", (object)model.CountyName ?? (object)DBNull.Value)
, new SqlParameter("stateId", (object)model.StateId ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("CheckUniqueCounty", param).FirstOrDefault();
if (result == 0)
{
response.Success = false;
}
else
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse DeleteCanvas(int ID = 0)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("Id", (object)ID ?? (object)DBNull.Value),
new SqlParameter("FileTypeId", (object)FileType.Authorization ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("DeleteCanvas", param).FirstOrDefault();
if (result == 1)
{
response.Success = true;
}
else
{
response.Success = false;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
