private static SignatoryModel CreatedNewSignator(ContextModel contextModel)
{
var signator = new SignatoryModel
{
Id = Guid.NewGuid(),
ParticipantId = contextModel.Signator,
ContextId = contextModel.Id,
BenChainContractId = "",
Status = 0,
Modified = DateTime.Now,
OrderId = 0,
BenChainABI = "",
BenChainBytescode = "",
};
return(signator);
}
/// <summary>
///
/// </summary>
/// <param name="signatoryModel"></param>
/// <returns></returns>
public async Task <SignatoryModel> BenChainUpdate(SignatoryModel signatoryModel)
{
if (signatoryModel.ContextId == Guid.Empty)
{
return(signatoryModel);
}
var signatoryDb = await _signatorRepository.FindBy(s => s.ContextId == signatoryModel.ContextId).ConfigureAwait(false);
if (signatoryDb == null)
{
return(signatoryModel);
}
signatoryDb.BenChainContractId = signatoryModel.BenChainContractId;
signatoryDb.BenChainABI = signatoryModel.BenChainABI;
signatoryDb.BenChainBytescode = signatoryModel.BenChainBytescode;
_signatorRepository.Update(signatoryDb);
_signatorRepository.Save(true, false, signatoryModel.Id);
return(signatoryModel);
}
/// <summary>
///
/// </summary>
/// <param name="signatoryModel"></param>
/// <returns></returns>
public async Task <SignatoryModel> CreateOrUpdate(SignatoryModel signatoryModel)
{
if (signatoryModel.Id == Guid.Empty)
{
signatoryModel.Id = Guid.NewGuid();
}
var signatoryDb = await _signatorRepository.FindBy(s => s.Id == signatoryModel.Id).ConfigureAwait(false);
if (signatoryDb == null)
{
var signatory = AutoMapper.Mapper.Map <Signatory>(signatoryModel);
_signatorRepository.Create(signatory);
_signatorRepository.Save(true, false, signatoryModel.Id);
}
else
{
AutoMapper.Mapper.Map(signatoryModel, signatoryDb);
_signatorRepository.Update(signatoryDb);
_signatorRepository.Save(true, false, signatoryModel.Id);
}
return(signatoryModel);
}
public ActionResult GetSignatoryDTable()
{
SignatoryModel model = new SignatoryModel();
List <SignatoryList> getSignatoryList = new List <SignatoryList>();
var SQLQuery = "SELECT [SignatoryID], [SignatoryName], [PreferredName], [Division], Tbl_FMPosition.PositionTitle, [Tbl_FMRes_Department].DeptTitle, [Tbl_FMRes_Function].[FunctionTitle], [isHead], [isActive] FROM [Tbl_FMSignatory], [Tbl_FMRes_Function], [Tbl_FMPosition], [Tbl_FMRes_Department] where[Tbl_FMRes_Department].DeptID = [Tbl_FMRes_Function].DeptID and[Tbl_FMSignatory].FunctionID = [Tbl_FMRes_Function].FunctionID and [Tbl_FMSignatory].PositionID = [Tbl_FMPosition].PositionID";
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_Signatory]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
getSignatoryList.Add(new SignatoryList()
{
SignatoryID = GlobalFunction.ReturnEmptyInt(dr[0]),
SignatoryName = GlobalFunction.ReturnEmptyString(dr[1]),
PreferredName = GlobalFunction.ReturnEmptyString(dr[2]),
PositionTitle = GlobalFunction.ReturnEmptyString(dr[4]),
DeptTitle = GlobalFunction.ReturnEmptyString(dr[5]),
isHead = GlobalFunction.ReturnEmptyBool(dr[7]),
FunctionTitle = GlobalFunction.ReturnEmptyString(dr[6]),
Division = GlobalFunction.ReturnEmptyString(dr[3]),
isActive = GlobalFunction.ReturnEmptyBool(dr[8])
});
}
}
Connection.Close();
}
model.getSignatoryList = getSignatoryList.ToList();
return(PartialView("_TableFileMaintenanceSignatory", model.getSignatoryList));
}
public ActionResult GetSignatoryForm(int ActionID, int PrimaryID)
{
SignatoryModel model = new SignatoryModel();
if (ActionID == 2)
{
var signatory = (from a in BOSSDB.Tbl_FMSignatory where a.SignatoryID == PrimaryID select a).FirstOrDefault();
model.SignatoryList.SignatoryName = signatory.SignatoryName;
model.SignatoryList.PreferredName = signatory.PreferredName;
model.SignatoryList.isHead = Convert.ToBoolean(signatory.isHead);
model.PositionID = Convert.ToInt32(signatory.PositionID);
model.DeptID = Convert.ToInt32(signatory.Tbl_FMRes_Function.DeptID);
model.SignatoryList.Division = signatory.Division;
model.FunctionID = Convert.ToInt32(signatory.FunctionID);
model.SignatoryList.isActive = Convert.ToBoolean(signatory.isActive);
model.SignatoryList.SignatoryID = signatory.SignatoryID;
var functionCount = (from a in BOSSDB.Tbl_FMRes_Function orderby a.FunctionTitle where a.DeptID == model.DeptID select a).ToList();
if (functionCount.Count > 0)
{
model.FunctionList = new SelectList(functionCount, "FunctionID", "FunctionTitle");
}
}
else
{
var deptTbl = (from a in BOSSDB.Tbl_FMRes_Department orderby a.DeptTitle select a.DeptID).FirstOrDefault();
var functionCount = (from a in BOSSDB.Tbl_FMRes_Function orderby a.FunctionTitle where a.DeptID == deptTbl select a).ToList();
if (functionCount.Count > 0)
{
model.FunctionList = new SelectList(functionCount, "FunctionID", "FunctionTitle");
}
}
model.FunctionList = (from li in model.FunctionList orderby li.Text select li).ToList();
model.ActionID = ActionID;
return(PartialView("_SignatoryForm", model));
}
public async Task <IHttpActionResult> BenChainUpdate(SignatoryModel signatoryModel)
{
var context = await _signatorServices.BenChainUpdate(signatoryModel);
return(Ok(context));
}
public async Task <IHttpActionResult> CreatedOrUpdate(SignatoryModel participantModel)
{
var context = await _signatorServices.CreateOrUpdate(participantModel);
return(Ok(context));
}
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='signatoryModel'>
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <SignatoryModel> BenChainUpdateAsync(this ISignator operations, SignatoryModel signatoryModel, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.BenChainUpdateWithHttpMessagesAsync(signatoryModel, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='signatoryModel'>
/// </param>
public static SignatoryModel BenChainUpdate(this ISignator operations, SignatoryModel signatoryModel)
{
return(Task.Factory.StartNew(s => ((ISignator)s).BenChainUpdateAsync(signatoryModel), operations, CancellationToken.None, TaskCreationOptions.None, TaskScheduler.Default).Unwrap().GetAwaiter().GetResult());
}
public ActionResult FileSignatory()
{
SignatoryModel model = new SignatoryModel();
return(View(model));
}
public ActionResult SaveSignatory(SignatoryModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var SigName = model.SignatoryList.SignatoryName;
SigName = Regex.Replace(SigName, @"\s\s+", "");
SigName = Regex.Replace(SigName, @"^\s+", "");
SigName = Regex.Replace(SigName, @"\s+$", "");
SigName = new CultureInfo("en-US").TextInfo.ToTitleCase(SigName);
Tbl_FMSignatory checkSig = (from a in BOSSDB.Tbl_FMSignatory where (a.SignatoryName == SigName) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkSig == null)
{
Tbl_FMSignatory signatori = new Tbl_FMSignatory();
signatori.SignatoryName = SigName;
signatori.PreferredName = model.SignatoryList.PreferredName;
signatori.PositionID = model.PositionID;
signatori.FunctionID = model.FunctionID;
signatori.Division = model.SignatoryList.Division;
signatori.isHead = model.SignatoryList.isHead;
signatori.isActive = model.SignatoryList.isActive;
BOSSDB.Tbl_FMSignatory.Add(signatori);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkSig != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMSignatory signa = (from a in BOSSDB.Tbl_FMSignatory where a.SignatoryID == model.SignatoryList.SignatoryID select a).FirstOrDefault();
List <Tbl_FMSignatory> signatoriiName = (from e in BOSSDB.Tbl_FMSignatory where e.SignatoryName == SigName select e).ToList();
List <Tbl_FMSignatory> signatoriiPref = (from e in BOSSDB.Tbl_FMSignatory where e.PreferredName == model.SignatoryList.PreferredName select e).ToList();
if (checkSig != null)
{
if (signa.SignatoryName == SigName && signa.PreferredName == model.SignatoryList.PreferredName && signa.PositionID == model.PositionID)
{
isExist = "justUpdate";
}
else
{
if (signa.SignatoryName != SigName && signatoriiName.Count >= 1 || signa.PreferredName != SigName && signatoriiPref.Count >= 1)
{
isExist = "true";
}
else
{
isExist = "justUpdate";
}
}
}
else if (checkSig == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
signa.SignatoryName = SigName;
signa.PreferredName = model.SignatoryList.PreferredName;
signa.PositionID = model.PositionID;
signa.FunctionID = model.FunctionID;
signa.Division = model.SignatoryList.Division;
signa.isHead = model.SignatoryList.isHead;
signa.isActive = model.SignatoryList.isActive;
BOSSDB.Entry(signa);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
public ActionResult onChangeSignatory(SignatoryModel model, int DeptID)
{
var FunctionClass = (from a in BOSSDB.Tbl_FMRes_Function where a.DeptID == DeptID select a).ToList();
return(Json(new SelectList(FunctionClass, "FunctionID", "FunctionTitle"), JsonRequestBehavior.AllowGet));
}
public Task <IHttpActionResult> BenChainUpdateTest([PexAssumeUnderTest] SignatorController target, SignatoryModel participantModel)
{
Task <IHttpActionResult> result = target.BenChainUpdate(participantModel);
return(result);
}
/// <param name='signatoryModel'>
/// </param>
/// <param name='customHeaders'>
/// Headers that will be added to request.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
/// <return>
/// A response object containing the response body and response headers.
/// </return>
public async Task <HttpOperationResponse <SignatoryModel> > BenChainUpdateWithHttpMessagesAsync(SignatoryModel signatoryModel, Dictionary <string, List <string> > customHeaders = null, CancellationToken cancellationToken = default(CancellationToken))
{
if (signatoryModel == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "signatoryModel");
}
// Tracing
bool _shouldTrace = ServiceClientTracing.IsEnabled;
string _invocationId = null;
if (_shouldTrace)
{
_invocationId = ServiceClientTracing.NextInvocationId.ToString();
Dictionary <string, object> tracingParameters = new Dictionary <string, object>();
tracingParameters.Add("signatoryModel", signatoryModel);
tracingParameters.Add("cancellationToken", cancellationToken);
ServiceClientTracing.Enter(_invocationId, this, "BenChainUpdate", tracingParameters);
}
// Construct URL
var _baseUrl = this.Client.BaseUri.AbsoluteUri;
var _url = new Uri(new Uri(_baseUrl + (_baseUrl.EndsWith("/") ? "" : "/")), "api/signator/benchainupdate").ToString();
// Create HTTP transport objects
HttpRequestMessage _httpRequest = new HttpRequestMessage();
HttpResponseMessage _httpResponse = null;
_httpRequest.Method = new HttpMethod("POST");
_httpRequest.RequestUri = new Uri(_url);
// Set Headers
if (customHeaders != null)
{
foreach (var _header in customHeaders)
{
if (_httpRequest.Headers.Contains(_header.Key))
{
_httpRequest.Headers.Remove(_header.Key);
}
_httpRequest.Headers.TryAddWithoutValidation(_header.Key, _header.Value);
}
}
// Serialize Request
string _requestContent = null;
if (signatoryModel != null)
{
_requestContent = SafeJsonConvert.SerializeObject(signatoryModel, this.Client.SerializationSettings);
_httpRequest.Content = new StringContent(_requestContent, Encoding.UTF8);
_httpRequest.Content.Headers.ContentType = MediaTypeHeaderValue.Parse("application/json; charset=utf-8");
}
// Set Credentials
if (this.Client.Credentials != null)
{
cancellationToken.ThrowIfCancellationRequested();
await this.Client.Credentials.ProcessHttpRequestAsync(_httpRequest, cancellationToken).ConfigureAwait(false);
}
// Send Request
if (_shouldTrace)
{
ServiceClientTracing.SendRequest(_invocationId, _httpRequest);
}
cancellationToken.ThrowIfCancellationRequested();
_httpResponse = await this.Client.HttpClient.SendAsync(_httpRequest, cancellationToken).ConfigureAwait(false);
if (_shouldTrace)
{
ServiceClientTracing.ReceiveResponse(_invocationId, _httpResponse);
}
HttpStatusCode _statusCode = _httpResponse.StatusCode;
cancellationToken.ThrowIfCancellationRequested();
string _responseContent = null;
if ((int)_statusCode != 200)
{
var ex = new HttpOperationException(string.Format("Operation returned an invalid status code '{0}'", _statusCode));
_responseContent = await _httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
ex.Request = new HttpRequestMessageWrapper(_httpRequest, _requestContent);
ex.Response = new HttpResponseMessageWrapper(_httpResponse, _responseContent);
if (_shouldTrace)
{
ServiceClientTracing.Error(_invocationId, ex);
}
_httpRequest.Dispose();
if (_httpResponse != null)
{
_httpResponse.Dispose();
}
throw ex;
}
// Create Result
var _result = new HttpOperationResponse <SignatoryModel>();
_result.Request = _httpRequest;
_result.Response = _httpResponse;
// Deserialize Response
if ((int)_statusCode == 200)
{
_responseContent = await _httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
try
{
_result.Body = SafeJsonConvert.DeserializeObject <SignatoryModel>(_responseContent, this.Client.DeserializationSettings);
}
catch (JsonException ex)
{
_httpRequest.Dispose();
if (_httpResponse != null)
{
_httpResponse.Dispose();
}
throw new SerializationException("Unable to deserialize the response.", _responseContent, ex);
}
}
if (_shouldTrace)
{
ServiceClientTracing.Exit(_invocationId, _result);
}
return(_result);
}
public Task <SignatoryModel> BenChainUpdateTest([PexAssumeUnderTest] SignatorServices target, SignatoryModel signatoryModel)
{
Task <SignatoryModel> result = target.BenChainUpdate(signatoryModel);
return(result);
}
