public JsonResult DeleteRequisition(string ReqisitionId)
{
string ErrorMessage = "";
try
{
////DataTable dtRequisition = objDbTrx.GetSchRequisitionByReqId(Convert.ToInt64(ReqisitionId));
//DataTable dtRequisition = objDbTrx.GetRequisitionDtlByReqIdNew(Convert.ToInt64(ReqisitionId));
DataTable dtRequisition = objDbTrx.GetRequisitionByReqIDNew(Convert.ToInt64(ReqisitionId));
if (dtRequisition.Rows.Count > 0)
{
ErrorMessage = "The Requisition " + dtRequisition.Rows[0]["REQ_CODE"].ToString() + " and Requisition date " + Convert.ToDateTime(dtRequisition.Rows[0]["REQUISITION_DATE"]).ToString("dd-MMM-yyyy") + " deleted successfully";
}
dtRequisition.Dispose();
dtRequisition.Clear();
//objDbTrx.DeleteSchRequisition(ReqisitionId);
objDbTrx.DeleteRequisitionNew(ReqisitionId);
}
catch (Exception ex)
{
ErrorMessage = "Some error occured while deleting requisition. please contact system administrator for further assitence.";
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(ErrorMessage));
}
