public async Task <TelephoneExtension> GetExtension(int RecordId)
{
using (var sqlConnection = new SqlConnection(connectionString))
{
await sqlConnection.OpenAsync();
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("@pRecordId", RecordId);
IEnumerable extension = sqlConnection.QuerySingleOrDefault("bioumum.usp_GetTelephoneExtension", dynamicParameters, commandType: CommandType.StoredProcedure);
TelephoneExtension result = new TelephoneExtension();
if (extension != null)
{
var castItem = (IDictionary <string, object>)extension;
result = new TelephoneExtension
{
BeginDate = Convert.ToDateTime(castItem["BEGDA"]),
EndDate = Convert.ToDateTime(castItem["ENDDA"]),
RecordId = Convert.ToInt32(castItem["RECID"]),
ExtensionType = castItem["ETYPE"].ToString(),
ExtensionName = castItem["EXTNM"].ToString(),
Number = castItem["NUMBR"].ToString(),
ChangeDate = Convert.ToDateTime(castItem["CHGDT"]),
UserChanger = castItem["CHUSR"].ToString()
};
return(result);
}
return(null);
}
}
private readonly string connectionString = GetBioFarmaConnectionString(); //"Server=192.168.212.205\\BIOAPPDEV01;Initial Catalog=BIOFARMA;Persist Security Info=True;User ID=sysdev;Password=P@ssw0rd123";
//private SqlConnection sqlConnection;
public async Task <int> AddExtension(TelephoneExtension TelephoneExtension)
{
using (var sqlConnection = new SqlConnection(connectionString))
{
await sqlConnection.OpenAsync();
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("@pRECID", TelephoneExtension.RecordId);
dynamicParameters.Add("@pPRTID", TelephoneExtension.ParentId);
dynamicParameters.Add("@pETYPE", TelephoneExtension.ExtensionType);
dynamicParameters.Add("@pEXTNM", TelephoneExtension.ExtensionName);
dynamicParameters.Add("@pNUMBR", TelephoneExtension.Number);
dynamicParameters.Add("@pCHUSR", Startup.userNumber);
dynamicParameters.Add("@pActio", 0);
var id = await sqlConnection.ExecuteScalarAsync <int>(
"bioumum.usp_MaintainTelephoneExtension",
dynamicParameters,
commandType : CommandType.StoredProcedure);
return(id);
}
}
public async Task <IActionResult> UpdateTelephoneExtension([FromBody] TelephoneExtension telephoneExtension)
{
await this.extensionDataProvider.UpdateExtension(telephoneExtension);
return(CreatedAtAction(nameof(GetRecordById), new { RecordId = telephoneExtension.RecordId }, null));
}
public async Task <IActionResult> Post([FromBody] TelephoneExtension telephoneExtension)
{
var id = await this.extensionDataProvider.AddExtension(telephoneExtension);
return(CreatedAtAction(nameof(GetRecordById), new { RecordId = id }, null));
}
