public int AddInterfaceRequest(InterfaceRequestDTO iRequestDetails)
{
int id = _dapperManager.QuerySingle <int>(@"INSERT INTO InterfaceRequest(USER_ID,PROJECT_NAME,NO_INTERFACES,PROJECT_DESCRIPTION,BUDGET_UPPER_LIMIT,BUDGET_LOWER_LIMIT,EXPECTED_TIMELINE,ISDELETED,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,ORDER_STATUS_ID,START_DATE) VALUES (@USERID,@PROJECT_NAME,@NO_INTERFACES,@PROJECT_DESCRIPTION,@BUDGET_UPPER_LIMIT,@BUDGET_LOWER_LIMIT,@EXPECTED_TIMELINE,@ISDELETED,@CREATED_BY,@CREATED_ON,@UPDATED_BY,@UPDATED_ON,@ORDER_STATUS_ID,@START_DATE);SELECT LAST_INSERT_ID()",
new
{
USERID = iRequestDetails.User_Id,
PROJECT_NAME = iRequestDetails.Project_Name,
NO_INTERFACES = iRequestDetails.No_Interfaces,
PROJECT_DESCRIPTION = iRequestDetails.Project_Description,
BUDGET_UPPER_LIMIT = iRequestDetails.Budget_Upper_Limit,
BUDGET_LOWER_LIMIT = iRequestDetails.Budget_Lower_Limit,
EXPECTED_TIMELINE = iRequestDetails.Expected_Timeline,
ISDELETED = iRequestDetails.IsDeleted,
CREATED_BY = iRequestDetails.Created_By,
CREATED_ON = iRequestDetails.Created_On,
UPDATED_BY = iRequestDetails.Updated_By,
UPDATED_ON = iRequestDetails.Updated_On,
ORDER_STATUS_ID = iRequestDetails.Order_Status_Id,
START_DATE = iRequestDetails.Start_Date
});
if (id > 0)
{
return(id);
}
else
{
return(0);
}
}