/// <summary>
/// TMSs the notes delete dal.
/// </summary>
/// <param name="_objTMS_Notes">The object TMS notes.</param>
/// <returns>System.Int32.</returns>
public int TMS_Notes_DeleteDAL(TMS_Notes _objTMS_Notes)
{
return(ExecuteScalarInt32Sp("TMS_Notes_Delete",
ParamBuilder.Par("ID", _objTMS_Notes.ID),
ParamBuilder.Par("UpdatedBy", _objTMS_Notes.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objTMS_Notes.UpdatedDate)));
}
/// <summary>
/// TMSs the notes create dal.
/// </summary>
/// <param name="_objTMS_Notes">The object TMS notes.</param>
/// <returns>System.Int64.</returns>
public long TMS_Notes_CreateDAL(TMS_Notes _objTMS_Notes)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_Notes_Create", parameters,
ParamBuilder.Par("OpenID", _objTMS_Notes.OpenID),
ParamBuilder.Par("OpenType", _objTMS_Notes.OpenType),
ParamBuilder.Par("OrganizationID", _objTMS_Notes.OrganizationID),
ParamBuilder.Par("NotesText", _objTMS_Notes.NotesText),
ParamBuilder.Par("CreatedBy", _objTMS_Notes.CreatedBy),
ParamBuilder.Par("CreatedDate", _objTMS_Notes.CreatedDate)));
}
public ActionResult OpenNotes_Update([DataSourceRequest] DataSourceRequest request, TMS_Notes _TMS_Notes)
{
if (ModelState.IsValid)
{
_TMS_Notes.UpdatedBy = CurrentUser.NameIdentifierInt64;
_TMS_Notes.UpdatedDate = DateTime.Now;
var result = this.CommonBAL.TMS_Notes_UpdateBAL(_TMS_Notes);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
}
var resultData = new[] { _TMS_Notes };
return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState)));
}
public ActionResult OpenNotes_Create([DataSourceRequest] DataSourceRequest request, TMS_Notes _TMS_Notes, long OpenId, int Opentype)
{
if (ModelState.IsValid)
{
_TMS_Notes.CreatedBy = CurrentUser.NameIdentifierInt64;
_TMS_Notes.CreatedDate = DateTime.Now;
_TMS_Notes.OrganizationID = CurrentUser.CompanyID;
_TMS_Notes.OpenID = OpenId;
_TMS_Notes.OpenType = Opentype;
_TMS_Notes.ID = this.CommonBAL.TMS_Notes_CreateBAL(_TMS_Notes);
}
var resultData = new[] { _TMS_Notes };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
/// <summary>
/// TMSs the notes delete bal.
/// </summary>
/// <param name="_objTMS_Notes">The object TMS notes.</param>
/// <returns>System.Int32.</returns>
public int TMS_Notes_DeleteBAL(TMS_Notes _objTMS_Notes)
{
return(DAL.TMS_Notes_DeleteDAL(_objTMS_Notes));
}
/// <summary>
/// TMSs the notes create bal.
/// </summary>
/// <param name="_objTMS_Notes">The object TMS notes.</param>
/// <returns>System.Int64.</returns>
public long TMS_Notes_CreateBAL(TMS_Notes _objTMS_Notes)
{
return(DAL.TMS_Notes_CreateDAL(_objTMS_Notes));
}