private CaseNoteModel MapConsultationNote(DataRow row)
{
if (row != null)
{
CaseNoteModel cModel = new CaseNoteModel();
cModel.Id = Convert.ToInt32(row["NoteID"]);
cModel.ConsultationId = Convert.ToInt32(row["ConsultationID"]);
cModel.NoteText = row["NoteText"] != null?Convert.ToString(row["NoteText"]) : string.Empty;
cModel.TenantID = row["TenantID"] != null?Convert.ToInt32(row["TenantID"]) : 0;
cModel.IsDeleted = Convert.ToInt32(row["IsDeleted"]) == 0 ? true : false;
cModel.CreatedBy = Convert.ToInt32(row["CreatedBy"]);
cModel.CreatedByEntity = Convert.ToInt32(row["CreatedByEntity"]);
cModel.CreatedOn = row["CreatedOn"] != null ? new InternalDateTime(Convert.ToInt64(row["CreatedOn"])) : new InternalDateTime();
cModel.ModifiedBy = row["ModifiedBy"] != null?Convert.ToInt32(row["ModifiedBy"]) : 0;
cModel.ModifiedByEntity = row["ModifiedByEntity"] != null?Convert.ToInt32(row["ModifiedByEntity"]) : 0;
cModel.ModifiedOn = row["ModifiedOn"] != null ? new InternalDateTime(Convert.ToInt64(row["ModifiedOn"])) : new InternalDateTime();
cModel.Type = row["Type"] != null?Convert.ToInt32(row["Type"]) : 0;
return(cModel);
}
return(null);
}
private List <Parameter> GetCaseNoteParams(CaseNoteModel model)
{
List <Parameter> param = new List <Parameter>();
param.Add(new Parameter("@NoteText", model.NoteText));
param.Add(new Parameter("@Type", model.Type));
param.Add(new Parameter("@ConsultationID", model.ConsultationId));
param.Add(new Parameter("@TenantID", model.TenantID));
param.Add(new Parameter("@CreatedUserID", model.CreatedBy));
param.Add(new Parameter("@CreatedByEntity", model.CreatedByEntity));
return(param);
}
public CaseNoteViewModel MapConsultationNote(CaseNoteModel model)
{
return(new CaseNoteViewModel()
{
Id = model.Id,
ConsultationId = model.ConsultationId,
NoteText = model.NoteText,
IsDeleted = model.IsDeleted,
TanentId = model.TenantID,
CreatedBy = model.CreatedBy,
CreatedOn = model.CreatedOn,
CreatedByEntity = model.CreatedByEntity,
ModifiedBy = model.ModifiedBy,
ModifiedOn = model.ModifiedOn,
ModifiedEntity = model.ModifiedByEntity,
//Type = model.Type
});
}
public CaseNoteModel SaveCaseNote(CaseNoteModel caseNoteModel)
{
List <Parameter> param = GetCaseNoteParams(caseNoteModel);
Parameter p_IsError = new Parameter("@IsError", DBNull.Value, ParameterDirection.Output, DbType.Int16, 1);
Parameter p_ErrorMsg = new Parameter("@ErrorMsg", DBNull.Value, ParameterDirection.Output, DbType.String, 100);
param.Add(p_IsError);
param.Add(p_ErrorMsg);
var r = dataBaseService.ExecuteScalar(StoredProcedures.InsertCaseNote, DBCommandType.Procedure, param.ToArray());
int Id = Convert.ToInt32(r);
if (Id > 0)
{
caseNoteModel.Success = true;
caseNoteModel.Id = Id;
}
else
{
caseNoteModel.Success = false;
caseNoteModel.ErrorMessage = "Error inserting case note";
}
return(caseNoteModel);
}
