public ReturnResult <BranchContact> AddNewBranchContact(BranchContact BranchContact)
{
var result = new ReturnResult <BranchContact>();
DbProvider db = new DbProvider();
string outCode = String.Empty;
string outMessage = String.Empty;
string totalRecords = String.Empty;
try
{
// Set tên stored procedure
db.SetQuery("BranchContact_AddNew", CommandType.StoredProcedure)
.SetParameter("BranchContactCode", SqlDbType.NVarChar, BranchContact.BranchContactCode)
.SetParameter("BranchContactName", SqlDbType.NVarChar, BranchContact.BranchContactName)
.SetParameter("ContactName", SqlDbType.NVarChar, BranchContact.ContactName)
.SetParameter("Email", SqlDbType.NVarChar, BranchContact.Email)
.SetParameter("Hotline", SqlDbType.NVarChar, BranchContact.Hotline)
.SetParameter("IPPhone", SqlDbType.NVarChar, BranchContact.IPPhone)
.SetParameter("OperateStatus", SqlDbType.Int, BranchContact.OperateStatus)
.SetParameter("InsertedId", SqlDbType.Int, 1)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output)
.ExcuteNonQuery()
.Complete();
db.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
if (outCode != "0" || outCode == "")
{
result.Failed(outCode, outMessage);
}
else
{
result.Item = BranchContact;
result.ErrorCode = "0";
result.ErrorMessage = "";
}
}
catch (Exception ex)
{
result.Failed("-1", ex.Message);
}
return(result);
}
public ReturnResult <BranchContact> UpdateBranchContact(BranchContact BranchContact)
{
ReturnResult <BranchContact> result = new ReturnResult <BranchContact>();;
DbProvider db;
try
{
db = new DbProvider();
db.SetQuery("BranchContact_Update", CommandType.StoredProcedure);
db.SetParameter("BranchContactId", SqlDbType.Int, BranchContact.BranchContactId);
db.SetParameter("BranchContactCode", SqlDbType.NVarChar, BranchContact.BranchContactCode);
db.SetParameter("BranchContactName", SqlDbType.NVarChar, BranchContact.BranchContactName);
db.SetParameter("ContactName", SqlDbType.NVarChar, BranchContact.ContactName);
db.SetParameter("Email", SqlDbType.NVarChar, BranchContact.Email);
db.SetParameter("Hotline", SqlDbType.NVarChar, BranchContact.Hotline);
db.SetParameter("IPPhone", SqlDbType.NVarChar, BranchContact.IPPhone);
db.SetParameter("OperateStatus", SqlDbType.Int, BranchContact.OperateStatus);
db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output);
db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output);
db.ExcuteNonQuery();
db.Complete();
db.GetOutValue("ErrorCode", out string errorCode);
db.GetOutValue("ErrorMessage", out string errorMessage);
if (errorCode.ToString() == "0")
{
result.ErrorCode = "0";
result.ErrorMessage = "";
}
else
{
result.Failed(errorCode, errorMessage);
}
}
catch (Exception ex)
{
result.Failed("-1", ex.Message);
}
return(result);
}
public ReturnResult <BranchContact> GetBranchContactById(int id)
{
DbProvider provider = new DbProvider();
var result = new ReturnResult <BranchContact>();
string outCode = String.Empty;
string outMessage = String.Empty;
string totalRecords = String.Empty;
BranchContact item = new BranchContact();
try
{
provider.SetQuery("BranchContact_GetById", CommandType.StoredProcedure)
.SetParameter("@BranchContactId", SqlDbType.Int, id, ParameterDirection.Input)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output)
.GetSingle <BranchContact>(out item).Complete();
provider.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
if (outCode != "0" || outCode == "")
{
result.ErrorCode = outCode;
result.ErrorMessage = outMessage;
}
else
{
result.Item = item;
result.ErrorCode = outCode;
result.ErrorMessage = outMessage;
}
}
catch (Exception ex)
{
result.Failed("-1", ex.Message);
}
return(result);
}
public ReturnResult <BranchContact> DeleteBranchContact(int id)
{
DbProvider provider = new DbProvider();
var result = new ReturnResult <BranchContact>();
string outCode = String.Empty;
string outMessage = String.Empty;
string totalRecords = String.Empty;
BranchContact item = new BranchContact();
try
{
provider.SetQuery("BranchContact_Delete", CommandType.StoredProcedure)
.SetParameter("BranchContactId", SqlDbType.Int, id, System.Data.ParameterDirection.Input)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, System.Data.ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, System.Data.ParameterDirection.Output)
.ExcuteNonQuery().Complete();
provider.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
if (outCode != "0")
{
result.Failed(outCode, outMessage);
}
else
{
result.ErrorCode = "0";
result.ErrorMessage = "";
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public async Task <ActionResultResponse> Insert(string tenantId, BranchContactMeta branchContactMeta)
{
if (!EnumerableExtensions.Any(branchContactMeta.BranchContactTranslations))
{
return(new ActionResultResponse(-1, _sharedResourceService.GetString("Please enter at least one language.")));
}
var branchContactId = Guid.NewGuid().ToString();
var branchContact = new BranchContact
{
Id = branchContactId,
CreateTime = DateTime.Now,
ConcurrencyStamp = Guid.NewGuid().ToString(),
TenantId = tenantId,
WorkTime = branchContactMeta.WorkTime,
Link = branchContactMeta.Link,
Website = branchContactMeta.Website,
Logo = branchContactMeta.Logo,
IsOffice = branchContactMeta.IsOffice
};
var result = await _branchContactRepository.Insert(branchContact);
if (result <= 0)
{
return(new ActionResultResponse(result, _sharedResourceService.GetString("Something went wrong. Please contact with administrator.")));
}
var branchContactTranslations = new List <BranchContactTranslation>();
foreach (var branchContactTranslation in branchContactMeta.BranchContactTranslations)
{
branchContactTranslations.Add(new BranchContactTranslation
{
TenantId = branchContact.TenantId,
BranchContactId = branchContact.Id,
LanguageId = branchContactTranslation.LanguageId,
Name = branchContactTranslation.Name,
UnsignName = branchContactTranslation.Name.Trim().StripVietnameseChars().ToUpper(),
Address = branchContactTranslation.Address,
});
}
var resultInsertTranslations = await _branchContactTranslationRepository.Inserts(branchContactTranslations);
if (resultInsertTranslations < 0)
{
await RollbackInsert(branchContact.Id);
return(new ActionResultResponse(result, _resourceService.GetString("Something went wrong. Please contact with administrator.")));
}
if (branchContactMeta.BranchContactDetails.Any() && branchContactMeta.BranchContactDetails.Count > 0)
{
var branchContactDetails = new List <BranchContactDetail>();
foreach (var branchContactDetail in branchContactMeta.BranchContactDetails)
{
branchContactDetails.Add(new BranchContactDetail
{
Id = Guid.NewGuid().ToString(),
BranchContactId = branchContact.Id,
ContactType = branchContactDetail.ContactType,
ContactValue = branchContactDetail.ContactValue,
});
}
var resultInsertDetailContact = await _branchContactDetailRepository.Inserts(branchContactDetails);
if (resultInsertDetailContact < 0)
{
await RollbackInsert(branchContact.Id);
return(new ActionResultResponse(-5, _resourceService.GetString("Can not insert new BranchContact. Please contact with administrator.")));
}
}
return(new ActionResultResponse(resultInsertTranslations, _resourceService.GetString("Add new BranchContact successful.")));
}
public ReturnResult <BranchContact> UpdateBranchContact(BranchContact BranchContact)
{
return(_branchContactDAL.UpdateBranchContact(BranchContact));
}
public ReturnResult <BranchContact> AddNewBranchContact(BranchContact BranchContact)
{
return(_branchContactDAL.AddNewBranchContact(BranchContact));
}
public IActionResult UpdateBranchContact(BranchContact BranchContact)
{
return(Ok(_BranchContactBUS.UpdateBranchContact(BranchContact)));
}
public IActionResult AddNewBranchContact([FromBody] BranchContact BranchContact)
{
return(Ok(_BranchContactBUS.AddNewBranchContact(BranchContact)));
}
public async Task <int> Update(string id, BranchContact branchContact)
{
return(await Context.SaveChangesAsync());
}
public async Task <int> Insert(BranchContact branchContact)
{
_branchContactRepository.Create(branchContact);
return(await Context.SaveChangesAsync());
}
