public void DeleteSellerBuyerByFirstName(string firstName)
{
var query = $@" SELECT* FROM [AppMember] where FirstName ='{firstName}'
Delete ClosingFileBuyerSellerNotaryBlocks where ClosingFileBuyerSellerId in (Select id from ClosingFileBuyerSellers where AppMemberId in (Select id from [AppMember] where FirstName ='{firstName}'))
Delete ClosingFileBuyerSellers where AppMemberId in (Select id from [AppMember] where FirstName ='{firstName}')
delete EscrowJournals where AppMemberId in (Select id from [AppMember] where FirstName ='{firstName}')
Delete from [AppMember] where FirstName ='{firstName}' ";
AppMembersModel closingNumber = _conn.Connection.Query <AppMembersModel>(query).ToList().FirstOrDefault();
}
public string GetSellerLastName(string name)
{
Thread.Sleep(100);
var query = $@"SELECT [LastName]
FROM [AppMember] where FirstName = '{name}' order by id desc";
AppMembersModel closingNumber = _conn.Connection.QueryFirstOrDefault <AppMembersModel>(query);
return(closingNumber.LastName);
}
public void DeleteBuyerSeller(string companyId, string firstName, int buyerOrSeller)
{
var query = $@" Delete ClosingFileRelationshipBuyerSellers Where ClosingFileBuyerSellerId in(Select id From ClosingFileBuyerSellers Where AppMemberId in(Select id From [AppMember] Where FirstName ='{firstName}' And id in(Select [AppMemberId] From [ClosingFileBuyerSellers] where [BuyerOrSellerType] = {buyerOrSeller})));
Delete ClosingFileBuyerSellerNotaryBlocks Where ClosingFileBuyerSellerId in(Select id From ClosingFileBuyerSellers Where AppMemberId in(Select id From [AppMember] Where FirstName ='{firstName}'And id in(Select [AppMemberId] From [ClosingFileBuyerSellers] where [BuyerOrSellerType] = {buyerOrSeller} )));
Delete EscrowJournals Where AppMemberId in(Select id From [AppMember] Where FirstName ='{firstName}' And id in(Select [AppMemberId] From [ClosingFileBuyerSellers] where [BuyerOrSellerType] = {buyerOrSeller}));
Delete ClosingFileBuyerSellers Where AppMemberId in(Select id From [AppMember] Where FirstName ='{firstName}' And id in(Select [AppMemberId] From [ClosingFileBuyerSellers] where [BuyerOrSellerType] = {buyerOrSeller}));
Delete [AppMember] Where FirstName ='{firstName}' And id in(Select [AppMemberId] From [ClosingFileBuyerSellers] where [BuyerOrSellerType] = {buyerOrSeller})";
AppMembersModel closingNumber = _conn.Connection.Query <AppMembersModel>(query).ToList().FirstOrDefault();
}
public void AddNewAppMember(string fName, string lName)
{
var query = $@"Insert Into [AppMember]
([FirstName],[LastName],[Suffix],[MiddleName],[JobTitle],[PhoneMobile],[PhoneFax]
,[StateLicNumber],[ProfileImage],[SignatureImage],[RoleId],[Status],[ApplicationViewId],[Gender]
,[BuyerType],[InternalMember],[LockoutEnd],[TwoFactorEnabled],[PhoneNumberConfirmed],[PhoneNumber],[ConcurrencyStamp],[SecurityStamp]
,[PasswordHash],[EmailConfirmed],[NormalizedEmail],[Email],[NormalizedUserName],[UserName],[LockoutEnabled],[AccessFailedCount])
Values
('{fName}','{lName}',NULL,NULL,NULL,''
,'' ,'' ,'','',NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,NULL)";
AppMembersModel closingNumber = _conn.Connection.Query <AppMembersModel>(query).ToList().FirstOrDefault();
}
