/// <summary>
/// Points the of contact duplication check dal.
/// </summary>
/// <param name="_OrganizationRelation">The organization relation.</param>
/// <returns>System.Int32.</returns>
public int PointOfContact_DuplicationCheckDAL(PointsOfContact _OrganizationRelation)
{
return(ExecuteScalarSPInt32("TMS_OrganizationRelationToPerson_DuplicationCheck",
ParamBuilder.Par("PersonID", _OrganizationRelation.PersonID),
ParamBuilder.Par("OrganizationId", _OrganizationRelation.OrganizationID)
));
}
/// <summary>
/// Points the of contact delete dal.
/// </summary>
/// <param name="_OrganizationRelation">The organization relation.</param>
/// <returns>System.Int32.</returns>
public int PointOfContact_DeleteDAL(PointsOfContact _OrganizationRelation)
{
return(ExecuteScalarInt32Sp("TMS_OrganizationRelationToPerson_Delete",
ParamBuilder.Par("ID", _OrganizationRelation.ID),
ParamBuilder.Par("PersonID", _OrganizationRelation.PersonID),
ParamBuilder.Par("OrganizationID", _OrganizationRelation.OrganizationID),
ParamBuilder.Par("UpdatedBy", _OrganizationRelation.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _OrganizationRelation.UpdatedDate)
));
}
/// <summary>
/// Points the of contact create dal.
/// </summary>
/// <param name="_OrganizationRelation">The organization relation.</param>
/// <returns>System.Int64.</returns>
public long PointOfContact_CreateDAL(PointsOfContact _OrganizationRelation)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_OrganizationRelationToPerson_Create", parameters,
ParamBuilder.Par("OrganizationID", _OrganizationRelation.OrganizationID),
ParamBuilder.Par("PersonID", _OrganizationRelation.PersonID),
ParamBuilder.Par("RelationID", _OrganizationRelation.RelationID),
ParamBuilder.Par("IsPrimary", _OrganizationRelation.IsPrimary),
ParamBuilder.Par("CreatedDate", _OrganizationRelation.CreatedDate),
ParamBuilder.Par("CreatedBy", _OrganizationRelation.CreatedBy)
));
}
public ActionResult PointOfContact_Destroy([DataSourceRequest] DataSourceRequest request, PointsOfContact _PointsOfContact)
{
if (ModelState.IsValid)
{
var json = new JavaScriptSerializer().Serialize(_PointsOfContact);
_UserBAL.LogInsert(DateTime.Now.ToString(), "10", Logs.Delete_Success.ToString(), System.Environment.MachineName, "User tried to destroy point of contact at" + DateTime.UtcNow + " with user id =" + CurrentUser.NameIdentifierInt64, "", 0, this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), json.ToString(), CurrentUser.CompanyID);
_PointsOfContact.UpdatedBy = CurrentUser.NameIdentifierInt64;
_PointsOfContact.UpdatedDate = DateTime.Now;
var result = this.OrganizationBAL.PointOfContact_DeleteBAL(_PointsOfContact);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
}
var resultData = new[] { _PointsOfContact };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
public ActionResult PointOfContact_Create([DataSourceRequest] DataSourceRequest request, PointsOfContact _PointsOfContact, string oid)
{
if (ModelState.IsValid)
{
var json = new JavaScriptSerializer().Serialize(_PointsOfContact);
_UserBAL.LogInsert(DateTime.Now.ToString(), "10", Logs.View_Success.ToString(), System.Environment.MachineName, "User tried to create point of contact at" + DateTime.UtcNow + " with user id =" + CurrentUser.NameIdentifierInt64, "", 0, this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), json.ToString(), CurrentUser.CompanyID);
_PointsOfContact.OrganizationID = Convert.ToInt64(oid);
if (this.OrganizationBAL.PointOfContact_DuplicationCheckBAL(_PointsOfContact) == 0)
{
_PointsOfContact.CreatedBy = CurrentUser.NameIdentifierInt64;
_PointsOfContact.CreatedDate = DateTime.Now;
_PointsOfContact.ID = this.OrganizationBAL.PointOfContact_CreateBAL(_PointsOfContact);
}
else
{
ModelState.AddModelError(lr.ErrorServerError, lr.PointofContactDuplicationMessage);
}
}
var resultData = new[] { _PointsOfContact };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
/// <summary>
/// Points the of contact duplication check bal.
/// </summary>
/// <param name="_OrganizationRelation">The organization relation.</param>
/// <returns>System.Int32.</returns>
public int PointOfContact_DuplicationCheckBAL(PointsOfContact _OrganizationRelation)
{
return(DAL.PointOfContact_DuplicationCheckDAL(_OrganizationRelation));
}
/// <summary>
/// Points the of contact delete bal.
/// </summary>
/// <param name="_OrganizationRelation">The organization relation.</param>
/// <returns>System.Int32.</returns>
public int PointOfContact_DeleteBAL(PointsOfContact _OrganizationRelation)
{
return(DAL.PointOfContact_DeleteDAL(_OrganizationRelation));
}
/// <summary>
/// Points the of contact create bal.
/// </summary>
/// <param name="_OrganizationRelation">The organization relation.</param>
/// <returns>System.Int64.</returns>
public long PointOfContact_CreateBAL(PointsOfContact _OrganizationRelation)
{
return(DAL.PointOfContact_CreateDAL(_OrganizationRelation));
}
public ActionResult PointOfContact_Destroy([DataSourceRequest] DataSourceRequest request, PointsOfContact _PointsOfContact)
{
if (ModelState.IsValid)
{
_PointsOfContact.UpdatedBy = CurrentUser.NameIdentifierInt64;
_PointsOfContact.UpdatedDate = DateTime.Now;
var result = this.OrganizationBAL.PointOfContact_DeleteBAL(_PointsOfContact);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
}
var resultData = new[] { _PointsOfContact };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
public ActionResult PointOfContact_Create([DataSourceRequest] DataSourceRequest request, PointsOfContact _PointsOfContact, string oid)
{
if (ModelState.IsValid)
{
_PointsOfContact.OrganizationID = Convert.ToInt64(oid);
if (this.OrganizationBAL.PointOfContact_DuplicationCheckBAL(_PointsOfContact) == 0)
{
_PointsOfContact.CreatedBy = CurrentUser.NameIdentifierInt64;
_PointsOfContact.CreatedDate = DateTime.Now;
_PointsOfContact.ID = this.OrganizationBAL.PointOfContact_CreateBAL(_PointsOfContact);
}
else
{
ModelState.AddModelError(lr.ErrorServerError, lr.PointofContactDuplicationMessage);
}
}
var resultData = new[] { _PointsOfContact };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
