public JToken GetListSuiteRegistration(string auctionCalenderId, string clientId, string logId)
{
var suiteWrapper = new SuiteWrapper();
suitesessionId = suiteWrapper.Login().GetAwaiter().GetResult();
var request = new SuiteReadEntryListRequest();
request.SessionId = suitesessionId;
request.ModuleName = "reg_Registration";
request.Query = "reg_Registration_cstm.ac1_auction_calendar_id_c='" + auctionCalenderId + "'";
//request.Query = $"reg_Registration_cstm.ac1_auction_calendar_id_c='{auctionCalenderId}' and id in ( SELECT contacts_reg_registration_1reg_registration_idb FROM contacts_reg_registration_1_c where contacts_reg_registration_1contacts_ida = '{clientId}') ";
request.SelectFields = new List <string> {
"id",
};
var registration_list = suiteWrapper.GetList(request).GetAwaiter().GetResult();
foreach (var registratonRecord in registration_list.EntityList)
{
if (CheckForRegistrationAvailalibilityForContact(registratonRecord.SelectToken("id").ToString(), clientId, logId) > 0)
{
return(registratonRecord);
}
}
return(null);
}
public List <EntryListArray> GetSuiteContactIDByEmail(string email, string logId)
{
var wrapper = new SuiteWrapper();
suitesessionId = wrapper.Login().GetAwaiter().GetResult();
var request = new SuiteReadEntryListRequest();
request.SessionId = suitesessionId;
request.ModuleName = "Contacts";
request.Query = " contacts" +
".id in (SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON " +
"(ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address = '" + email + "')";
request.SelectFields = new List <string> {
"Am_customer_id",
"email"
};
try
{
var suiteConstactList = wrapper.GetList(request).GetAwaiter().GetResult();
return(suiteConstactList.EntryList);
}
catch (Exception ex)
{
SuiteWrapper.WriteTraceLog("GetRegistration", "Error : " + ex.Message);
InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Error : " + ex.Message, Name = "GetSuiteConstactIDByEmail", Entity_c = "Customer"
}, logId);
}
return(null);
}
public GetListofSuiteContactResponse GetListSuiteContact(GetListofSuiteContactRequest GetSuiteContactRequest)
{
var suiteWrapper = new SuiteWrapper();
suitesessionId = suiteWrapper.Login().GetAwaiter().GetResult();
var request = new SuiteReadEntryListRequest();
request.SessionId = suitesessionId;
request.ModuleName = "Contacts";
request.SelectFields = new List <string> {
"first_name",
"last_name",
"phone_work",
"title",
"phone_fax",
"description",
};
var contacts_List = suiteWrapper.GetList(request).GetAwaiter().GetResult();
for (var i = 0; i <= contacts_List.EntityList.Count(); i++)
{
var values = new Dictionary <string, string>
{
{ "method", "POST" },
{ "input_type", "JSON" },
{ "response_type", "JSON" },
{ "email_address", "*****@*****.**" },
{ "given_name", "ABC" },
{ "family_name", "Xyz" },
{ "password", "1234567890" },
{ "first_name", contacts_List.EntryList[i].Entity.SelectToken("first_name").ToString() },
{ "last_name", contacts_List.EntryList[i].Entity.SelectToken("last_name").ToString() },
{ "phone_work", contacts_List.EntryList[i].Entity.SelectToken("phone_work").ToString() },
{ "title", contacts_List.EntryList[i].Entity.SelectToken("title").ToString() },
{ "phone_fax", contacts_List.EntryList[i].Entity.SelectToken("phone_fax").ToString() },
{ "description", contacts_List.EntryList[i].Entity.SelectToken("description").ToString() }
};
}
return(null);
}
// Get NetSuite Customer internalID
public SuiteContact GetSuiteConstactID(string auctionCustmoerID, string logId)
{
var suiteContact = new SuiteContact();
var amwrapper = new AMWrapper();
var suiteWrapper = new SuiteWrapper();
var contactrequest = new CreateContactRequest();
suitesessionId = suiteWrapper.Login().GetAwaiter().GetResult();
var request = new SuiteReadEntryListRequest();
request.SessionId = suitesessionId;
request.ModuleName = "Contacts";
request.Query = " am_customer_id_c = '" + auctionCustmoerID + "'";
request.SelectFields = new List <string> {
"id",
"am_customer_id_c",
"name",
"client_number_c"
};
try
{
var suiteConstactlist = suiteWrapper.GetList(request).GetAwaiter().GetResult();
foreach (var record in suiteConstactlist.EntryList)
{
suiteContact.Id = record.Entity.SelectToken("id").ToString();
suiteContact.Name = record.Entity.SelectToken("name").ToString();
suiteContact.Client_number_c = record.Entity.SelectToken("client_number_c").ToString();
return(suiteContact);
}
}
catch (Exception ex)
{
InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Error : " + ex.Message, Name = "CheckForRegistration", Entity_c = "Customer"
}, logId);
SuiteWrapper.WriteTraceLog("CheckForRegistration", "Error Message : " + ex.Message);
}
return(null);
}
public EntryListArray GetListSuiteAuctionCalender(string id, string logId)
{
var amWrapper = new AMWrapper();
var suiteWrapper = new SuiteWrapper();
var contactrequest = new CreateContactRequest();
suitesessionId = suiteWrapper.Login().GetAwaiter().GetResult();
var request = new SuiteReadEntryListRequest();
request.SessionId = suitesessionId;
request.ModuleName = "AC1_Auction_Calendar";
request.Query = "AC1_Auction_Calendar.id='" + id + "'";
request.SelectFields = new List <string> {
"name",
};
var auction_List = suiteWrapper.GetList(request).GetAwaiter().GetResult();
if (auction_List.EntityList == null)
{
return(null);
}
var auction_List_Cnt = auction_List.EntityList.Count();
common.InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Total Auction Calender in Suite: " + auction_List_Cnt, Name = "GetListSuiteAuctionCalender", Entity_c = "Registration"
}, logId);
if (auction_List.EntityList.Count() == 0)
{
return(null);
}
for (var i = 0; i <= auction_List_Cnt; i++)
{
return(auction_List.EntryList[i]);
}
return(null);
}
public PushListofSuiteAuctionResponse PushListofAMAuction(string auctionId, string logId)
{
SuiteWrapper.WriteTraceLog("PushAMAuction", "---------------- AUCTION SYNC START ------------------------- ");
common.InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Push Auction to AM sync started", Name = "PushAuction", Entity_c = "Auction"
}, logId);
var amWrapper = new AMWrapper();
var suiteWrapper = new SuiteWrapper();
var ret = new PushListofSuiteAuctionResponse();
ret.List = new List <AMCustomer.AMAuction>();
try
{
suitesessionId = suiteWrapper.Login().GetAwaiter().GetResult();
var requestAuction = new SuiteReadEntryListRequest();
requestAuction.SessionId = suitesessionId;
requestAuction.ModuleName = "AC1_Auction_Calendar";
requestAuction.Query = $"ac1_auction_calendar_cstm.auction_number_c in ('{string.Join("','", auctionId.Split(','))}')";
requestAuction.SelectFields = new List <string> {
"id",
"name",
"auction_number_c",
"auction_type_c",
"currency_type_c",
"start_date_c",
"invoice_description_c",
"viewing_c",
"city_description_c",
"city_c",
};
var auction_List = suiteWrapper.GetList(requestAuction).GetAwaiter().GetResult();
if (auction_List.Count > 0)
{
foreach (var item in auction_List.EntityList.Children())
{
var itemProperties = item.Children <JProperty>();
var values = new Dictionary <string, string>
{
{ "method", "POST" },
{ "input_type", "JSON" },
{ "response_type", "JSON" },
{ "integration_id", itemProperties.FirstOrDefault(xx => xx.Name == "id").Value.ToString() },
};
if (!string.IsNullOrEmpty(itemProperties.FirstOrDefault(xx => xx.Name == "name").Value.ToString()))
{
values.Add("title", itemProperties.FirstOrDefault(xx => xx.Name == "name").Value.ToString());
}
values.Add("auction_code", itemProperties.FirstOrDefault(xx => xx.Name == "auction_number_c").Value.ToString());
var auction_type_c = GetAuctionType(itemProperties.FirstOrDefault(xx => xx.Name == "auction_type_c").Value.ToString());
values.Add("auction_type", auction_type_c);
var currency_type_c = GetCurrencyCode(itemProperties.FirstOrDefault(xx => xx.Name == "currency_type_c").Value.ToString());
values.Add("currency_code", currency_type_c);
values.Add("location_name", itemProperties.FirstOrDefault(xx => xx.Name == "city_c").Value.ToString());
string start_date_c = Convert.ToDateTime(itemProperties.FirstOrDefault(xx => xx.Name == "start_date_c").Value.ToString()).ToString("yyyy-MM-dd'T'HH:mm'Z'");
values.Add("time_start", start_date_c);
values.Add("description", itemProperties.FirstOrDefault(xx => xx.Name == "invoice_description_c").Value.ToString());
values.Add("viewing_information", itemProperties.FirstOrDefault(xx => xx.Name == "viewing_c").Value.ToString());
values.Add("location_description", itemProperties.FirstOrDefault(xx => xx.Name == "city_description_c").Value.ToString());
var result_Auction = amWrapper.PostDataToAM(values, $"{amWrapper.apiUrl}/v1/auction/").GetAwaiter().GetResult();
var responseData = JObject.Parse(result_Auction).SelectToken("response");
string AMId;
if (responseData != null)
{
AMId = responseData.SelectToken("row_id").ToString();
SuiteWrapper.WriteTraceLog("PushAMAuction", "Auction Inserted to AM successfully for Id :" + AMId);
common.InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Auction Inserted to AM successfully for Id :" + itemProperties.FirstOrDefault(xx => xx.Name == "id").Value.ToString(), Name = "PushAMAuction", Entity_c = "Auction"
}, logId);
ret.StatusCode = ClsConstant.SuccessCode;
ret.Message = ClsConstant.SuccessMessage;
}
else
{
var message = JObject.Parse(result_Auction).SelectToken("error");
AMId = "";
SuiteWrapper.WriteTraceLog("PushAMAuction", "Error Message : " + message);
common.InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Error Message : " + message, Name = "PushAMAuction", Entity_c = "Auction"
}, logId);
ret.StatusCode = ClsConstant.ServerErrorCode;
ret.Message = ClsConstant.ServerErrorMsg;
}
AMCustomer.AMAuction result = new AMCustomer.AMAuction();
result.SuiteId = itemProperties.FirstOrDefault(xx => xx.Name == "id").Value.ToString();
result.Row_id = AMId;
ret.List.Add(result);
}
}
else
{
common.InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "No any Auction exist for period", Name = "PushAMAuction", Entity_c = "Auction"
}, logId);
SuiteWrapper.WriteTraceLog("PushAMAuction", "No any Auction exist for period");
}
}
catch (Exception ex)
{
common.InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Error Message : " + ex.Message, Name = "PushAMAuction", Entity_c = "Auction"
}, logId);
ret.StatusCode = ClsConstant.ServerErrorCode;
ret.Message = ClsConstant.ServerErrorMsg;
return(ret);
}
SuiteWrapper.WriteTraceLog("PushAMAuction", "---------------- AUCTION SYNC END ------------------------- ");
common.InsertSuiteAmIntegrationLogDetail(new CreateTraceLogRequest()
{
Description = "Push Auction to AM sync ended", Name = "PushAMAuction", Entity_c = "Auction"
}, logId);
return(ret);
}
