public IHttpActionResult Insert([FromBody] PERMITDC permit)
{
List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>();
try
{
PERMITBL bll = new PERMITBL();
List <PERMITDC> list = new List <PERMITDC>();
string currentPage = permit.CurrentPage;
list.Add(permit);
int id = bll.Insert(list, ref lstException);
permit.PERMIT_ID = id;
//return Ok(id);
if (permit.PERMIT_ID != 0)
{
permit = bll.LoadByPrimaryKey(permit.PERMIT_ID);
permit.CurrentPage = currentPage;
permit.TRANSACTION_SUCCESS = true;
}
return(Ok(new { permit.PERMIT_ID, permit }));
}
catch (Exception ex)
{
//if (ex.Message.Contains("UNIQUE KEY constraint"))
//{
// throw new System.InvalidOperationException("JobNumber");
//}
//else
return(new TextResult(lstException, Request));
}
}
public IHttpActionResult Update([FromBody] PERMITDC permit)
{
List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>();
try
{
var bll = new PERMITBL();
string currentPage = permit.CurrentPage;
//int IsUpdated = 0;
List <PERMITDC> list = new List <PERMITDC>();
list.Add(permit);
int UpdatedCount = bll.Update(list, ref lstException);
if (UpdatedCount != 0)
{
permit = bll.LoadByPrimaryKey(permit.PERMIT_ID);
permit.CurrentPage = currentPage;
permit.TRANSACTION_SUCCESS = true;
}
return(Ok(new { permit.PERMIT_ID, permit }));
//if (UpdatedCount > 0)
// IsUpdated = 1;
//return Ok(UpdatedCount);
}
catch (Exception ex)
{
return(new TextResult(lstException, Request));
}
}
public IHttpActionResult GetByID(int permitid)
{
PERMITBL objUser = new PERMITBL();
PERMITDC objResult = new PERMITDC();
objResult = objUser.LoadByPrimaryKey(permitid);
return(Ok(new { objResult }));
}
public IHttpActionResult GetDashboard(string projectIDs = "All", string permitStatus = "All", string clientIDs = "All", string jobFileNo = "All", string submitedStartDt = "All", string submitedEndDt = "All")
{
PERMITBL objUser = new PERMITBL();
List <PERMITDC> objResultList = new List <PERMITDC>();
objResultList = objUser.LoadDashboard(projectIDs, permitStatus, clientIDs, jobFileNo, submitedStartDt, submitedEndDt);
return(Ok(new { objResultList }));
}
public IHttpActionResult GetAll(string projectIDs = "All")
{
PERMITBL objUser = new PERMITBL();
List <PERMITDC> objResultList = new List <PERMITDC>();
objResultList = objUser.LoadAll(projectIDs);
return(Ok(new { objResultList }));
}
public IHttpActionResult GetJobFileNumbers(String projectIDs)
{
PERMITBL objUser = new PERMITBL();
List <DD_DTO> objResultList = new List <DD_DTO>();
objResultList = objUser.GetJobFileNumbers(projectIDs);
return(Ok(new { objResultList }));
}
public IHttpActionResult Delete([FromBody] List <PERMITDC> objUsers)
{
PERMITBL objUser = new PERMITBL();
List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>();
try
{
int IsDeleted = objUser.Delete(objUsers, ref lstException);
return(Ok(IsDeleted));
}
catch (Exception ex)
{
return(new TextResult(lstException, Request));
}
}
