public override void Update(ContractNote item)
{
if (item.ID == 0)
{
throw new ArgumentNullException("Item.InvoiceGrpId", "An item InvoiceGrpId was provided for the update.");
}
try
{
string sql = String.Format("update {0}.contract_note set "
+ " contract_id = :contract_id "
+ " ,added_dt = sysdate "
+ " ,added_by = user "
+ " ,note = :note "
+ "where contract_note_id = :contract_note_id"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":contract_note_id", item.ID, OracleType.Int32, ParameterDirection.InputOutput));
parameters.Add(OracleHelper.CreateParameter(":contract_id", item.ContractID, OracleType.Int32, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":note", item.Note, OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
}
catch (OracleException ex)
{
throw ex;
}
}
public override void Remove(ContractNote item)
{
string sql = String.Format("delete {0}.contract_note where contract_note_id = :contract_note_id", SchemaName);
OracleParameter[] p = { OracleHelper.CreateParameter(":contract_note_id", item.ID, OracleType.Int32, ParameterDirection.Input) };
OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, p);
}
/// <summary>
/// Add & Edit Contract Notes Info data
/// </summary>
/// <param name="contractNotes"></param>
/// <returns>contractNoteId</returns>
public ContractNote AddEditContractNote(ContractNote contractNotes)
{
ContractNote note = new ContractNote();
//Checks if input request is not null
if (contractNotes != null)
{
_cmd = _db.GetStoredProcCommand("AddEditContractNotes");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_db.AddInParameter(_cmd, "@ContractNoteID ", DbType.Int64, contractNotes.ContractNoteId);
_db.AddInParameter(_cmd, "@ContractID ", DbType.Int64, contractNotes.ContractId);
_db.AddInParameter(_cmd, "@Status", DbType.Int32, contractNotes.Status);
_db.AddInParameter(_cmd, "@NoteText", DbType.String, contractNotes.NoteText.ToTrim());
_db.AddInParameter(_cmd, "@UserName", DbType.String, contractNotes.UserName.ToTrim());
// Retrieve the results of the Stored Procedure in Datatable
DataSet contractNotesDataSet = _db.ExecuteDataSet(_cmd);
if (contractNotesDataSet.IsTableDataPopulated(0))
{
string localDateTime = Utilities.GetLocalTimeString(contractNotes.CurrentDateTime,
Convert.ToDateTime(contractNotesDataSet.Tables[0].Rows[0]["InsertDate"].ToString()));
note.ContractNoteId = long.Parse(contractNotesDataSet.Tables[0].Rows[0]["InsertedId"].ToString());
note.InsertDate = Convert.ToDateTime(localDateTime);
}
}
//returns response to Business layer
return(note);
}
/// <summary>
/// New Note
/// </summary>
public void NewNote()
{
CurrentNote = new ContractNote(0, _contractId, DateTime.Now, UserId, "<Type Text Here>");
ContractNotes.Add(CurrentNote);
IndexText = (ContractNotes.IndexOf(_currentNote) + 1).ToString() + " of " + ContractNotes.Count.ToString();
OnPropertyChanged("ContractNotes");
}
protected override void RowConverter(ContractNote item, DataRow row)
{
item.AddedBy = row["added_by"].ToString();
item.ContractID = int.Parse(row["contract_id"].ToString());
item.DateAdded = DateTime.Parse(row["added_dt"].ToString());
item.ID = int.Parse(row["contract_note_id"].ToString());
item.Note = row["note"].ToString();
}
public JsonResult DeleteContractNotes(int id)
{
ContractNote contractNotes = new ContractNote {
ContractNoteId = id, UserName = GetCurrentUserName()
};
//Get the UserName logged in
bool isSuccess = PostApiResponse <bool>("ContractNote", "DeleteContractNoteById", contractNotes);
return(Json(new { sucess = isSuccess }));
}
public void AddEditContractNoteIfNull()
{
var mockAddEditContractNote = new Mock <IContractNoteRepository>();
mockAddEditContractNote.Setup(f => f.AddEditContractNote(It.IsAny <ContractNote>())).Returns(new ContractNote {
ContractNoteId = 1
});
ContractNoteLogic target = new ContractNoteLogic(mockAddEditContractNote.Object);
ContractNote actual = target.AddEditContractNote(null);
Assert.IsNotNull(actual);
}
public void DeleteContractNoteByIdMockTest1()
{
var mockDeleteContractNoteById = new Mock <IContractNoteRepository>();
ContractNote objDeleteContractNotes = new ContractNote {
ContractNoteId = 1, UserName = "******"
};
mockDeleteContractNoteById.Setup(f => f.DeleteContractNote(objDeleteContractNotes)).Returns(true);
ContractNoteLogic target = new ContractNoteLogic(mockDeleteContractNoteById.Object);
bool actual = target.DeleteContractNote(objDeleteContractNotes);
Assert.AreEqual(true, actual);
}
public override ContractNote Get(ContractNote item)
{
string sql = String.Format("select contract_note_id, contract_id, added_dt, added_by, note \r\n"
+ "from {0}.contract_note \r\n"
+ "where contract_note_id = :contract_note_id"
, SchemaName);
OracleParameter[] p = { OracleHelper.CreateParameter(":contract_note_id", item.ID, OracleType.Int32, ParameterDirection.Input) };
DataTable dt = OracleHelper.ExecuteQuery(base.ConnectionString.Value, sql, p);
if (dt.Rows.Count > 0)
{
return(ConvertDataTableToList(dt)[0]);
}
else
{
throw new RowNotInTableException("The note was not found.");
}
}
/// <summary>
/// Delete Contract Note By Id
/// </summary>
/// <param name="contractNotes"></param>
/// <returns>returnvalue</returns>
public bool DeleteContractNote(ContractNote contractNotes)
{
//holds the response data
bool returnvalue = false;
// Initialize the Stored Procedure
_cmd = _db.GetStoredProcCommand("DeleteContractNotesByID");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_db.AddInParameter(_cmd, "@ContractNoteId ", DbType.Int64, contractNotes.ContractNoteId);
_db.AddInParameter(_cmd, "@UserName ", DbType.String, contractNotes.UserName);
// Retrieve the results of the Stored Procedure in Datatable
int updatedRow = _db.ExecuteNonQuery(_cmd);
//returns response to Business layer
if (updatedRow > 0)
{
returnvalue = true;
}
//returns false if any exception occurs
return(returnvalue);
}
public JsonResult SaveContractNotes(ContractNotesViewModel info)
{
ContractNote note = AutoMapper.Mapper.Map <ContractNotesViewModel, ContractNote>(info);
//Get the Name of User logged in
note.UserName = GetCurrentUserName();
ContractNote responseNote = PostApiResponse <ContractNote>("ContractNote", "AddEditContractNote", note);
if (responseNote.ContractNoteId > 0)
{
return
(Json(
new
{
sucess = true,
Id = responseNote.ContractNoteId,
userName = note.UserName,
insertedTime = Convert.ToDateTime(responseNote.InsertDate).ToString(Constants.DateTimeFormatWithSecond)
}));
}
return(Json(new { sucess = false }));
}
public ContractNote Save([FromBody] ContractNote contractNote)
{
if (contractNote.Id == 0)
{
contractNote.NoteDate = DateTime.Now;
contractNote.AuthorId = _sessionContext.UserId;
}
ModelState.Clear();
TryValidateModel(contractNote);
ModelState.Validate();
if (contractNote.Id > 0)
{
_repository.Update(contractNote);
}
else
{
_repository.Insert(contractNote);
}
return(contractNote);
}
public override void Add(ContractNote item)
{
string sql = String.Format("insert into {0}.contract_note "
+ " (contract_note_id "
+ " ,contract_id ,added_dt "
+ " ,added_by ,note) "
+ "values "
+ " ({0}.contract_note_id.nextval "
+ " ,:contract_id ,:added_dt"
+ " ,:added_by ,:note) "
+ "returning contract_note_id into :contract_note_id"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":contract_note_id", null, OracleType.Int32, ParameterDirection.InputOutput));
parameters.Add(OracleHelper.CreateParameter(":contract_id", item.ContractID, OracleType.Int32, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":added_dt", item.DateAdded, OracleType.Timestamp, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":added_by", item.AddedBy, OracleType.NVarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":note", item.Note, OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
item.ID = int.Parse(parameters[0].Value.ToString());
}
/// <summary>
/// Gets the contract full information.
/// </summary>
/// <param name="contractInfo">The contract information.</param>
/// <returns></returns>
public ContractFullInfo GetContractFullInfo(Contract contractInfo)
{
//holds the response object
ContractFullInfo contractFullInfo = new ContractFullInfo();
// Initialize the Stored Procedure
_cmd = _db.GetStoredProcCommand("GetContractFullInfo");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_db.AddInParameter(_cmd, "@NodeID", DbType.Int64, contractInfo.ContractId);
_db.AddInParameter(_cmd, "@FacilityId", DbType.Int32, contractInfo.FacilityId);
_db.AddInParameter(_cmd, "@UserName", DbType.String, contractInfo.UserName);
// Retrieve the results of the Stored Procedure in Dataset
DataSet contractDataSet = _db.ExecuteDataSet(_cmd);
//Check if output result tables exists or not
if (contractDataSet != null && contractDataSet.Tables.Count > 0)
{
//populating ContractBasicInfo data
if (contractDataSet.Tables[0].Rows != null && contractDataSet.Tables[0] != null && contractDataSet.Tables[0].Rows.Count > 0)
{
contractFullInfo.ContractBasicInfo = new Contract
{
ContractId =
Convert.ToInt64(
contractDataSet.Tables[0].Rows[0]["ContractId"]),
InsertDate =
DBNull.Value ==
contractDataSet.Tables[0].Rows[0]["InsertDate"]
? (DateTime?)null
: Convert.ToDateTime(
contractDataSet.Tables[0].Rows[0]["InsertDate"]),
UpdateDate =
DBNull.Value ==
contractDataSet.Tables[0].Rows[0]["UpdateDate"]
? (DateTime?)null
: Convert.ToDateTime(
contractDataSet.Tables[0].Rows[0]["UpdateDate"]),
ContractName =
Convert.ToString(
contractDataSet.Tables[0].Rows[0]["ContractName"]),
StartDate =
Convert.ToDateTime(
contractDataSet.Tables[0].Rows[0]["StartDate"]),
EndDate =
Convert.ToDateTime(
contractDataSet.Tables[0].Rows[0]["EndDate"]),
FacilityId =
Convert.ToInt32(
contractDataSet.Tables[0].Rows[0]["FacilityId"]),
Status =
DBNull.Value != contractDataSet.Tables[0].Rows[0]["Status"] &&
Convert.ToInt32(contractDataSet.Tables[0].Rows[0]["Status"]) ==
1,
IsClaimStartDate =
DBNull.Value != contractDataSet.Tables[0].Rows[0]["IsClaimStartDate"] &&
Convert.ToInt32(contractDataSet.Tables[0].Rows[0]["IsClaimStartDate"]) ==
1,
IsContractServiceTypeFound =
DBNull.Value != contractDataSet.Tables[0].Rows[0]["IsContractServiceTypeFound"] &&
Convert.ToInt32(contractDataSet.Tables[0].Rows[0]["IsContractServiceTypeFound"]) ==
1,
IsProfessional =
DBNull.Value != contractDataSet.Tables[0].Rows[0]["IsProfessionalClaim"] &&
Convert.ToInt32(contractDataSet.Tables[0].Rows[0]["IsProfessionalClaim"]) ==
1,
IsInstitutional =
DBNull.Value != contractDataSet.Tables[0].Rows[0]["IsInstitutionalClaim"] &&
Convert.ToInt32(contractDataSet.Tables[0].Rows[0]["IsInstitutionalClaim"]) ==
1,
NodeId =
DBNull.Value == contractDataSet.Tables[0].Rows[0]["NodeId"]
? (long?)null
: Convert.ToInt64(
contractDataSet.Tables[0].Rows[0]["NodeId"]),
IsModified =
DBNull.Value ==
contractDataSet.Tables[0].Rows[0]["IsModified"]
? (int?)null
: Convert.ToInt32(
contractDataSet.Tables[0].Rows[0]["IsModified"]),
ThresholdDaysToExpireAlters =
DBNull.Value ==
contractDataSet.Tables[0].Rows[0]["ThresholdDaysToExpireAlters"]
? (int?)null
: Convert.ToInt32(
contractDataSet.Tables[0].Rows[0]["ThresholdDaysToExpireAlters"]),
PayerCode = Convert.ToString(
contractDataSet.Tables[0].Rows[0]["PayerCode"]),
CustomField = DBNull.Value ==
contractDataSet.Tables[0].Rows[0]["CustomField"]
? (int?)null
: Convert.ToInt32(
contractDataSet.Tables[0].Rows[0]["CustomField"]),
};
}
//Populating ContractPayer's data
if (contractDataSet.Tables[1].Rows != null && contractDataSet.Tables[1] != null && contractDataSet.Tables[1].Rows.Count > 0)
{
if (contractInfo.ContractId == 0)
{
contractFullInfo.ContractBasicInfo = new Contract();
}
contractFullInfo.ContractBasicInfo.Payers = new List <Payer>();
for (int i = 0; i < contractDataSet.Tables[1].Rows.Count; i++)
{
Payer payer = new Payer
{
PayerName = Convert.ToString(contractDataSet.Tables[1].Rows[i]["PayerName"]),
IsSelected = Convert.ToBoolean(contractDataSet.Tables[1].Rows[i]["IsSelected"]),
};
contractFullInfo.ContractBasicInfo.Payers.Add(payer);
}
}
//populating Contract payer Info ID's data
contractFullInfo.ContractContactIds = new List <Int64>();
if (contractDataSet.Tables[2].Rows != null && contractDataSet.Tables[2] != null && contractDataSet.Tables[2].Rows.Count > 0)
{
for (int i = 0; i < contractDataSet.Tables[2].Rows.Count; i++)
{
Int64 contractPayerInfoId = Convert.ToInt64(contractDataSet.Tables[2].Rows[i]["ContractPayerInfoId"]);
contractFullInfo.ContractContactIds.Add(contractPayerInfoId);
}
}
//populating ContractNotes data
if (contractDataSet.Tables[3].Rows != null && contractDataSet.Tables[3] != null && contractDataSet.Tables[3].Rows.Count > 0)
{
contractFullInfo.ContractNotes = new List <ContractNote>();
for (int i = 0; i < contractDataSet.Tables[3].Rows.Count; i++)
{
string currentDateTime = Utilities.GetLocalTimeString(contractInfo.CurrentDateTime,
Convert.ToDateTime((contractDataSet.Tables[3].Rows[i]["InsertDate"].ToString())));
ContractNote contractNote = new ContractNote
{
ContractNoteId =
Convert.ToInt64(
contractDataSet.Tables[3].Rows[i]["ContractNoteID"]),
ContractId =
DBNull.Value == contractDataSet.Tables[3].Rows[i]["ContractID"]
? (long?)null
: Convert.ToInt64(
contractDataSet.Tables[3].Rows[i]["ContractID"]),
InsertDate =
DBNull.Value == contractDataSet.Tables[3].Rows[i]["InsertDate"]
? (DateTime?)null
: Convert.ToDateTime(
contractDataSet.Tables[3].Rows[i]["InsertDate"]),
ShortDateTime = DBNull.Value == contractDataSet.Tables[3].Rows[i]["InsertDate"]
? string.Empty
: Convert.ToDateTime(
currentDateTime).ToString("MM/dd/yyyy hh:mm:ss"),
UpdateDate =
DBNull.Value == contractDataSet.Tables[3].Rows[i]["UpdateDate"]
? (DateTime?)null
: Convert.ToDateTime(
contractDataSet.Tables[3].Rows[i]["UpdateDate"]),
NoteText =
Convert.ToString(contractDataSet.Tables[3].Rows[i]["NoteText"]),
UserName = DBNull.Value == contractDataSet.Tables[3].Rows[i]["UserName"] ? string.Empty : Convert.ToString(contractDataSet.Tables[3].Rows[i]["UserName"])
};
contractFullInfo.ContractNotes.Add(contractNote);
}
}
//populating ContractDocs data
if (contractDataSet.Tables[4].Rows != null && contractDataSet.Tables[4] != null && contractDataSet.Tables[4].Rows.Count > 0)
{
contractFullInfo.ContractDocs = new List <ContractDoc>();
for (int i = 0; i < contractDataSet.Tables[4].Rows.Count; i++)
{
ContractDoc contractDocs = new ContractDoc
{
ContractDocId =
Convert.ToInt64(
contractDataSet.Tables[4].Rows[i]["ContractDocID"]),
InsertDate =
DBNull.Value == contractDataSet.Tables[4].Rows[i]["InsertDate"]
? (DateTime?)null
: Convert.ToDateTime(
contractDataSet.Tables[4].Rows[i]["InsertDate"]),
UpdateDate =
DBNull.Value == contractDataSet.Tables[4].Rows[i]["UpdateDate"]
? (DateTime?)null
: Convert.ToDateTime(
contractDataSet.Tables[4].Rows[i]["UpdateDate"]),
ContractId =
DBNull.Value == contractDataSet.Tables[4].Rows[i]["ContractID"]
? (long?)null
: Convert.ToInt64(
contractDataSet.Tables[4].Rows[i]["ContractID"]),
ContractContent =
DBNull.Value ==
contractDataSet.Tables[4].Rows[i]["ContractContent"]
? null
: (byte[])contractDataSet.Tables[4].Rows[i]["ContractContent"],
FileName =
Convert.ToString(contractDataSet.Tables[4].Rows[i]["FileName"])
};
contractFullInfo.ContractDocs.Add(contractDocs);
}
}
}
//returns response to Business layer
return(contractFullInfo);
}
public ContractNote AddEditContractNote(ContractNote contractNotes)
{
return(_contractLogic.AddEditContractNote(contractNotes));
}
public bool DeleteContractNoteById(ContractNote contractNotes)
{
return(_contractLogic.DeleteContractNote(contractNotes));
}
/// <summary>
/// Deletes the contract note by unique identifier.
/// </summary>
/// <param name="contractNotes">The contract note unique identifier.</param>
/// <returns></returns>
public bool DeleteContractNote(ContractNote contractNotes)
{
return(_contractNotesRepository.DeleteContractNote(contractNotes));
}
/// <summary>
/// Adds the edit contract note.
/// </summary>
/// <param name="contractNotes">The contract notes.</param>
/// <returns></returns>
public ContractNote AddEditContractNote(ContractNote contractNotes)
{
return(_contractNotesRepository.AddEditContractNote(contractNotes));
}
